Competition # : 38255
Department: Health and Wellness
Location: HALIFAX
Type of Employment: Permanent
Union Status: NSGEU - NSPG
Closing Date: 3/17/2023 (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 are available and used by all levels of the organization to support the Department\'s 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\'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
• 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\'s 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\' 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 here 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.