Share this Job

Extract, Transfer and Load Developer - ETL (Computer Services Officer 4)



Competition # : 36347 

Department: Health and Wellness

Location: HALIFAX

Type of Employment: Permanent

Union Status: NSGEU - NSPG 

Closing Date: 10/6/2022​ (Applications are accepted until 11:59 PM Atlantic Time)

About Us


The Department of Health and Wellness offers opportunities to grow and advance in a dynamic sector that touches the lives of all Nova Scotians.  Along with our partners, including Nova Scotia Health and the IWK Health Centre, we are committed to continually improving our health care system. With a focus on collaborative primary health care, continuing care, improved supports for mental health and addictions, digital health, capital infrastructure, and more, the department is thinking differently about how to plan, fund, legislate and monitor to improve access and service delivery. To do this, we’re recruiting individuals at all levels of the organization who embrace a challenge and believe in their ability to make a difference.


More specifically, the Data Governance and Management division ensures trusted data and information is available and used by all levels of the organization to support the Department’s vision of Healthy Nova Scotians.


About Our Opportunity


The Extract, Transfer and Load (ETL) Developer is a senior technical resource in the Data Governance and Management division at DHW.  In this role, you will be responsible for the development and maintenance of data extract, transform, and load (ETL) processes.  You will work with stakeholders throughout DHW and the broader health sector, to translate business requirements into technical requirements for customized data feeds and products.


In this role, you will have a contributory impact on the health system’s analytics functions. Your expertise and leadership will enhance health system planning and management capabilities; strengthening our health information systems.


Primary Accountabilities


Your key responsibilities will involve the development, operation, and ongoing sustainment of DHW’s health data warehouse, including custom data products for DHW program areas and the broader health sector.  You will lead large data transformation activities using proven technology to design, build, implement, and operate cross-Health System data products.


Using your expert data transformation knowledge, you will help facilitate evidence-based decision making to inform strategic policy throughout DHW. You will achieve this by:


  • Collaborating with colleagues and stakeholders to define technical requirements for the health data warehouse
  • Researching and monitoring industry best practices and trends relating to delivering data products and services
  • Developing ETL packages and data pipelines to integrate disparate data sources into a data warehouse platform to support business reporting, analytics, and strategic decision-making
  • Creating and executing test-cases for unit and integration testing within the data warehouse
  • Assisting with creation of standards and practices for ETL design and implementation


Qualifications and Experience


As our next ETL Developer, you have a bachelor’s degree in information technology and 5 years of related experience; or have graduated from a recognized Information Technology Program plus 5 years and 6 months of related experience. Experience in database or data warehouse design and implementation as well significant experience working closely with various stakeholders.


We are looking for an experienced ETL developer who has excellent analytical and problem-solving skills, operates easily in a matrix capacity, enjoys working in an innovative environment, and is a self-starter.


You must be able to demonstrate your experience with ETL development and data integration. Furthermore, you:


  • have several years of experience with ETL/data integration
  • have experience working with dimensional data models and other analytic data structures
  • have experience creating, executing, and documenting test cases for data integration
  • possess deep knowledge of, and experience with, SQL programming and SSIS
  • are proficient with Microsoft Suite (Word, Excel, Outlook, etc.)
  • are flexible and adaptable to changing priorities and competing deadlines
  • possess superior communication and relationship building skills


Familiarity with Microsoft SQL Server, the Kimball data warehouse architecture method, TimeXtender (formerly Discovery Hub), Tableau Server, and other programming languages (Python, PowerShell, etc.) would be considered assets.


We will assess the above qualifications and competencies using one or more of the following tools: written examination, standardized tests, oral presentations, interview(s), and reference checks.




An equivalent combination of training, education and experience will be considered. Applicants relying on education and experience equivalencies must demonstrate such equivalencies in their application.




Based on the employment status and union agreement, the Government of Nova Scotia offers its employees a wide range of benefits such as Health, Dental, Life Insurance, Pension, General Illness (Short and Long Term), Vacation and Employee and Family Assistance Programs. Click here to learn more about our various benefits offerings and eligibility criteria.


Working Conditions


Most of your time is spent in a comfortable office setting with some site visits as required.


Your normal work week is 35 hours/week, 7 hours/day (and may require availability 24/7 during times of emergency and working overtime on occasion).


Additional Information


This position requires the successful candidate to work on-site.


What We Offer


  • Career Development where you have access to career guidance, tools, resources, and ongoing training for every stage of your career.
  • Engaging workplace. Our Employees feel valued, respected, connected, and tuned in. We have forward-thinking policies and strategies.
  • Countless Career Paths.
  • Department Specific Flexible working schedules.



Pay Grade:  PR 17  

Salary Range:  $3,001.65 - $3,525.41 Bi-Weekly


Employment Equity Statement:

Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we serve.  The Government of Nova Scotia has an Employment Equity Policy, and we welcome applications from Indigenous People, African Nova Scotians and Other Racially Visible Persons, Persons with Disabilities and Women in occupations or positions where they are under-represented.  If you are a member of one of these equity groups, you are encouraged to self-identify on your electronic application.


This is a bargaining unit position initially restricted to current civil service employees represented by the Nova Scotia Government Employees Union (NSGEU). If applying from outside a government office, employees must apply correctly via this link:



 Failure to apply correctly means that your application will not be given first consideration as a bargaining unit applicant, and will only be included if external applications are pursued. 


External applicants and current casual employees will only be considered if there are no qualified civil service bargaining unit candidates. PLEASE NOTE: Candidates will not be considered for an interview if applications are incomplete or are missing information. 


Offer of employment is conditional upon the completion of all applicable background checks and confirmation of credentials, the results of which must be satisfactory to the employer. We thank all applicants for the interest, however, only those selected for an interview will be contacted. All questions and concerns may be directed to