Sap Bw Consultant

SAP BW on HANA to Incorta Migration SME

Role Summary

Lead end-to-end migration projects from SAP BW on HANA to Incorta. Drive solution architecture, data modeling, extraction pipelines, dashboard design, and change management, ensuring high-quality delivery, seamless new-platform adoption (Incorta), and knowledge transfer to stakeholders.

Key Responsibilities

1. Assessment & Planning: Analyze existing SAP BW landscapes (InfoProviders, DTPs, Cubes, queries) and define migration scope, strategy, and timeline.

2. Data Modeling & Mapping: Map BW models (cubes, ADSOs, business content) to Incorta schemas and business views. Design incremental data pipelines and transformation logic.

3. Extraction & ETL Automation: Extract data from SAP BW on HANA; manage lineage, delta processing, and metadata migration. Use tools like Incorta Inspector and CLI to export/import schemas/data sources.

4. Platform Migration Execution: Oversee schema, business view, and dashboard/story migration using Incorta UI and CLI. Handle broken references and cleanup using migration best practices.

5. Dashboard & Insight Creation: Rebuild key analytics and dashboards in Incorta (insights), ensuring data fidelity and usability.

6. Testing & Validation: Develop validation scripts and reconciliation reports. Ensure outputs match legacy SAP BW reports through rigorous testing cycles.

7. Operationalization & Cutover: Lead golive activities and help stabilizing reports on the Incorta platform.

8. Documentation & Knowledge Transfer: Produce detailed architecture docs, data-mapping guides, runbooks, and best practices for the migration.

Required Qualifications

• 7-8 years of SAP BW on HANA expertise, data modeling, and architecture.
• Has successfully migrated BW workloads (reports, models, and dashboards) into Incorta or similar modern data warehouses.
• Proven experience in large-scale BI migrations, ETL strategy, and performance tuning.
• Expertise in data modeling (InfoCubes, ADSOs, Open ODS, and composite providers), plus familiarity with HANA modeling (attribute/calculation views).
• Strong proficiency in SQL, metadata-driven modeling, and data validation.
• Deep knowledge of tools such as BW transformation/routine coding, BEx/queries, and Incorta Dashboard building.
• Solid project lead experience handling migration sprints, slice planning, and stakeholder coordination.

Preferred Skills

• Experience with Incorta architecture and migration patterns: use of the Inspector tool, CLI export/import, and object-level migration.
• Exposure to Incorta analytics and insight generation.
• Knowledge of CI/CD orchestration for deployment cycles.
• Strong understanding of SAP source extraction logic, including delta mechanisms and replicating complex extractor code (BEx, custom).
• Excellent communication, leadership, and client-facing abilities to guide cross-team collaboration.