MediaMarktSaturn Plattform Services GmbH
Senior Analytical Engineer - Service Innovation & Strategy - (m/f/d)
MediaMarktSaturn Plattform Services GmbH, Germantown, Ohio, United States
Responsibilities
Data transformation and pipeline management: Design and optimization of data transformations in BigQuery; development and maintenance of standardized, automated, and monitored data pipelines ensuring reliability and scalability. Data mart development: Collaboration with analysts and business stakeholders for translation of business requirements into technical KPI definitions and implementation within the data mart layer. Data investigation and migration support: Participation in the migration from SAP BO to GCP/Looker through analysis of legacy reporting systems, comprehension of existing data usage and KPI logic, and definition of equivalent or improved BigQuery solutions. Gap analysis and integration: Identification of missing data points, evaluation of data dependencies, and coordination with the Data Engineering team for completeness and future-proofing of solutions. Data quality and governance: Implementation of monitoring, testing, and documentation frameworks ensuring data accuracy, consistency, and transparency. Stakeholder collaboration: Partnership with business teams and analysts for alignment of technical solutions with business needs and process requirements. Reporting enablement: Development of standardized reporting layers (e.g., Looker Studio, Looker ML) and prevention of inefficient ad-hoc reporting. User training and support: Occasional facilitation of training sessions and provision of support for business users to enhance adoption of reporting tools and understanding of KPI logic. Your Profile
Academic Degree: Bachelor\'s or Master\'s degree in relevant fields Advanced expertise in Google Cloud Platform (GCP), especially BigQuery. Proven experience in designing, optimizing and maintaining production-grade data pipelines and data marts in GCP. Hands-on experience in re-architecting and modernizing BI setups during migrations. Advanced SQL skills, including query optimization, complex joins, window functions, CTEs, performance tuning in large-scale datasets. Practical experience with Git version control: working with branches, pull requests, code reviews in a collaborative setup, ensuring changes to SQL models, pipelines are properly tracked and reviewed before deployment. Experience with data pipeline orchestration and automation (e.g. dbt, Apache Airflow, Dataflow, Spark or similar frameworks): designing, deploying and monitoring robust ELT processes Proven track record in data modeling and data mart development: fact/dimension modeling, conformed dimensions, KPI logic implementation, star/snowflake schemas. An ability to reconstruct KPI logic and dependencies across various tools and systems. Strong ability to design and document migration paths that both Data Engineers and business stakeholders can follow and trust. Hands-on experience with BI/visualization tools (especially with Looker Studio and Looker ML), with focus on enabling standardized reporting layers, not only ad-hoc analysis. Several years of relevant experience as a BI/Analytical Engineer, Data Engineer or Senior Data Analyst with ownership of data pipelines and models. Languages: Proficiency in English About Us
The Services & Solutions Team manages the portfolio of service products sold in all of MediaMarktSaturn retail channels and country portfolios. They lead the way in designing and selling solutions, that allows customers to make the most out of their technology. We are looking for an Analytical Engineer (m/f/d) to strengthen our BI & Analytics capabilities in MediaMarktSaturn. This role bridges data engineering and business analytics, ensuring reliable well-structured and business-ready data flows in our Google Cloud Platform (GCP) environment. The focus of this role is on building and maintaining scalable data pipelines, managing transformations and creating robust data marts to support business decision making. The best solutions come from bringing together diverse perspectives. Embracing diversity is key to achieving our vision of becoming the Experience Champion. We value inclusion, foster equal opportunity, and welcome you to be part of our team. Additional Benefits
Job Infos
Department: HQ - Services & Solutions Entrylevel: Professional Level Type of Employement: Full Time Working Hours: 37,5 Persona: Job Requisition HQ Employee Ready for a job where you look forward to Monday? Let’s Go!
For us
"Let\'s Go!"
is not just a slogan, it is an attitude. We love technology and we want to excite. We have fun and want to inspire. Our customers and our teams. That’s why we are looking for people who share this spirit. People who are passionate about creating the shopping experience of the future together with 50.000 colleagues across Europe. We use third-party services to help us optimise our web site (analytics) and place personalised advertisements (advertising). To use these services, we need your consent. Provider Description Enabled SAP as service provider / projekt0708 "route"(SAP): is used for session stickiness "careerSiteCompanyId"(SAP): is used to send the request to the correct data center "JSESSIONID"(SAP): is placed on the visitor\'s device during the session so the server can identify the visitor Woosmap Woosmap Map API is a mapping service provided by Woosmap SAS, 5 rue du Plan du Palais, 34000 Montpellier, France. We use Woosmap Map API to display an interactive map and to create directions or assist in finding a physical store. When using Woosmap, information about your use of this website (including your IP address) may be transmitted to and stored on server locations within the EU, primarily in Ireland. YouTube is a video streaming service provided by Google Inc, 1600 Amphitheatre Parkway Mountain View, CA 94043, USA. We directly integrate YouTube videos into some parts of our web site, e.g. to offer explanatory videos or other moving image content for a better understanding of products or information about MediaMarktSaturn. When using YouTube, information about your use of this web site (including your IP address) may be transmitted to a Google server in the USA and stored there. Further information on data protection and the terms of use of YouTube can be found here . We use marketing services to show you interesting offers and offers from third parties. Furthermore, we would like to show you only those advertisements that are of actual interest to you.
#J-18808-Ljbffr
Data transformation and pipeline management: Design and optimization of data transformations in BigQuery; development and maintenance of standardized, automated, and monitored data pipelines ensuring reliability and scalability. Data mart development: Collaboration with analysts and business stakeholders for translation of business requirements into technical KPI definitions and implementation within the data mart layer. Data investigation and migration support: Participation in the migration from SAP BO to GCP/Looker through analysis of legacy reporting systems, comprehension of existing data usage and KPI logic, and definition of equivalent or improved BigQuery solutions. Gap analysis and integration: Identification of missing data points, evaluation of data dependencies, and coordination with the Data Engineering team for completeness and future-proofing of solutions. Data quality and governance: Implementation of monitoring, testing, and documentation frameworks ensuring data accuracy, consistency, and transparency. Stakeholder collaboration: Partnership with business teams and analysts for alignment of technical solutions with business needs and process requirements. Reporting enablement: Development of standardized reporting layers (e.g., Looker Studio, Looker ML) and prevention of inefficient ad-hoc reporting. User training and support: Occasional facilitation of training sessions and provision of support for business users to enhance adoption of reporting tools and understanding of KPI logic. Your Profile
Academic Degree: Bachelor\'s or Master\'s degree in relevant fields Advanced expertise in Google Cloud Platform (GCP), especially BigQuery. Proven experience in designing, optimizing and maintaining production-grade data pipelines and data marts in GCP. Hands-on experience in re-architecting and modernizing BI setups during migrations. Advanced SQL skills, including query optimization, complex joins, window functions, CTEs, performance tuning in large-scale datasets. Practical experience with Git version control: working with branches, pull requests, code reviews in a collaborative setup, ensuring changes to SQL models, pipelines are properly tracked and reviewed before deployment. Experience with data pipeline orchestration and automation (e.g. dbt, Apache Airflow, Dataflow, Spark or similar frameworks): designing, deploying and monitoring robust ELT processes Proven track record in data modeling and data mart development: fact/dimension modeling, conformed dimensions, KPI logic implementation, star/snowflake schemas. An ability to reconstruct KPI logic and dependencies across various tools and systems. Strong ability to design and document migration paths that both Data Engineers and business stakeholders can follow and trust. Hands-on experience with BI/visualization tools (especially with Looker Studio and Looker ML), with focus on enabling standardized reporting layers, not only ad-hoc analysis. Several years of relevant experience as a BI/Analytical Engineer, Data Engineer or Senior Data Analyst with ownership of data pipelines and models. Languages: Proficiency in English About Us
The Services & Solutions Team manages the portfolio of service products sold in all of MediaMarktSaturn retail channels and country portfolios. They lead the way in designing and selling solutions, that allows customers to make the most out of their technology. We are looking for an Analytical Engineer (m/f/d) to strengthen our BI & Analytics capabilities in MediaMarktSaturn. This role bridges data engineering and business analytics, ensuring reliable well-structured and business-ready data flows in our Google Cloud Platform (GCP) environment. The focus of this role is on building and maintaining scalable data pipelines, managing transformations and creating robust data marts to support business decision making. The best solutions come from bringing together diverse perspectives. Embracing diversity is key to achieving our vision of becoming the Experience Champion. We value inclusion, foster equal opportunity, and welcome you to be part of our team. Additional Benefits
Job Infos
Department: HQ - Services & Solutions Entrylevel: Professional Level Type of Employement: Full Time Working Hours: 37,5 Persona: Job Requisition HQ Employee Ready for a job where you look forward to Monday? Let’s Go!
For us
"Let\'s Go!"
is not just a slogan, it is an attitude. We love technology and we want to excite. We have fun and want to inspire. Our customers and our teams. That’s why we are looking for people who share this spirit. People who are passionate about creating the shopping experience of the future together with 50.000 colleagues across Europe. We use third-party services to help us optimise our web site (analytics) and place personalised advertisements (advertising). To use these services, we need your consent. Provider Description Enabled SAP as service provider / projekt0708 "route"(SAP): is used for session stickiness "careerSiteCompanyId"(SAP): is used to send the request to the correct data center "JSESSIONID"(SAP): is placed on the visitor\'s device during the session so the server can identify the visitor Woosmap Woosmap Map API is a mapping service provided by Woosmap SAS, 5 rue du Plan du Palais, 34000 Montpellier, France. We use Woosmap Map API to display an interactive map and to create directions or assist in finding a physical store. When using Woosmap, information about your use of this website (including your IP address) may be transmitted to and stored on server locations within the EU, primarily in Ireland. YouTube is a video streaming service provided by Google Inc, 1600 Amphitheatre Parkway Mountain View, CA 94043, USA. We directly integrate YouTube videos into some parts of our web site, e.g. to offer explanatory videos or other moving image content for a better understanding of products or information about MediaMarktSaturn. When using YouTube, information about your use of this web site (including your IP address) may be transmitted to a Google server in the USA and stored there. Further information on data protection and the terms of use of YouTube can be found here . We use marketing services to show you interesting offers and offers from third parties. Furthermore, we would like to show you only those advertisements that are of actual interest to you.
#J-18808-Ljbffr