The role is focused approximately 50% on e-commerce-specific BI topics and approximately 50% on cross-domain topics within our BI portfolio.
Conception and development of company-wide Power BI dashboards
Creation, further development and optimization of semantic data models in the star schema as well as of DAX measures
Data preparation and modeling with a focus on the silver and gold layers of our medallion architecture
Provision of the reporting and data basis for further processing in the e-commerce department
(e.g. newsletter performance, online campaigns, AOV, conversion rate, cost-revenue ratio and funnel KPIs)
Integration and processing of data from our e-commerce source systems
(e.g., Google Analytics 4, Supermetrics and Microsoft Dynamics 365 CRM, Meta Ads, Google Ads, Criteo, etc.)
Participation in the migration of our BI landscape to Microsoft Fabric
Close collaboration with the specialist departments: gathering requirements, translating them and translating them into scalable BI solutions.
At least 3-5 years of relevant professional experience in the business intelligence field.
Ideally, you have prior professional and analytical experience in e-commerce as well as familiarity with common e-commerce and campaign KPIs.
Solid practical experience with Power BI
Confident use of tools such as DAX Studio and Tabular Editor
Familiarity with modern data platform concepts (medallion architecture, silver/gold layer)
Good to very good knowledge of SQL and Python for data preparation and transformation
Experience with Microsoft Fabric is an advantage.
Very good German and English skills