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.

• 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.

• 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.

• 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).

• 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.

• 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

• 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.

• 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.