Analytics Engineer: Build Trusted Data and Self-Serve BI

Acne Studios; Stockholms kommun; On-site; SEK 850,000 - 1,200,000; Full time

Job summary

Acne Studios in Stockholm is seeking an Analytics Engineer to turn cleaned data into trusted datasets and self-service analytics using Power BI and Databricks. You will design data models, build pipelines with PySpark and SQL, and collaborate with stakeholders to translate needs into robust data solutions.

You will partner with Data Insights and contribute to a centralized semantic layer, ensuring data quality, documentation, and reliable reporting across the company.

Qualifications

• Strong dimensional modelling skills (star schema, SCD2 etc.).
• Advanced PySpark and SQL (window functions, complex joins, incremental processing).
• Experience with Spark and Delta Lake/Databricks platform.
• Solid Python skills (data validation, scripting, testing).
• Familiarity with Power BI semantic models.

Responsibilities

• Designing and maintaining dimensional models (facts, dimensions, lookups) in the gold layer.
• Building and operating data transformation pipelines using PySpark and SQL on Databricks.
• Structuring and exposing data for consumption by Power BI and external systems.
• Contributing to building a centralized semantic layer in Databricks.
• Implementing and maintaining core business metrics, logic and KPIs.
• Ensuring data quality through automated testing and validation.
• Documenting datasets and making them easy to find and use.
• Partnering with stakeholders to translate business needs into data models.
• Supporting analysts with guidance on Power BI and Databricks Dashboards.
• Communicating what data is available and how to use it.

Skills

Dimensional modelling

PySpark

SQL

Spark

Python

Databricks

Orchestration tools

Power BI

AI Lakehouse tools

CI/CD for data assets

Data quality frameworks

English

Tools

Databricks

Delta Lake

Unity Catalog

Power BI

Git

Databricks Workflows

Azure Data Factory

Job description

Acne Studios in Stockholm is seeking an Analytics Engineer to turn cleaned data into trusted datasets and self-service analytics using Power BI and Databricks. You will design data models, build pipelines with PySpark and SQL, and collaborate with stakeholders to translate needs into robust data solutions.

You will partner with Data Insights and contribute to a centralized semantic layer, ensuring data quality, documentation, and reliable reporting across the company.