Data Engineer

At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work together is reflected through our five values: integrity, inspiration, tenacity, humility and care.

• Fully paid medical, dental and vision coverage from your first day

• a health care spending account

• a premium defined benefit pension plan

• three personal days and two float days annually

• three weeks' vacation to start (for individual contributors), increasing to four weeks after two years

• career development opportunities

• a collaborative values-based team culture

• a wellness program

• a hybrid working model

• participation in Communities of Inclusion

Want to make a difference in your career? Consider this opportunity.

Ontario Health is one of the largest public holders of health data in Canada. Within the Enterprise Data & Analytics Services group, we use these data assets to support diagnostic, predictive, prescriptive analytics and research to improve health system outcomes, experience and operations. This work requires contextualization of transactional and administrative data into clinical and business concepts, and curation of it in robust analytics-read datasets.

The primary accountability of the Data Engineer is to work closely with data, analytics, and technology partners to develop built-for-purpose data products that will be used both internal and external to the organization. As a data engineer, you will contribute to the design, development and operationalization of internal and external initiatives such including data pipelines, masking and de-identification methods, data linkage practices and analytics friendly products.

This position is best suited for an inquisitive, highly analytical, self-guided and driven individual with excellent interpersonal and communication skills, and mastery of data linkage and management.

Here is what you will be doing:

• Work closely with analysts, methodologists, and data scientists to develop fit-for-purpose data products that will be used both within and outside of the organization.

• Writing and managing code to develop data products including data masking, analytics concepts, cohorts, and patient identification algorithms.

• Building and designing fit-for-purpose analytical base tables to support multiple analytics projects.

• Act as a custodian for data environments to ensure a consistent design philosophy is applied to all new data products in the analytics data hub.

• Optimizing very large datasets for efficient processing

• Mastering multiple health data assets with a variety of structures

• Collaborating with Data Architecture, ETL, and IT-Operations teams to build and operationalize sandbox environments, enterprise data and information assets and Analytical Base Tables (ABT)s.

• Helps establish and enforce best practices for maintaining analytics sandboxes.

• Bring a cross-business view of data engineering and identifying opportunities for developing enterprise information assets to elevate the functionality of Ontario Health's analytics data environment.

• Present methods and insights from complex data engineering work and builds consensus among people from different disciplines with varying degrees of health data experience.

• Make thoughtful decisions on complex and/or ambiguous issues.

• Maintain up-to-date knowledge of emerging tools and methodologies, and applies them to data engineering solutions as appropriate.

• Accountable for rigorous and timely delivery of information products

Here is what you will need to be successful:

Education and Experience

• Bachelor's or master's degree in computer science, applied mathematics, physics, engineering, health informatics or recognized equivalent is required

• Minimum 5 years of experience in designing, developing, and implementing data solutions and at least two years of experience in designing, developing, and implementing data and analytics solutions for analytics use.

• Minimum 5 years of experience with relational database systems (Oracle and SQL Server)

• Experience with setting up and scaling data lakes preferred.

• Familiarity with data lakes

• Familiarity with health data privacy and security concepts is preferred.

• Mastery of SQL

• Experience in programming and scripting with Python, SAS, R an asset.

• Experience working with and optimizing large datasets.

• Experience with administrative and clinical health data sets is an asset.

Knowledge and Skills

• Excellent interpersonal and communication skills (written and oral), ability to work in a fast-paced team environment as well as independently.

Location: Toronto, Ontario (currently hybrid; subject to change)

Employment Type:

Contract Length:

Salary Band:

External Application Deadline Date: