Senior Data & BI Architect

New
P
PolcodeEnergy data
100% remote (within Poland only) or in our office: WarszawaContractSenior
Salary100 - 170 PLN per hour
Apply NowOpens the employer's application page

Job Details

Languages
German C1 + English B2 minimum (must-have).
Experience
Several years of commercial experience in Data Warehousing, Data Engineering, and BI architecture
Required Skills
SQLApache AirflowMicrosoft Power BISnowflakeData modelingdbt

Requirements

  • 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.
  • German C1 and English B2 minimum.

Responsibilities

  • Design, develop, and optimize 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.
  • Develop and optimize Power BI Semantic Models using dimensional modeling and Star Schema principles.
  • 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, document technical decisions, and collaborate with business stakeholders, Data Engineers, and BI Developers.
View Full Description & ApplyYou'll be redirected to the employer's site
100 - 170 PLN per hour
Apply Now