Data Engineer - Solution Expert

Established in 2011 and headquartered in Pune, METRO Global Solution Center (GSC) India is a strategic hub driving METRO’s global transformation. With 1,200+ professionals, we deliver specialized integrated expertise across Master Data Management, Information Technology, Cyber Security, Marketing & Design, Strategy, Finance & Accounting, controlling (FP&A), and People & Culture (HR) solutions that drive operational excellence and digital innovation.

By supporting METRO’s sCore strategy, we enable sustainable growth and strengthen business processes. With a solutions-first mindset, we reduce complexity, accelerate transformation, and create measurable value for METRO businesses scaling up globally. METRO is a leading international food wholesaler operating in over 30 countries with a strong network of wholesale stores, digital marketplaces, and food service distribution. It supports businesses that keep the world running, from hotels, restaurants, and cafés to local retailers - offering quality, reliability, and smart solutions that help small and medium-sized businesses succeed.

Headquartered in Düsseldorf, Germany, METRO AG employs over 85,000 people worldwide and acts as the central management holding company of the group, driving strategic direction, and enabling consistent excellence across all markets. Around the world, METRO has approx. 15 million customers who benefit from the wholesale company’s unique multichannel mix: customers can purchase their goods in one of the large stores in their area as well as by delivery (Food Service Distribution, FSD) - all digitally supported and connected. In parallel, METRO MARKETS is being developed as an international online marketplace for professional customers, which has been growing and expanding continuously since 2019.

Acting sustainably is one of the company principles of METRO, which has been listed in various sustainability indices and rankings, including MSCI, Sustainalytics and CDP.

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.

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.

Personal Competencies

• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management capabilities.
• Ability to translate business requirements into technical solutions.
• Self-driven, pragmatic, and results-oriented mindset.
• Strong collaboration skills in cross-functional and international environments.
• Ability to lead technical discussions and influence architectural decisions.