METRO
Data Engineer - Solution Expert
Pune, MH, India · On-site · Full-time
Apply on the employer’s site ↗See how well you match this job
You apply directly with the employer. ROLIVA does not submit applications from this page and is not the employer.
About the role
Description from the employer’s posting. Check the employer’s page for the current version.
- EmployerMETRO
- LocationPune, MH, 411015, India
- Work styleOn-site
- Employment typeFull-time
- Employer posted
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.
Show full description
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.
Check your resume against this job Free, no sign-up. Nothing you paste is stored.
Staying safe while you apply
- Never pay to apply, interview or accept an offer. ROLIVA never asks you for payment to apply to a job.
- Apply only through the official “Apply on the employer’s site” button, on the employer’s own site, and check that a recruiter’s email uses that employer’s own domain rather than a free email address.
- Be cautious of an offer made with no real interview, or pressure to decide quickly or share financial details early.
Does something look wrong with this listing? Use “Report broken link” in the role details, or read ROLIVA’s full job-safety guidance ↗.
Preparing for this role with ROLIVA
- Check the fit.
Compare the requirements with the experience you have confirmed, including gaps.
- Prepare honestly.
Build interview stories and application drafts from your own evidence.
- Keep track.
Save the role and record your own application status and follow-ups.
Data engineer jobs in Pune
ROLIVA currently lists 31 open roles like this in Pune.
Employers hiring for this
- KSB3 open roles
- Artefact2 open roles
- Avantor2 open roles
- METRO2 open roles
- NielsenIQ2 open roles
At a glance
- Work styleOn-site
- Employment typeFull-time
- SeniorityMid level
- Employer posted
- Added to ROLIVA
- Last checked
Skills in this posting
Skills ROLIVA found in the employer’s own description above. A mention is not a requirement.
SQL Python Tableau Power BI Looker Snowflake BigQuery GCP Machine learning Stakeholder management