Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 10, 2026.
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.
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.
Requirements
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.
Benefits
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).

