Job Description

Competition # : 38255

Department: Health and Wellness

Location: HALIFAX

Type of Employment: Permanent

Union Status: NSGEU - NSPG

Closing Date: \xe2\x80\x8b3/17/2023\xe2\x80\x8b (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\xe2\x80\x99re 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 are available and used by all levels of the organization to support the Department\xe2\x80\x99s vision of Healthy Nova Scotians.

About Our Opportunity

The 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 customised data feeds and products.

In this role, you will have a contributory impact on the health system\xe2\x80\x99s 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\xe2\x80\x99s 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
• Create and execute 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\xe2\x80\x99s degree in information technology, computer science, or engineering and 5 years related experience; or have graduated from a recognized Information Technology Program + 5 years and 6 months 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\xe2\x80\x99 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.

Equivalency

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.

Benefits

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 to learn more about our various benefits offerings and eligibility criteria.

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.

Mentorship through iNSpire; a new formal, interdepartmental mentorship program that connects employees so they can gain knowledge and experience to support their career development.

Countless Career Paths.

Department Specific Flexible working schedules.

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).

Pay Grade: PR 17

Salary Range: $3,091.70 - $3,631.17 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 Competitions@novascotia.ca.

Government of Nova Scotia