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 forthcomingCollaborate 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 requirementsManage data integration, including designing and implementing solutions to integrate data from multiple sources and ensuring the proper transformation and cleansingDefine data models and schema to accurately represent the organization’s data and supportive of efficient storage and retrievalDesign and build data pipelines, including extraction and ingestionOptimize 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 teamSupport select database administration functions (and back-up the Sr. Database Administrator) as requiredDevelop and deploy mechanisms to monitor and maintain integrated database solutionsTroubleshoot technical issuesPrepare and maintain functional and technical specifications and relevant documentation related to designed, developed and implanted solutionsProactively and reactively identify reference data to support business needs; and developing such assets accordingly for Enterprise Analytics teamsFacilitate 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 solutionsEnsure 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 casesProvides leadership by creating an environment that encourages creativity, innovation, learning and critical thinkingActs as a coach, mentor and role model to team membersExcellent 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 purposesDemonstrated, 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 capabilitiesSuch skills and experience may be demonstrated through certifications with specific tools or authoring languages and/or work experienceA passion for analytics, high comfort level and interest in leading and teaching analysis, interpretation, and results to tell stories with data and factsStrong understanding of data governance principles
Experience/Skills/Abilities:
5 years’ experience in a data analytics or data engineering roleAbility to consult and set priorities that align with the organization’s goalsStrong knowledge of data sources and methodologies in a health care settingExcellent analytical, problem solving and organization abilitySubject matter expert in the designing and recommending of appropriate analytical approaches and methodology in addressing key issues within the organizationAbility to consult with partners to develop and implement key metrics and reporting that enable overall operational and financial efficiency, growth, or quality objectivesInformed 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 skillsStrong leadership, interpersonal and communication skills (written & verbal)Ability to establish and maintain a collaborative, service-oriented relationship with internal and external stakeholdersKnowledge of current Canadian Institute for Health Information (CIHI) coding standards and hospital guidelines an assetKnowledge and understanding of key health care performance measures (clinical, financial, utilization, efficiency) and balanced scorecards an assetAbility to work outside regular business hours as requiredProven 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 Options Apply for this job onlineApplyShareEmail this job to a friendRefer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed Application FAQs