Data & BI Architect (German C1) | MS Fabric, Power BI & Snowflake

Polcode; Warszawa; Remote; PLN 138,000 - 234,000; Full time

Benefits offered by this job

Multisport card

Private medical care

Life insurance

Equipment provided

Job summary

Polcode in Poland is seeking a Senior Data & BI Architect to join an enterprise-scale data project for an international energy client. You will shape end-to-end data architecture, model data for self-service analytics, and optimize pipelines across Snowflake, Fabric, and Power BI.

The role requires German C1 and English B2, 100–170 PLN/h net + VAT on a B2B basis, with project duration 01.01.2027–30.06.2027 and potential extension. Remote (Poland) or Warsaw office.

Qualifications

• Several years of commercial experience in Data Warehousing, Data Engineering, and BI architecture.
• Advanced SQL skills and solid experience with relational and dimensional data modeling.
• Hands-on experience with dbt for data transformation and modeling.
• Experience with Apache Airflow or similar orchestration tools.
• Practical experience working with Snowflake.
• Strong hands-on knowledge of Microsoft Fabric and modern data integration patterns.
• Very good knowledge of Power BI Semantic Models and their architecture.
• Advanced DAX skills, including Measures, KPIs, time intelligence, and performance optimization.
• Strong understanding of Star Schema, facts, dimensions, relationships, and hierarchies.
• Experience analyzing and optimizing complex data pipelines and BI solutions.

Responsibilities

• Design, develop, and optimize the end-to-end data architecture connecting the Sales Data Warehouse, Microsoft Fabric, and Power BI.
• Maintain and enhance upstream data preparation processes using dbt and SQL.
• Develop and optimize data processing and orchestration workflows using Apache Airflow.
• Work with Snowflake-based data structures while supporting the platform's evolution towards Databricks.
• Design and improve data integration patterns and data flows within Microsoft Fabric.
• Identify and eliminate unnecessary data redundancies and duplicated transformations.
• Develop and optimize Power BI Semantic Models based on dimensional modeling and Star Schema principles.
• Model facts, dimensions, relationships, and hierarchies for self-service analytics.
• Create and optimize DAX measures, KPIs, and time intelligence calculations.
• Analyze and improve the performance of data pipelines, transformations, and semantic models.
• Define standards for data structures, naming conventions, data quality, and reusability.
• Make architectural recommendations and document technical decisions.
• Translate business requirements into scalable data models and technical solutions.
• Collaborate with business stakeholders, Data Engineers, and BI Developers.
• Provide technical guidance and share knowledge on modern Data & BI architecture.

Skills

Advanced SQL

dbt

Apache Airflow

Snowflake

Power BI

Microsoft Fabric

Databricks

DAX

Data architecture

BI modeling

Tools

Snowflake

Databricks

Power BI

Microsoft Fabric

dbt

Apache Airflow

Job description

Data & BI Architect (German C1) | MS Fabric, Power BI & Snowflake

Polcode is a Poland-based software house working with clients worldwide since 2006. We build web, mobile, and eCommerce products for startups and well-established companies across Europe, the US, and beyond. What makes us different? We put people first while staying deeply tech-driven - People at heart | Technology in mind . We trust our teams, encourage ownership, share knowledge daily, and create a place where everyone can grow and feel at home.

100% remote (within Poland only) or in our office: Warszawa

B2B: 100–170 PLN netto + VAT
Duration: 01.01.2027 – 30.06.2027 (with an option to extend)

Hi, Polcode here!

We’re currently looking for an experienced Senior Data & BI Architect to join an enterprise-scale data and analytics project for an international client in the energy industry.
The project focuses on evolving and optimizing an existing self-service Business Intelligence platform built around Microsoft Fabric and Power BI. The solution enables business users to access sales data through standardized, reusable data models and perform reporting and analytics independently.
In this role, you'll work across the entire data architecture — from a Sales Data Warehouse and upstream data preparation using dbt, SQL, and Apache Airflow, through Microsoft Fabric, to Power BI Semantic Models.
Your main challenge will be to improve the performance, scalability, and maintainability of the end-to-end data platform, while ensuring that data transformations and business logic are implemented in the right architectural layers.
This is a great opportunity for someone who enjoys combining hands-on data engineering with architectural ownership, performance optimization, and technical consulting.

The cooperation is planned from January until the end of June 2027, with an option to extend.

Why this project is worth your attention:

Work on an enterprise-scale data and BI platform in the energy industry

Take an active role in shaping and optimizing end-to-end data architecture

Work with a diverse modern data stack: Microsoft Fabric, Power BI, Snowflake, dbt, SQL, and Apache Airflow

Contribute to the evolution of a Snowflake-based data environment towards Databricks

Go beyond dashboard development and influence how data is prepared, transformed, modeled, and delivered

Improve performance, scalability, and reusability across multiple architectural layers

Help establish consistent standards for data quality, modeling, and business logic

Combine technical implementation with architecture consulting and knowledge sharing

Work closely with Data Engineers, BI Developers, business teams, and other stakeholders.

Get ready to:

Design, develop, and optimize the end-to-end data architecture connecting the Sales Data Warehouse, Microsoft Fabric, and Power BI

Maintain and enhance upstream data preparation processes using dbt and SQL

Develop and optimize data processing and orchestration workflows using Apache Airflow

Work with Snowflake-based data structures while supporting the platform's evolution towards Databricks

Design and improve data integration patterns and data flows within Microsoft Fabric

Identify and eliminate unnecessary data redundancies and duplicated transformations

Develop and optimize Power BI Semantic Models based on dimensional modeling and Star Schema principles

Model facts, dimensions, relationships, and hierarchies for self-service analytics

Create and optimize DAX measures, KPIs, and time intelligence calculations

Analyze and improve the performance of data pipelines, transformations, and semantic models

Define standards for data structures, naming conventions, data quality, and reusability

Make architectural recommendations and document technical decisions

Translate business requirements into scalable data models and technical solutions

Collaborate with business stakeholders, Data Engineers, and BI Developers

Provide technical guidance and share knowledge on modern Data & BI architecture.

What were looking for:

Several years of commercial experience in Data Warehousing, Data Engineering, and BI architecture

Strong understanding of end-to-end data architectures and complex data flows

Advanced SQL skills and solid experience with relational and dimensional data modeling

Hands‑on experience with dbt for data transformation and modeling

Experience with Apache Airflow or similar orchestration tools

Practical experience working with Snowflake

Strong hands‑on knowledge of Microsoft Fabric and modern data integration patterns

Very good knowledge of Power BI Semantic Models and their architecture

Advanced DAX skills, including Measures, KPIs, time intelligence, and performance optimization

Strong understanding of Star Schema, facts, dimensions, relationships, and hierarchies

Experience analyzing and optimizing complex data pipelines and BI solutions

Ability to make architectural decisions with performance, maintainability, and scalability in mind

Strong analytical and problem‑solving skills

Independent, structured, and solution‑oriented approach to work

Ability to communicate technical concepts clearly and document architectural decisions

German C1 + English B2 minimum (must‑have).

It would be great if you also have:

Experience with Databricks or migrations from Snowflake‑based platforms towards Databricks

Knowledge of Data Governance, Data Quality, and data standardization practices

Experience with CI/CD and deployment processes for Data & BI solutions

Experience working in agile environments, ideally SAFe

Knowledge of Python or Spark.

Our recruitment process:

People Interview – short call to talk about your experience and expectations

Technical Interview – discussion focused on your experienced and skills

Final Interview – final conversation with the client team

Perks of being a #Polcoder:

Multisport card, private medical care, life insurance, and meaningful gifts to celebrate important days

All the necessary equipment for comfortable work

Professional onboarding process

We respect your private life - no overtime, no weekend jobs, work‑life balance only, promise!

Work at times that suit your daily rhythm, from the place of your choice

Your work is appreciated - we believe in the power of feedback, as well as the one you give us.

TL;DR

Senior Data & BI Architect — enterprise‑scale energy industry project

Microsoft Fabric + Power BI + Snowflake + dbt + SQL + Apache Airflow

End‑to‑end data architecture, dimensional modeling, and self‑service BI

Start: 01.01.2027

End: 30.06.2027 (with an option to extend)

B2B: 100–170 PLN/h + VAT

We strongly believe that putting people first makes our work better.
We encourage you to grow your career, contribute to open source, and follow your passion. We wanna do great things with you!