Our Toronto based client is seeking an experienced SAP S/4HANA Data Analytics and Reporting Workstream Lead to join their project immediately on a long term contract. The ideal candidate has 12 to 15+ years total experience, with 8+ in data and analytics and 4+ leading a reporting workstream on a major transformation. They have led analytics on a full-lifecycle ERP program through go-live, and have driven a downstream conformance effort rebuilding EPM, warehouse, or BI models onto a new ERP master data structure (not Greenfield). Should also have deep enterprise-scale Power BI expertise (semantic modelling, DAX, governance, performance not authoring), proficiency in modern platforms (Azure/Fabric, Databricks, Snowflake, or equivalent) and ELT design, and hands-on delivery off S/4HANA or comparable ERP sources with a firm grasp of finance data structures. EPM integration (Oracle/Hyperion or equivalent) is required. This will be a primarily remote work with minimal travel to the client office.
Key Responsibilities:
- Own the analytics and reporting strategy end to end: target data architecture, semantic layer, and the boundary between S/4 embedded reporting and downstream Power BI.
- Own the retrofit of all downstream data models and reporting to new S/4 master data and enterprise structures company code, profit centre, cost centre, functional area and engagement dimensions including rebuilt semantic models, historical comparability and the mapping of legacy structures forward.
- Own the downstream conformance of Oracle EPM to new S/4 master data and enterprise structures rebuilding EPM hierarchies, dimensions and mappings to consume S/4 as source, and managing the transition of planning and consolidation onto the new structures.
- Own the Power BI estate for the program data models, workspace and governance model, refresh and performance, and the migration of existing reports to new sources.
- Own reporting requirements for BES and engagement leadership: engagement profitability, WIP and realisation, utilisation, pipeline and financial performance.
- Define and govern the KPI and metric dictionary single definitions, agreed owners, and the reconciliation rules that stop two reports disagreeing.
- Own data governance for reporting: lineage, quality measures, certified datasets and access model.
- Own report rationalization decide what gets rebuilt, what gets retired, and hold that line.
- Manage workstream scope, plan, deliverables, RAID and team; represent the workstream at Design Authority Council.
Preferred Experience:
- Professional services or partnership environments, with engagement economics literacy (realization, utilization, WIP, leverage); SAP Datasphere or SAC exposure; S/4HANA Public Cloud data extraction patterns and their limits; data governance certification; bilingual (EN/FR).
