You're using an older version of Internet Explorer that is no longer supported. Please update your browser.
BC Public Service

ISL 27R - Data Warehouse Architect

Abbotsford, BC
Full Time
2 days ago
75,552 to 86,175 per year
Posting Title

ISL 27R - Data Warehouse Architect

Position Classification

Information Systems R27




Abbotsford, BC V2S 1H4 CA
Campbell River, BC V9W 6Y7 CA
Cranbrook, BC V1C 7G5 CA
Fort Nelson, BC V0C 1R0 CA
Hope, BC V0X 1L0 CA
Kamloops, BC V2H 1B7 CA
Kelowna, BC V1Z 2S9 CA
Multiple Locations, BC CA (Primary)
Nanaimo, BC V9T 6L8 CA
Nelson, BC V1L 6K1 CA
Prince George, BC V2N4P7 CA
Smithers, BC V0J 2N0 CA
Surrey, BC V4P 1M5 CA
Vancouver, BC V6B 0N8 CA
Victoria, BC V9B 6X2 CA
Williams Lake, BC V2G 5M1 CA

Salary Range

$75,552.53 - $86,175.83 annually plus 9.9% Temporary Market Adjustment

Close Date


Job Type

Regular Full Time

Temporary End Date


BC Public Service -> Education and Child Care

Ministry Branch / Division

Digital Strategies & Services/Services & Technology

Job Summary

Data Warehouse Architect
Information Systems R27

An eligibility list may be established.

We offer flexible work arrangements, including the opportunity to volunteer to telework (with conditions) as set out in applicable employer policies. The locations listed above are to assist applicants in searching for this opportunity. This position may be performed in other approved locations within the province of BC. For specific information about a location, applicants should contact the hiring manager.

On November 1, 2021 the BC Public Service announced the COVID-19 Vaccination Policy that defines the conditions and expectations for BC Public Service employees regarding vaccination against COVID-19. Among other possible measures, proof of vaccination will be required. It is a term of acceptance of employment that you agree to comply with all vaccination requirements that apply to the public service. More information can be found here .

An excellent opportunity to join this dynamic team and apply your technological skills

Education and child care are the cornerstones of a thriving and equitable society. They develop students' and children's minds and help them to become critical thinkers. They allow learners to develop compassionate worldviews and consider important issues including diversity, equity, and inclusion, as foundational values of healthy communities. Education and child care also play a key role in government's commitment to putting people first and in building a sustainable economy.

The Data Warehouse Architect leads the technical design, development and maintenance of the ministry's data warehouse and integrates data from various applications including multi-dimensional data cubes.

With over 200 different occupations available in 280 communities across the province, we offer exciting opportunities for your career. Come be a part of the BC Public Service, a Top 100 Employer that embraces diversity, health and career growth. For more information, please see What We Offer.

The BC Public Service is committed to creating a diverse workplace to represent the population we serve and to better meet the needs of our citizens. Consider joining our team and being part of an innovative, inclusive and rewarding workplace.

For information about the Indigenous Applicant Advisory Service please visit: Indigenous Applicant Advisory Service - Province of British Columbia ( .

For complete details about this opportunity, including accountabilities, please refer to the attached job profile. For specific position related enquiries, please contact . DO NOT SEND YOUR APPLICATION TO THIS EMAIL ADDRESS. For more information about how to complete your job application, add/edit your resume and for more useful tips when applying for jobs, please refer to the Your Job Application page on the MyHR website. If you are still experiencing technical difficulty applying for a competition, please send an e-mail to , before the stated closing time, and we will respond as soon as possible to assist you.

NOTE: Applications will be accepted until 11:00 pm Pacific Standard Time on the closing date of the competition.

Job Requirements:
In order to be considered for this position, your application must clearly demonstrate how you meet the education and experience as outlined below:

  • Bachelor's Degree in Computer Science, or equivalent, and a minimum 2years of related experience*; OR
  • Diploma or certification in Computer Science, or equivalent, and a minimum 4 years of related experience*; OR
  • Some post-secondary education or training in Computer Science, or equivalent, and a minimum 6years of related experience*.

Related experience* must include:
  • Experience in business area analysis techniques.
  • A minimum of two years' experience designing and implementing database models.
  • Experience with Structured Query Language (SQL) development.
  • Involvement in complex systems projects in a data management/data design role including participating in the development of data models.
  • Experience with relational database systems, including performance optimization techniques.
  • Experience with data management principles and structured analysis and design.

Preference may be given to applicants with any or all of the following:
  • Experience with Agile business analysis techniques.
  • Experience developing policy and standards documents.
  • Experience with continuous integration/continuous delivery.
  • Experience with scripted languages such as PL/SQL, Python, Groovy, etc.

  • Willingness to provide on call 24-hour support during peak periods.

Applicants selected to move forward in the hiring process may be assessed on the Knowledge, Skills, Abilities and Competencies as outlined in the attached Job Profile located in the Additional Information section at the bottom of the posting.

A Criminal Record Check (CRC) will be required.


Cover Letter: NO - Please do not submit a cover letter as it will not be reviewed.

Resume: YES - Ensure your resume includes your educational accomplishments, employment history including start and end dates (month and year) of your employment, and any relevant information that relates to the job to which you are applying.

Questionnaire (STANDARD): YES - You will be required to answer a standard questionnaire.

Job Category

Information Management/Information Technology
Information Technology Management and Executive