Senior Data Architect — 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

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.