Data Engineer Solution Expert
Job Summary
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.
Additional Information :
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.
Remote Work :
No
Employment Type :
Full-time
About Company
METRO is a leading international wholesale company with food and non-food assortments that specialises in serving the needs of hotels, restaurants and caterers (HoReCa) as well as independent traders. Around the world, METRO has 15 million customers who can choose whether to shop in o ... View more