Role & responsibilities
SAP BW / Data & Analytics8 Lead / Position: SAP BW / Data & Analytics Lead
Experience: 8–12+ Years
Location: Onsite/Offshore
Employment Type: Full-TimeRole OverviewWe are seeking an experienced SAP BW/Data & Analytics Consultant to lead and execute testing activities across SAP BW, BW/4HANA, SAP Analytics Cloud (SAC), and enterprise data warehouse solutions. The candidate will be responsible for validating data accuracy, reporting integrity, ETL processes, analytics solutions, and end-to-end business intelligence landscapes during implementation, migration, upgrade, and support projects.Key ResponsibilitiesTest Strategy & Planning
- Define and execute test strategy for SAP BW/Data & Analytics programs.
- Collaborate with business, functional, technical, and data teams to ensure testing coverage.
SAP BW & Data Warehouse
- Validate SAP BW, BW/4HANA Data Models, InfoProviders, ADSOs, Composite Providers, and Data Flows.
- Test ETL processes from SAP and non-SAP source systems.
- Validate Data Extractors, Transformation Rules, DTPs, Process Chains, and Data Loads.
- Perform reconciliation between source systems and BW reports.
- Identify and analyze data quality issues and data inconsistencies.
Reporting & Analytics Testing
- Validate SAP BusinessObjects reports, Web Intelligence (WebI), Analysis for Office, SAP Analytics Cloud (SAC), and Fiori analytical reports.
- Verify report calculations, KPIs, dashboards, and business metrics.
- Conduct drill-down, drill-through, and aggregation testing.
- Validate role-based report access and security controls.
Data Validation & Reconciliation
- Execute source-to-target data validation.
- Perform large-volume data testing and warehouse reconciliation.
- Validate historical data migration and reporting accuracy.
- Ensure data completeness, consistency, and integrity.
Defect Management
- Log, track, and manage defects using JIRA, Azure DevOps, HP ALM, or qTest.
- Work with development teams for root cause analysis and defect resolution.
- Support defect triage meetings and reporting.
Stakeholder Management
- Interact with business users for UAT support.
- Provide status reports, testing metrics, and quality dashboards.
- Present testing progress, risks, and mitigation plans to project leadership.
Required SkillsSAP Technologies
- SAP BW 7.x / BW/4HANA
- SAP HANA Modeling
- SAP BusinessObjects (BOBJ)
- SAP Analytics Cloud (SAC)
- SAP S/4HANA Reporting
Database & Query Skills
- Robust SQL knowledge
- HANA SQL / Native HANA Queries
- Data Reconciliation Techniques
- Data Quality Validation
Test Management Tools
- qTest
- HP ALM
- JIRA
- Azure DevOps
Preferred Qualifications
- Experience in SAP S/4HANA Transformation or Migration projects.
- Experience validating finance, procurement, sales, manufacturing, and HR analytics reports.
- Exposure to SAP Datasphere, SAP Data Intelligence, or SAP BTP Analytics solutions.
- Knowledge of Test Automation tools for data validation.
- SAP BW, HANA, SAC, or SAP Activate certification preferred.
Key Deliverables
- Data Validation Reports
- Defect Metrics & Quality Dashboard
- SIT/UAT Sign-off Reports
- Go-Live Readiness Assessment
- Test Strategy & Test Plan
- Test Scenarios & Test Cases
- Production Validation Report
Mandatory Experience
- 8+ years in SAP BW/Data Warehouse
- Experience in at least 2–3 SAP BW/BW4HANA implementations or transformation programs.
- Strong experience in Data Reconciliation and Analytics Testing.
- Experience working in Agile and Waterfall delivery models.
- Excellent stakeholder communication and leadership skills.
📌 Sap Bw Consultant (Delhi)
🏢 Coforge
📍 Delhi