Data & BI Architect

Quick Facts

• Role: Senior Data & BI Architect

• Focus: End-to-end data architecture for self-service BI

• Stack: Microsoft Fabric, Power BI, Snowflake, dbt, SQL, Apache Airflow

• Domain: Energy industry

• Timeline: Jan 01, 2027 – Jun 30, 2027 (option to extend)

• Work setup: 100% remote within Poland or Warsaw office

Description

You will evolve and optimize an enterprise self-service BI platform built on Microsoft Fabric and Power BI, with upstream preparation using dbt, SQL, and Apache Airflow. Own the full architecture from the Sales Data Warehouse to Power BI Semantic Models, improving performance, scalability, and maintainability while placing transformations and business logic in the right layers. You will also support the evolution of a Snowflake-based data environment toward Databricks.

Responsibilities

• Design, develop, and optimize end-to-end data architecture connecting the Sales Data Warehouse, Microsoft Fabric, and Power BI

• Maintain and enhance upstream transformations and models using dbt and SQL

• Build and optimize Airflow workflows for data processing and orchestration

• Work with Snowflake structures while supporting migration/evolution toward Databricks

• Design data integration patterns and data flows within Microsoft Fabric

• Reduce redundant data and duplicated transformations across layers

• Develop and optimize Power BI Semantic Models using dimensional modeling and Star Schema

• 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 pipelines, transformations, and semantic models

• Define standards for structures, naming conventions, data quality, and reusability

• Provide architectural recommendations and document decisions

• Translate business requirements into scalable data models and technical solutions

• Collaborate with Data Engineers, BI Developers, business teams, and stakeholders; provide technical guidance

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; solid relational and dimensional data modeling experience

• Hands-on dbt experience for transformation and modeling

• Experience with Apache Airflow (or similar orchestration)

• Practical experience 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 (measures, KPIs, time intelligence, performance optimization)

• Strong understanding of Star Schema (facts, dimensions, relationships, hierarchies)

• Experience analyzing and optimizing complex data pipelines and BI solutions

• Ability to make architectural decisions for performance, maintainability, and scalability

• Strong analytical and problem-solving skills; independent, structured, solution-oriented work

• Ability to communicate technical concepts clearly and document architectural decisions

• German C1 and English B2 minimum

Benefits

• Enterprise-scale energy data & BI project

• Performance and architecture ownership across the full modern data stack

• Multisport card, private medical care, life insurance, and meaningful gifts

• Equipment provided for comfortable remote work

• Professional onboarding

• Work-life balance (no overtime, no weekend work)

• Flexible working hours aligned to your daily rhythm

• Feedback-driven culture and recognition of your work