Data Engineering And Bi Lead - $82,544 - $110,058 A Year
Posted
Summary
Leads the Ontario Trillium Foundation's business-intelligence infrastructure in Microsoft Azure: designing and maintaining the data warehouse and ETL pipelines (Databricks), managing CI/CD via Azure DevOps, ensuring data quality, security and governance, and aligning BI solutions across business units.
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
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