Data Engineer & BI Developer — Manufacturing & Automotive

The hard part is the bill of materials

Eight years shaping supply-chain and BoM data into dimensional models — and the Power BI layer on top that procurement, risk, and strategy teams actually use.

See my work Get in touch

Areas of Expertise

From data systems design to regulatory compliance frameworks

Data Architecture

Bill-of-Materials and supply-chain data shaped into fact and dimension tables you can slice by part, supplier, and region.

See the models

BI & Reporting

Power BI dashboards and semantic models that let procurement, risk, and strategy teams slice supply-chain data themselves.

See the reporting

Pipelines & Transformation

Layered, refreshable pipelines in Power Query and PySpark — typed functions, config-driven parameters, and validation that fails fast on bad input.

See the pipelines

Featured Work

Data pipelines, dimensional models, and BI for manufacturing and automotive

Power BI dashboard showing battery recycling facility locations and competitor analysis across Europe

PythonPuLPPandas

Optimizing European Battery Recycling Through Data-Driven Location and Technology Analysis

98,667 t/yr

European end-of-life battery volume left unprocessed by existing recyclers by 2026 — the capacity gap the network was optimized to close

View project

Power BI dashboard showing total procurement spend, supplier country and material counts, spend by material as a bar chart, and spend by commodity group as a donut chart

Microsoft FabricPySparkPower BI

OEM Material Insights: Procurement & Supply-Risk Intelligence on Microsoft Fabric

Zero silent gaps

Missing coverage is surfaced and flagged rather than coerced to zero — including one gap that can never be closed

View project

View all projects

I Analyze. I Build. I Optimize.

Turning complex industrial data into structured, queryable models.

Learn about my approach

Hi, I'm Erik.

I'm a Data Engineer and BI Developer based in Gothenburg, Sweden. For eight years at IVL Swedish Environmental Research Institute (2018–2026) I did hands-on data work for large manufacturing and automotive clients — refreshable pipelines in Power Query, Bill-of-Materials data shaped into dimensional models, and Power BI dashboards used by procurement, risk, and strategy teams. On my own time I've built an end-to-end Microsoft Fabric platform. The domain depth — critical raw materials, EU Battery Regulation, REACH, life-cycle assessment — is what shortens the ramp-up in industrial contexts.

More about me