Job Description

BigQuery Data Modelling & Engineering:

- Define and maintain data models for financial reporting data on Google Cloud Platform and BigQuery currently provided through SAP BW.
- Model financial reporting data across key business dimensions such as account, entity, store, period, reporting scenario, currency, KPI and reporting hierarchy.
- Design scalable, secure, and cost-efficient data warehouse solutions supporting financial reporting and analytics use cases.
- Design reporting-ready data layers that support standard reports, dashboards, versatile analysis and reconciliation with existing SAP BW outputs.
- Establish data integration, ingestion, transformation, and storage standards for SAP, Tagetik and other finance-related data sources.
- Design and implement ELT/ETL frameworks, data pipelines, and reusable data engineering patterns.
- Optimize BigQuery performance, data partitioning, clustering, and workload management.
- Define and implement monitoring, data quality, and operational support processes.

SAP BW Modernization:

- Collaborate with business and technical teams to migrate reporting and analytical logic from SAP BW 7.5 to BigQuery.
- Translate existing BW data models, transformations, and financial reporting business logic into scalable SQL-based cloud solutions.
- Support migration of financial reporting capabilities including KPI structures, reporting hierarchies,



financial calculations, currency-related logic and reporting-ready data views.
- Support the implementation of SAP ECC, SAP BW, Tagetik and other finance-related ingestion patterns into BigQuery.
- Contribute to migration planning, solution design, testing, and deployment activities.
- Identify opportunities to simplify legacy architectures and improve data accessibility.

Analytics & Reporting:

- Design and implement enterprise reporting solutions using MicroStrategy.
- Develop and maintain MicroStrategy schemas, attributes, metrics, facts, intelligent cubes, reports, dashboards, and dossiers.
- Design semantic layers and reporting-ready data models to support self-service analytics.
- Partner with business stakeholders to translate reporting and KPI requirements into scalable analytical solutions.
- Ensure financial reporting requirements are accurately reflected in reporting models and reporting outputs.
- Ensure report accuracy, usability, performance.

Stakeholder Management & Collaboration
- Act as the technical lead for financial reporting data models and analytics solutions on BigQuery and MicroStrategy.
- Collaborate with business, IT, SAP, and cloud stakeholders to ensure successful project delivery.
- Support future innovation initiatives including advanced analytics, AI, and machine learning use cases.

📌 Data Engineer - Solution Expert (Pune)
🏢 METRO Global Solution Center IN
📍 Pune