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