Data Management Architect (Computer Services Officer 4)

 

 

Competition # : 45591 

Department: Health and Wellness

Location: HALIFAX

Type of Employment: Term

Union Status: NSGEU - NSPG 

Closing Date: ​04-Apr-25 ​ (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 the Nova Scotia Health Authority and the IWK Health Centre, we are committed to continually improving our health care system. The Department is thinking differently about how to plan, fund, legislate and monitor to improve access and service delivery. To do this, we need leaders at all levels of the organization who embrace a challenge and believe in their ability to make a difference

About Our Opportunity

 

Reporting to the Accountability Manager, Physician Services, the Data Management Architect will provide data system administration, analysis, interpretation, and operational data management to support physician remuneration, performance management, and decision-making for the Department of Health and Wellness (DHW). As a key data liaison for physician remuneration, you will work with internal and external stakeholders, to translate data analysis into policy and business rules. The Data Management Architect has the responsibility for developing SQL databases, integration and validation of data from various sources, generation of complex scripts and queries, and the programming of data management dashboards via Tableau and PowerBI.

 

There is a high level of autonomy in this role. As the Data Management Architect, you will make and implement analyses, as well as develop databases and algorithms where required information is incomplete and or ambiguous but sufficient to exercise sound judgment. You will balance this autonomy with an appropriate level of dialogue and consultation with the Accountability Manager, Project Executive, and other leadership as appropriate.

Primary Accountabilities

 

The Data Management Architect is responsible to the Accountability Manager, Physician Services. You will work closely with the Associate Data Scientist, Data Visualization Architect and the Planning, Performance and Digital team to complete all tasks. Coordination with the entire Physicians services team, inter-department and external stakeholder engagements is the key to job success.

 

You will work closely with the Data Visualization Architect in the evolution of data management and visualization for the branch. While able to perform work functions encompassing back and front end data management, the Data Management Architect will focus on server, source data and database management, overlapping with the Data Visualization architect who will focus on database, data utilization and dashboard visualization.

 

Key responsibilities include:

• Technical Leadership: Leads the development, operation, and ongoing sustainment of physician remuneration databases and Tableau/PowerBI dashboards for the operational execution of the Physician Agreement and Clinical/Academic Funding Plan contracts while prioritizing data integrity and accuracy. Is responsible for the architecture, storage, and management of physician billing and payment data. Translates raw system data into consumable information for decision makers, while quantifying the strengths and limitations in the interpretation of the data.

• Development and Innovation: Identifies innovative analysis techniques and the use of new data sources to provide new insights for health system planning. Encourages prudent risk-taking, exploration of alternative approaches, and organizational learning. Mobilizes others to support change through times of stress and uncertainty. Clearly identifies data gaps while proactively identifying and mitigating areas of data integrity risk.

• Technical Expertise: Works with health system data warehouses, customizing data product client interface, and program management tools from various sources to serve $1.2 billion of remuneration programming. Expertly uses SQL databases, Azure cloud and with working knowledge of dashboards (via Tableau and PowerBI preferred) to provide operationalization of data to support program implementation and evolution.

• Policy Development: Builds data retention, and algorithm change management policy for the branch, ensuring alignment with broader digital and cyber security policies. Establishes detailed process and standards for operational and audit compliance.

• Strategic Advice: Advises executive level leadership on key decisions affecting physician remuneration through qualitative and quantitate options analysis. Enables prudent decision making through data transparency and sound data governance. Working with subject matter experts, provides business metrics for initiatives and use cases to show improvements that demonstrate the following scientific qualities: clarity, accuracy, precision, relevance, depth, breadth, logic, significance, and fairness.
   

Qualifications and Experience

 

A Bachelor’s Degree in Information Technology plus 5 years related experience; or graduation from a recognized Information Technology Program with 5 years and 6 months related experience is required.

 

Strong skills in the use of Excel including pivot tables, effective use of functions and macros to improve efficiency via automation or for the analyzing of large datasets is required and may be tested.

 

Advanced skills in building of databases and coding in Microsoft SQL is required, must be evident in your application and may be tested. Experience with Microsoft Azure data tools (e.g. Databricks, Synapse, Azure Data Factory) is an asset.

 

Demonstrated, recent experience coding analyses and data cleansing in Python is considered highly desirable and must be evident in your application.

 

The successful applicant must be comfortable with a fast-paced environment and be able to integrate new information quickly. A strong operational focus and insatiable desire to continue learning in a highly collaborative team is essential. Knowledge of the physician remuneration models in Nova Scotia is highly desirable.

 

Qualifications and competencies may be assessed using one or more of the following tools: scenario-based examination, standardized tests, oral presentations, interview(s), and reference checks.

Equivalency

 

An equivalent combination of training and experience to the education requirement will be considered. Applicants relying on 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 a Defined Benefit Pension Plan, Health, Dental, Life Insurance, General illness, Short and Long Term Disability, Vacation and Employee and Family Assistance Programs.  For information on all our Benefit program offerings, click here: Benefits for government employees.

 

Working Conditions

 

Most of your time is spent in a comfortable office setting. You will have daily contact with various internal and external client partners. The scope of this role requires strong abilities in multi-tasking, balancing multiple priorities, meeting frequent deadlines, and making time sensitive recommendations.

Additional Information

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,107.16 - $3,649.33 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.