Senior Analytics Engineering Specialist

at  OLG

66,400.00 - 99,600.00 CAD

Job Description:
Senior Analytics Engineering Specialist
GAME ON – OLG needs you
We’ve said GAME ON, and we mean it – OLG is rapidly transforming its organization to better serve Ontarians by delivering great gaming experiences through our digital, retail lottery, and land-based gaming channels. Over the course of fiscal 2022-23, OLG delivered a record $2.5 billion in net profit to the Province of Ontario. OLG is now expanding our horizons even further, with a new strategic direction, to become a world class gaming entertainment leader with a globally admired digital platform.
We are ready to take this game to the next level and need a passionate Senior Analytics Engineering Specialist to ensure the availability of trusted, well-documented, and fit-for-purpose data sets. The role cleans, models, and documents data within the Enterprise Analytics Platform. The role also interprets the requirements of Data Analysts and Business stakeholders and transforms data into accessible, reusable formats for consumption.

Reporting to the Director, Enterprise Analytics Enablement, you will be empowered to:

• Transform data for analyst consumption by cleaning and aggregating data, denormalizing tabular data, and building cubes in multiple formats.
• Create dimensionally modeled relational (DMR) and Online Analytical Processing (OLAP) data sets as required for reporting and analytics.
• Create and maintain dimensional modeling standards.
• Adhere to DataOPS best practices to optimize data pipelines and collaborate with stakeholders along the entire data lifecycle.
• Consult in the collection of requirements from data analysts and business stakeholders.
• Coordinate root-cause analysis of data issues and solution testing, engaging Data Engineers, Data Analysts, Technology partners, and vendors as required.
• Demonstrate reporting and analytics tools and solutions and train users as appropriate.