Data Engineering And Bi Lead - $82,544 - $110,058 A Year

This is a business critical role part of the Measurement, Evaluation, and Business Intelligence team and works in collaboration with business units to ensure OTF’s BI systems are optimized to support the enterprise BI and analytics strategy. The main purpose of this role is to manage and optimize the infrastructure of Ontario Trillium Foundation’s (OTF) business intelligence system in Microsoft Azure. Data Engineering, subject matter expertise in distributed systems and infrastructure management are the core functions of this role.

Employment Type: Full Time

Job Occupation Type: Database analysts and data administrators

Total Positions: 1

Wage: $82,544 - $110,058

Hours/Week: 0

Days of Work: Mon, Tue, Wed, Thu, Fri

Closing Date / Apply By: 12/3/2025

Start Date: n/a

Duties

Manage and deploy OTF’s enterprise data infrastructure for analytics and BI systems

Develop, test, and maintain OTF’s data warehouse architecture in Microsoft Azure – experience with Databricks is preferred

Manage a trusted and reliable set of data sources for analytics applications and BI dashboards

Oversee ETL development, including the design, implementation, and scaling of new data pipelines, transformation of raw data into data models using Databricks or other tools

Optimize existing infrastructure and pipelines, including troubleshooting and solving production problems

Oversee CI/CD processes and source control management using Azure DevOps

Identify ways to improve data quality in collaboration with MEBI team members

Inform data governance strategy, providing feedback on data issues and vulnerabilities, and acting as an advocate and driver of OTF data policies and principles

Ensure data security, privacy, and compliance with relevant regulations and organizational policies (e.G. FIPPA, Privacy Policy, Information Management Policy, Information Classification Standard, Records Retention Schedules, etc.)

Act as primary liaison between IT, business units, and MEBI teams to ensure alignment of data solutions with organizational goals

Lead the operationalization of BI strategy including data storage, management, and access, in collaboration with Measurement, Evaluation and Business Intelligence department team members

Support the OTF’s annual BI plan with general guidance to the Director, MEBI, and carries out approved BI initiatives and projects

Lead the development and implementation of BI solutions from a people, process and technology perspective, including an integrated strategy for upskilling team members, operational process optimization, and systems enhancements

In collaboration with other MEBI team members and the Director, participate in the development and execution of analytics roadmap strategies, business cases, RFP/RFI submissions, cost-benefit analysis and benefits realization deliverables.

Informs the BI budget with general guidance to the Director MEBI and in collaboration with the Director, IT.

Qualifications

Minimum 1 year direct experience in Enterprise Data Warehouse technologies and distributed systems

Minimum 1 year hands on experience developing data warehousing, data lakes, batch processing, and extract transform load (ETL) workflow solutions

Minimum 1 year direct experience designing and optimizing SQL database architecture

Expertise in developing software code in one or more languages (SQL, Python, Java, Spark).

Experience and demonstrated success in project management.

Familiarity with PowerBI and Sharepoint

Experience with Databricks (Delta Lake, Unity Catalog, Lakehouse Architecture, Databricks SQL Warehouses, Databricks Asset Bundles, etc.)

Experience with Azure DevOps or other Git version control systems

Experience working with third-party APIs to ingest data for analytics purposes.

Bachelor’s degree in computer science or related degree or equivalent work experience

Preferred: Azure Data Engineering certification

To apply for this position, submit your cover letter and resume online.

For more information, please visit our website at: https://otf.Ca/who-we-are/work-ontario-trillium-foundation/data-engineering-and-bi-systems-lead-0