Data Engineering and BI Systems Lead

Recognized as one of Canada’s Most Admired Corporate Cultures, and a leading grant foundation, the Ontario Trillium Foundation (OTF) is an agency of the Government of Ontario with a mandate to build healthy and vibrant communities. With a budget of over $100 million, the Ontario Trillium Foundation (OTF) awards grants to some 700 projects every year to build healthy and vibrant Ontariocommunities.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.This role is responsible for leading the design, implementation and management of enterprise data solutions on Microsoft Azure platform. You will work with the Measurement Evaluation and Business Intelligence team to architect data infrastructure that impact key business decisions at the Foundation. Solid experience and understanding of considerations for operationalization of data warehouses, data lakes, and Business Intelligence platforms in a cloud environment is a must. We are looking for candidates who have direct experience developing and managing distributed database solutions in Microsoft Azure and ability to work collaboratively with business stakeholders.What Can I Expect to do in this Role?Manage 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 new 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.Skills and AttributesStrong background in distributed data systems and lakehouse architectures as they relate to BI concepts, methods, tools and technologiesExperience with Microsofts’ Azure environment (ADLS, Logic Apps, Function Apps, Azure Data Factory ,) - Azure Databricks experience with PySpark & SQL is preferredExperience with programming in SQL, Python and/or others (i.e. R, Spark, PowerShell, Bash) to support data modeling, cleaning, integration, and cloud automation.Experience designing and managing enterprise-wide cloud data and analytics infrastructure, including lakehouse environments, data modeling, ETL pipelines, and analytic toolsExperience in designing data systems from initial architecture to implementation and optimization.Demonstrated experience designing, implementing, and maintaining CI/CD pipelines and Git repositories Project management skills including the ability to effectively manage and prioritize the implementation of multiple projects in the data systems, with competing timelines and deliverables.Knowledge of Data Governance tools and workstreams, including data catalogues, metadata, data quality and/or others.Ability to translate business needs into BI solutions for diverse stakeholdersAbility to stay up to date on new and existing programs and software tools that may be relevant to OTF’s BI needsWillingness and ability to travel occasionally, primarily within Ontario.Bilingualism is an asset.A team player with a sense of humour.Core CompetenciesPursuit of Excellence/Accountability: Take ownership and deliversAgility: Embrace change and ambiguityCollaboration: Working together with others to leverage skills, talents, and knowledgeCritical Thinking: Interpret, evaluate, and analyze facts and informationInclusion: Embrace all people irrespective of race, gender identity, disabilityHow Do I Qualify?Minimum 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 experienceWe invite applications from people who reflect the diverse communities we serve, including Indigenous (First Nation, Métis and Inuit) and Black peoples.AcknowledgementsWe welcome applications from people who are reflective of the diverse communities we serve, including those who might need accommodation.OTF is committed to accommodating applicants with disabilities throughout the hiring process, in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). This job posting falls under the Public Service of Ontario Act, 2006OTF is committed to building a diverse and inclusive organization for all individuals in our workplaces, which includes supporting people living with disabilities, people from the Black, Indigenous, People of colour and from 2SLGBTQIA+ communitiesOTF is a certified Positive Space employer, which means we create and promote safe spaces for 2SLGBTQIA+ communities.The use of AI is not used to screen, assess, or select applicantsWhile we thank all applicants for their interest, only those selected for an interview will be contacted.Application Deadline: December 3, 2025Directions for Application:To apply for this position, submit your cover letter and resume online. #J-18808-Ljbffr