Data Engineering and BI Lead

·       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 DevOpsIdentify 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.