Senior Data & BI Architect in Warsaw

Senior Data & BI Architect in Warsaw

Warsaw Stacjonarnie
B

Be | Shaping the Future Poland, part of the Engineering Group, is a technology and business consulting company founded in 2013. We help organisations in financial services and other industries turn complex requirements into reliable, end-to-end solutions, drawing on expertise in software engineering, cloud and infrastructure, data, and quality assurance.

We are looking for an experienced

Senior Data & BI Engineer

to support the further development and technical optimisation of an existing self-service Business Intelligence (BI) solution built on Microsoft Fabric and Power BI.

The solution provides sales data from the Sales Data Warehouse (VDWH) for self-service reporting and analytics. The end-to-end data pipeline includes upstream data preparation within the Open Data Platform (ODP), data integration and processing in Microsoft Fabric, and the delivery of business-ready data through Power BI Semantic Models.

The main objective is to develop a scalable, high-performing and maintainable data and BI architecture, ensuring a consistent and reusable data foundation for various reporting and analytics requirements.

The role combines hands-on data engineering, data modelling, Microsoft Fabric development, Power BI expertise and architectural consulting.

Responsibilities

Data provisioning and ODP:

Maintain and further develop ODP as the upstream data preparation layer for the self-service BI solution.

Consolidate and prepare the required dimensions and facts for downstream data models.

Develop, maintain and optimise transformation logic using dbt and SQL.

Maintain and further develop data processing and orchestration workflows using Apache Airflow.

Analyse and optimise existing data structures and transformation processes in terms of performance, data quality and maintainability.

Coordinate the necessary changes at the interface between VDWH and the self-service BI solution.

Account for the evolution of the underlying data platform from Snowflake towards Databricks.

Microsoft Fabric:

Design, further develop and optimise the existing data architecture in Microsoft Fabric.

Integrate data provided by VDWH and ODP.

Select and use appropriate Microsoft Fabric components and integration patterns.

Optimise data flows between VDWH, Microsoft Fabric and the semantic layer.

Reduce unnecessary data redundancy and repeated transformations.

Further develop standards for data structures, naming conventions, data quality and reusability.

Analyse and optimise end-to-end performance.

Data modelling and Power BI:

Design, further develop and optimise Power BI Semantic Models.

Develop dimensional data models based on star schema principles.

Model facts, dimensions, relationships and hierarchies.

Develop and optimise DAX measures, KPIs and time intelligence logic.

Optimise semantic models for performance, scalability and ease of use.

Implement consistent, reusable measure definitions and business logic.

Provide suitable semantic structures for self-service reporting and analytics.

End-to-end architecture:

Analyse and optimise the data pipeline from VDWH and ODP through Microsoft Fabric to the semantic model.

Optimise the division of business and technical responsibilities between the individual architecture layers.

Assess and optimise dependencies between components.

Advise on architectural decisions and the further development of the target technical architecture.

Create and maintain technical designs, architecture decision records and documentation.

Ensure maintainability, reusability and scalability.

Coaching and knowledge transfer:

Gather and analyse business requirements and translate them into appropriate data models and technical solutions.

Collaborate with business departments, data engineers, BI developers and other stakeholders.

Provide expert advice on data modelling, Microsoft Fabric, Power BI and self-service BI architectures.

Document the solutions developed and architectural decisions made.

Transfer knowledge to internal staff.

Requirements

Several years of hands‑on experience with data warehouse, data engineering and BI architectures.

Excellent SQL skills and a strong understanding of relational and dimensional data modelling.

Hands‑on experience with dbt.

Hands‑on experience with Apache Airflow or comparable orchestration tools.

Hands‑on experience with Snowflake.

Substantial hands‑on experience with Microsoft Fabric.

Excellent knowledge of Power BI Semantic Models and dimensional modelling.

Excellent knowledge of DAX, measures, time intelligence and performance optimisation.

Experience with star schemas or dimensional modelling.

Experience analysing and optimising complex end-to-end data flows.

Fluent English and German.

Nice to have

Experience with Databricks or evolving Snowflake-based data platforms towards Databricks.

Experience with data governance, data quality and standardisation.

Knowledge of CI/CD and deployment processes for data and BI solutions.

Experience with agile ways of working, ideally SAFe.

Knowledge of Python and/or Spark.

Competitive B2B rate, aligned with your experience and the project

Long-term projects for leading international organisations

Continuous growth through internal DevTalks, online and onsite

A collaborative, international team within the Engineering Group

Optional Medicover, Multisport and Mindgram packages at preferential rates

Free access to the gym at our Q22 office

Referral program: a bonus for every successful recommendation

Senior Data & BI Architect in Warsaw – pracodawca: Be | Shaping the Future Poland

Be | Shaping the Future Poland to doskonały pracodawca, który oferuje dynamiczne środowisko pracy w branży usług finansowych. Nasza kultura pracy opiera się na współpracy i innowacyjności, co sprzyja rozwojowi zawodowemu pracowników. Oferujemy elastyczne godziny pracy oraz możliwość zdobywania nowych umiejętności w obszarze testowania aplikacji, co czyni naszą ofertę atrakcyjną dla osób poszukujących satysfakcjonującego zatrudnienia.

B

Dane kontaktowe:

Zespół rekrutacyjny Be | Shaping the Future Poland