Senior Data & BI Architect (Microsoft Fabric / Power BI)

Quick Facts

• Role: Senior Data & BI Architect (Microsoft Fabric / Power BI)

• Focus: End-to-end data architecture and Self-Service BI

• Languages: German C1 (required), English B2 (required)

• Work mode: 100% remote (nearshore Europe)

Description

You will develop and optimize a scalable, maintainable end-to-end data and BI architecture using Microsoft Fabric and Power BI. You’ll improve data preparation, Fabric data pipelines, and Power BI semantic models for self-service reporting, including performance and redundancy reductions.

Responsibilities

• Maintain and improve the data preparation layer used by Self-Service BI

• Design, develop, and optimize transformations with dbt and SQL

• Operate and enhance data processing and orchestration with Apache Airflow

• Architect and optimize Microsoft Fabric data workflows

• Integrate data from the data warehouse and the preparation layer

• Develop and optimize Power BI semantic models (Star Schema, measures/KPIs, Time Intelligence)

• Optimize end-to-end pipeline performance and define responsibility boundaries across layers

• Advise on architectural decisions and keep technical documentation up to date

• Translate business requirements into data models and technical BI solutions; support knowledge transfer

Requirements

• German C1 (required)

• English B2 (required)

• Several years of experience designing and developing Data Warehouse, Data Engineering, and BI architectures

• Strong SQL and relational/dimensional data modeling

• Practical dbt experience

• Practical Apache Airflow (or similar) experience

• Snowflake experience

• Advanced practical knowledge of Microsoft Fabric

• Advanced Power BI semantic models and dimensional modeling experience

• Advanced DAX (measures, Time Intelligence) and performance optimization

• Star Schema/Dimensional Modeling experience

• Experience analyzing and optimizing complex end-to-end data flows

Benefits

• International project focused on modern data & BI architecture development

• 100% remote work

• Full engagement (~40 hours/week)

• Possibility to extend collaboration after the first stage of the project