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 TimeJob Occupation Type: Database analysts and data administratorsTotal Positions: 1Wage: $82,544 - $110,058Hours/Week: 0Days of Work: Mon, Tue, Wed, Thu, FriClosing Date / Apply By: 12/3/2025Start Date: n/aDutiesManage and deploy OTF’s enterprise data infrastructure for analytics and BI systemsDevelop, test, and maintain OTF’s data warehouse architecture in Microsoft Azure – experience with Databricks is preferredManage a trusted and reliable set of data sources for analytics applications and BI dashboardsOversee ETL development, including the design, implementation, and scaling of recent data pipelines, transformation of raw data into data models using Databricks or other toolsOptimize existing infrastructure and pipelines, including troubleshooting and solving production problemsOversee CI/CD processes and source control management using Azure DevOpsIdentify ways to improve data quality in collaboration with MEBI team membersInform data governance strategy, providing feedback on data issues and vulnerabilities, and acting as an advocate and driver of OTF data policies and principlesEnsure 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 goalsLead the operationalization of BI strategy including data storage, management, and access, in collaboration with Measurement, Evaluation and Business Intelligence department team membersSupport the OTF’s annual BI plan with general guidance to the Director, MEBI, and carries out approved BI initiatives and projectsLead 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 enhancementsIn 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.QualificationsMinimum 1 year direct experience in Enterprise Data Warehouse technologies and distributed systemsMinimum 1 year hands on experience developing data warehousing, data lakes, batch processing, and extract transform load (ETL) workflow solutionsMinimum 1 year direct experience designing and optimizing SQL database architectureExpertise in developing software code in one or more languages (SQL, Python, Java, Spark).Experience and demonstrated success in project management.Familiarity with PowerBI and SharepointExperience with Databricks (Delta Lake, Unity Catalog, Lakehouse Architecture, Databricks SQL Warehouses, Databricks Asset Bundles, etc.)Experience with Azure DevOps or other Git version control systemsExperience working with third-party APIs to ingest data for analytics purposes.Bachelor’s degree in computer science or related degree or equivalent work experiencePreferred: Azure Data Engineering certificationTo 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#J-18808-Ljbffr

📌 Data Engineering And Bi Lead - $82,544 - $110,058 A Year (Toronto)
🏢 Ontario Trillium Foundation
📍 Toronto