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 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: #J-18808-Ljbffr