Data Engineer

Job Description

Position Summary:

 

The Data Engineer is responsible for the design, build, maintenance and enhancement of the analytics data infrastructure supporting all Enterprise Analytics solutions at Mackenzie Health.  The Data Engineer possesses sophisticated technical skillsets to inform analytic infrastructure architecture to support efficient querying, effective organization and maintenance, and supportive of desired user experiences & functionality.  With a passion for data governance, the Data Engineer champions thoughtful management of persisted concepts and cohorts, designs for scalability, and thrives leveraging innovative and novel techniques to integrate data from disparate, and sometimes unstructured, sources.  Reporting to the Lead, Analytic Solutions & Infrastructure, the Data Engineer plays a critical role supporting the Analytics Consultants, Developers and Solutions Architect to address strategic data and analytic questions. 

The Data Engineer is a new role for this team, created to advance Mackenzie Health’s analytics maturity, and in alignment with broader organizational objectives.  The Enterprise Analytics team also includes Database and Business Objects Administrators to support and collaborate with the Data Engineer in designing and enabling solutions. 

The successful individual will advise, direct and develop solutions relating to data warehousing, ETL, ingestion, cleansing, automation; and consider how to address unique tool capabilities (in Tableau, PowerApps, Cogito) and business requirements in the underlying data models. 

Primary Responsibilities:

 

Data Engineering Leadership

• Provide technical direction, standards, quality control oversight, and expertise to ensure integration of prioritized projects, including historical and forthcoming
• Collaborate with stakeholders at all levels of the organization to ensure access to timely, accurate solutions to support operational needs, strategic projects, and broader enterprise analytics requirements
• Manage data integration, including designing and implementing solutions to integrate data from multiple sources and ensuring the proper transformation and cleansing
• Define data models and schema to accurately represent the organization’s data and supportive of efficient storage and retrieval
• Design and build data pipelines, including extraction and ingestion
• Optimize data processing, including leveraging techniques such as indexing, partitioning and clustering, both within centralized infrastructure, but also as an internal team support for the Enterprise Analytics team
• Support select database administration functions (and back-up the Sr. Database Administrator) as required
• Develop and deploy mechanisms to monitor and maintain integrated database solutions
• Troubleshoot technical issues
• Prepare and maintain functional and technical specifications and relevant documentation related to designed, developed and implanted solutions
• Proactively and reactively identify reference data to support business needs; and developing such assets accordingly for Enterprise Analytics teams
• Facilitate regular working groups with team members on solution planning and collaborative problem solving of regularly identified data management and governance problems.
• Informs and champions a plan to re-engineer & update products in alignment with broader Enterprise Analytics efforts to rationalize, enhance, or sunset solutions
• Ensure solutions employ required security controls, including specific attention to pipelines and infrastructure containing personal health information; and give attention to data minimization options, including de-identifying, pre-aggregating, anonymizing or establishing synthetic data for appropriate use cases
• Provides leadership by creating an environment that encourages creativity, innovation, learning and critical thinking
• Acts as a coach, mentor and role model to team members
• Excellent interpersonal skills with demonstrated ability to build, establish and maintain collaborative, service-oriented relationships with internal and external stakeholders

 

Education/Certifications/Licenses:

• A graduate degree in Computing/Information Science, Health Informatics, Engineering, or related field.
• Demonstrated, strong skills and experience with leading & developing data solutions for analytics purposes
• Demonstrated, strong skills and experience leveraging a variety of programming languages, database and data pipeline management tools and visualization tools (e.g. Java, Python, C/C++/C#, SQL Server/Oracle, AWS/Azure, PowerBI/Tableau Prep, MS SSIS), including knowledge of their capabilities
  • Such skills and experience may be demonstrated through certifications with specific tools or authoring languages and/or work experience
• A passion for analytics, high comfort level and interest in leading and teaching analysis, interpretation, and results to tell stories with data and facts
• Strong understanding of data governance principles

 

Experience/Skills/Abilities:

• 5 years’ experience in a data analytics or data engineering role
• Ability to consult and set priorities that align with the organization’s goals
• Strong knowledge of data sources and methodologies in a health care setting
• Excellent analytical, problem solving and organization ability
• Subject matter expert in the designing and recommending of appropriate analytical approaches and methodology in addressing key issues within the organization
• Ability to consult with partners to develop and implement key metrics and reporting that enable overall operational and financial efficiency, growth, or quality objectives
• Informed and keeps up with the latest industry trends and best practices that is subsequently imparted on the data warehousing, data quality and data analytics personnel for constant growth and optimal departmental and business performance.
• Strong attention to detail and effective decision making, project management and negotiation skills
• Strong leadership, interpersonal and communication skills (written & verbal)
• Ability to establish and maintain a collaborative, service-oriented relationship with internal and external stakeholders
• Knowledge of current Canadian Institute for Health Information (CIHI) coding standards and hospital guidelines an asset
• Knowledge and understanding of key health care performance measures (clinical, financial, utilization, efficiency) and balanced scorecards an asset
• Ability to work outside regular business hours as required
• Proven attendance record.
• Demonstrates behaviours consistent with Mackenzie Health’s Commitment to Caring.
• Models behaviour that is aligned with the values of Mackenzie Health – Excellence, Leadership and Empathy.
• Commitment to providing an exceptional experience for staff and clients within a challenging and exciting health care environment.

 

*You may be required to work at any site of Mackenzie Health.

---

Mackenzie Health is an inclusive and equal opportunity employer committed to providing accommodations for applicants upon request at any stage of the recruitment process in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code.

 

We thank all applicants for their interest; however, only those under consideration for an interview will be contacted.

---

#MackenzieHealthCareers, #LI-JB1