Data & BI Architect (German C1) | MS Fabric, Power BI & Snowflake
Description
Wynagrodzenie
B2B: 100 – 170 PLN / godz. netto
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 a global, people-first software house matching ambitious developers with challenging projects. Our team of almost 100 professionals helps build and improve digital businesses, software platforms, eCommerce stores, websites, apps, and everything in between. And they’re good at it.
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 we’re 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/Role Interview – discussion focused on your experience and skills
Client 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)
German C1 + English B2 — both required
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! 💜
Sounds like a match? Let’s talk!
If you’d like to know more or have any questions, reach out to Ela - she’s always open for a quick chat