We are seeking a senior level SAP Data & Analytics consultant for a 12 month contract position starting ASAP. This is a Toronto based project with occasional trips onsite required (expenses paid).In this role you will lead the downstream conformance of EPM and Power BI reporting to new S/4HANA structures for clients SAP S/4HANA Public Cloud Edition program.Description:Owns the reporting and analytics layer that sits outside S/4HANA — the information BES and engagement leadership actually use to run the business. Accountable for the target data model, the conformance of downstream models to new S/4 master data and enterprise structures, the continued Oracle EPM interlock, and a Power BI estate that reconciles to source. This is the workstream the business will judge the program by, because most of the firm will experience S/4HANA through a report rather than a transaction.What you will do: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 BIOwn the retrofit of all downstream data models and reporting to current 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 forwardOwn 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 structuresOwn the Power BI estate for the program — data models, workspace and governance model, refresh and performance,



and the migration of existing reports to new sourcesOwn reporting requirements for BES and engagement leadership: engagement profitability, WIP and realisation, utilisation, pipeline and financial performanceDefine and govern the KPI and metric dictionary — single definitions, agreed owners, and the reconciliation rules that stop two reports disagreeingOwn data governance for reporting: lineage, quality measures, certified datasets and access modelOwn report rationalisation — decide what gets rebuilt, what gets retired, and hold that lineManage workstream scope, plan, deliverables, RAID and team; represent the workstream at Design Authority Council12–15+ years total; 8+ in data and analytics; 4+ leading a data/reporting workstream on a major transformation.Led an analytics and reporting workstream on a full-lifecycle ERP program, through go-liveHas led a downstream conformance effort — rebuilding EPM, warehouse or BI models onto a new ERP master data and enterprise structures. Materially different from building new models on a greenfield sourceDeep Power BI at enterprise scale: semantic modelling, DAX, workspace governance, performance — not report authoringModern data platform architecture (Azure/Fabric, Databricks, Snowflake or equivalent) and ELT designDelivered reporting off S/4HANA or comparable ERP source data, with real understanding of the underlying finance data structuresEPM integration experience — Oracle EPM/Hyperion, or equivalent planning and consolidation platformBusiness fluency: can sit with a partner or engagement leader, extract what they actually need, and say no to the restPreferred:Professional services or partnership environments, with engagement economics literacy (realisation, utilisation, WIP, leverage); SAP Datasphere or SAC exposure; S/4HANA Public Cloud data extraction patterns and their limits; data governance certification; #J-18808-Ljbffr

📌 Sap Bi/Bw/Analytics Consultant (Toronto)
🏢 2iSolutions
📍 Toronto