Data Engineering and BI Lead

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

• 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 Dev Ops
• 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.

• 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 Power
  
  BI and Sharepoint
• Experience with Databricks (Delta Lake, Unity Catalog, Lakehouse Architecture, Databricks SQL Warehouses, Databricks Asset Bundles, etc.)
• Experience with Azure Dev Ops 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: