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

ISL 24R - ETL (Extract, Transform and Load) Specialist

Full Time
73,855 to 84,134 per year
Posting Title
ISL 24R - ETL (Extract, Transform and Load) Specialist

Position Classification
Information Systems R24


Work Options

Multiple Locations, BC CA (Primary)
Vancouver, BC V6B 0N8 CA
Victoria, BC V9B 6X2 CA

Salary Range
$73,855.42 - $84,134.34 annually plus 6.6% Temporary Market Adjustment

Close Date

Job Type
Regular Full Time

Temporary End Date

BC Public Service -> Health

Ministry Branch / Division
Health Sector Information, Analysis and Reporting /Data Management and Stewardship

Job Summary

An excellent opportunity to apply your technical expertise

The Health Sector Information, Analysis and Reporting Division (HSIAR) sets the foundation for the delivery of high-quality health sector information, analytics and reporting. The Division leads key information management functions including data stewardship, governance, security, access, analytics and reporting, quality assurance, performance measurement and evaluations functions. HSIAR sets out to exercise effective governance over data resources, while enabling timely and secure access to data, supporting an integrated, modernized model of information sharing across the health sector. The Division leads the overarching provincial analytic strategy and approach, and performs comprehensive, integrated analysis of health sector performance to ensure a consistent and timely approach to health system measurement utilizing a client centred approach.

Data Management and Stewardship (DMS) provides leadership in the use of, and access to, health data to support evidence-informed decisions, policy, analysis and research directed to achieving improvements in health outcomes. The branch is responsible for the development and implementation of a strategic vision for health secondary data management and data security, ensuring that ministry data assets are appropriately managed and effectively leveraged.

The ETL Specialist provides technical expertise and advice in the design and development of new and/or enhanced custom applications, leads the technical implementation of custom applications, conducts technical quality assurance audits / post implementation reviews, designs, codes, tests and implements application fixes, and updates, documents and supports infrastructure related tools and utilities.

Job Requirements:
  • Degreein Computer Science, Software Engineering or other related discipline and a minimum of 2 years recent related experience; OR
  • Diploma or Certificate in Computer Science, Software Engineering or other related discipline and a minimum of 3 years of recent related experience may be considered; OR
  • An equivalent combination of education and experience may be considered.

Recent Related Experience Must Include All of the Following:
  • Experience in ETL development and operation support.
  • Experience in Data Warehouse security.
  • Experience in multidimensional data models.
  • Experience in data warehouse design methodologies and architecture.
  • Experience in development with relational database systems, Structured Query Language, relational data modeling and data management principles, structured analysis and design, and documentation of business requirements.

Preference may be given to applicants with:
  • Familiarity (experience) with emerging technologies such as Cloud Computing.

For questions regarding this position, please contact .

About this Position:

There is currently one (1) permanent position available.

An eligibility list may be established to fill future permanent and/or temporary vacancies.

This position can be based in any of the following Ministry of Health offices: Victoria and Vancouver.

Flexible work options are available; this position may be able to work from home a few days a week as per the Telework Agreement.

Working for the BC Public Service:

The BC Public Service offers a healthy work/life balance, excellent benefits, including one of the best pension plans available, and a variety of opportunities for career learning and development. To learn more, watch Working For The BC Public Service . In addition, the BC Public Service is an award winning employer in British Columbia, including such accolades as being one of BC's Top Employers for 2022, one of Canada's Top 100 Employers for 2022 and one of Canada's Top Family-Friendly Employers in 2022.

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.

The Indigenous Applicant Advisory Service is available to applicants that self-identify as Indigenous (First Nations, status or non-status, Métis, or Inuit) seeking work or already employed in the BC Public Service. For guidance on applying and interviewing, please contact or 778-405-3452.

How to Apply:

Your application must clearly demonstrate how you meet the job requirements list above.

Resume: 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: As part of the application process, you will be prompted to complete an online questionnaire to demonstrate how you meet the job requirements.

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

Helpful tips, videos and more regarding the application process can be found on the Your Job Application page of MyHR. If you are experiencing technical difficulty applying, e-mail , before the stated closing time, and we will respond as soon as possible.

Additional Information:

A Criminal Record Check (CRC) will be required.

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 at the bottom of the posting.

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

Job Category
Health Services, Information Management/Information Technology