Data Engineer - Solution Expert

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, flexible 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. Qualifications: Professional Experience Minimum 5 years of experience in Data Engineering, Data Warehousing, or Analytics Engineering. Minimum 3 years of hands-on experience with Google Cloud Platform and BigQuery. Experience working with financial reporting, controlling, planning, consolidation or management reporting solutions Proven experience designing and implementing enterprise-scale cloud data warehouse and analytics solutions. Experience delivering end-to-end data warehouse modernization or migration projects. Experience working with SAP data sources, preferably SAP ECC, SAP BW, SAP S/4HANA or Tagetik Consolidation. Strong experience developing enterprise reporting solutions using MicroStrategy. Technical Skills Google Cloud & BigQuery Google Cloud Platform (GCP) BigQuery architecture and administration Data warehouse design and optimization Cloud security and IAM Data lifecycle management Performance tuning and cost optimization Data Engineering Design of reporting-ready data models and semantic layers Handling of hierarchies, master data and reporting structures Advanced SQL ETL/ELT architecture and implementation Data modeling (Star Schema, Snowflake Schema, Data Vault knowledge desirable) Data quality and reconciliation frameworks Data integration and replication concepts Python or comparable programming languages Git and CI/CD pipelines Business Intelligence & Analytics MicroStrategy Architecture MicroStrategy Dashboard and Report Development Semantic Layer Design KPI and Metric Modeling Analytics and Data Visualization Best Practices Preferred Qualifications Experience with SAP BW-to-cloud migration initiatives. Experience with Tagetik or comparable consolidation and performance management solutions Experience with group reporting, management reporting or controlling processes Knowledge of Google Cortex Framework. Experience with modern analytics platforms such as Looker, Power BI, or Tableau. Understanding of AI/ML-enabled data platforms and advanced analytics architectures. Experience working in large-scale retail, wholesale, or consumer goods organizations. Benefits: People & Culture METRO Global Solution Center India talentacquisition@metro-gsc.in