-
Design and build a modern ELT architecture, from the raw data layer through staging to the data mart.
-
Develop and maintain a structured data warehouse, including clearly defined transformation logic outside the BI tool.
-
Create structured data models within the warehouse, for example using star schemas, slowly changing dimensions type 2 (SCD2), and potentially Data Vault in the future.
-
Implement version-controlled data transformations using dbt or comparable tools.
-
Build and orchestrate stable, automated data pipelines, for example with Airflow, Prefect, or Dagster.
-
Integrate internal and external data sources such as the online shop, ERP and CRM systems, marketing platforms, and APIs.
-
Ensure data quality and establish monitoring and error-handling processes within the pipeline architecture.
-
Further develop the data platform with a focus on performance, scalability, and future cloud integration.
-
You have already built data warehouses or ELT architectures with raw, staging, and data mart layers.
-
You are highly proficient in Microsoft SQL Server and comfortable working with complex queries, stored procedures, and performance tuning.
-
You model data in a structured way, for example using star schemas and slowly changing dimensions type 2 (SCD2).
-
You use dbt or comparable tools to keep transformation logic clean, traceable, and version-controlled outside the BI tool.
-
You have experience with orchestration tools such as Airflow, Prefect, or Dagster and use them to build stable data pipelines.
-
You use Python confidently for data processing and the development of pipeline logic.
-
You understand tracking data from systems such as Google Analytics and Meta Ads and can integrate it cleanly into the data model.
-
You use BI tools such as Power BI in a pragmatic and goal-oriented way.
-
You have English language skills at B2 level or above.
-
You have already worked with cloud data platforms such as BigQuery, Snowflake, or Amazon Redshift.
-
You are familiar with analytical database systems such as ClickHouse or DuckDB.
-
Event-driven systems such as Apache Kafka are familiar to you.
-
You have experience in e-commerce or performance marketing.
-
You have worked with tools such as Grafana, Metabase, or Apache Superset.
-
You have initial experience with large language models and use them effectively in data-driven workflows.
-
Impact: You will work directly on the key drivers of greater efficiency and sustainable growth.
-
Work-life balance: You can benefit from flexible starting times and 28 days of annual leave. Your holiday entitlement increases with each year of service, up to a maximum of 30 days. We also offer an occupational pension scheme upon request.
-
Personal training budget: An individual professional development budget can be agreed based on your needs.
-
Additional benefits: You will receive a monthly tax-free non-cash benefit worth €50.
-
Team events: Look forward to a large summer party, monthly barbecues, and regular team lunches.
-
On-site facilities: Snack vending machines, changing rooms, and shower facilities are available at our location.
-
Office dogs: Our four-legged colleagues are an integral part of the team and help create a positive working atmosphere.
Wir sind die Recruiting Firma der easycosmetic(TM) mit über 250 Mitarbeitenden in Berlin & Brandenburg gehören wir zu den führenden Online-Shops für Parfums, Pflege und Kosmetik in der DACH Region.
Was uns verbindet? Der Anspruch, täglich besser zu werden – im Kundenerlebnis, im Teamwork und in der Technologie. Unser Wachstum basiert auf einem agilen Mindset, echtem Machergeist und einer Kultur, in der gute Ideen schnell Wirkung entfalten.
Detaillierte Informationen über die Arbeit in einem easycosmetic-Team findest du auf dem Karriereportal; weiteres über das Label auf einer der Webseiten in Deutschland, Österreich, der Schweiz, den Niederlanden und Belgien.
Dich erwartet ein sicherer Arbeitsplatz in einem innovativen und internationalen Umfeld mit flachen Hierarchien und hoher Eigenverantwortung. Deine Bewerbung erfolgt über das Online-Karriereportal, unter Angabe der Gehaltsvorstellung, einem Anschreiben, Lebenslauf und Zeugnissen.
