Data Engineer - Solution Expert

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, 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.