Senior Data & BI Architect (Microsoft Fabric / Power BI)

Why Billennium?

We are a global technology company providing IT services and digital solutions to clients around the world. Headquartered in Poland, with offices in Canada, Malaysia, Germany, Switzerland and India, we bring together over 1,700 professionals who share one mission -to harness technology and innovation to make the world run better. At the heart of Billennium is our vibrant and people-centric culture, where everyone’s potential matters. We embrace diversity, inclusion, and flexibility, empowering our employees to grow and thrive.

Our values - captured by the acronym TIGER - define who we are and how we work: Trust, Innovation, Growth, Energy, Responsibility – guide us in everything we do.

Role Summary:

We are looking for an experienced Senior Data & BI Architect to support the further development and technical optimisation of an existing self-service BI solution based on Microsoft Fabric and Power BI.

The role focuses on designing, developing, and optimising an end-to-end data and BI architecture, covering the entire data pipeline from the Sales Data Warehouse (VDWH) and Open Data Platform (ODP), through Microsoft Fabric, to Power BI Semantic Models.

The main objective is to establish a scalable, high-performance, and maintainable data architecture that provides a consistent and standardised data foundation for self-service reporting and analytics.

The successful candidate will combine strong hands-on expertise in Data Engineering, Data Architecture, Microsoft Fabric, and Power BI, with the ability to make architectural decisions, optimise data processing workflows, and translate business requirements into sustainable technical solutions.

What You Will Do:

1. Data Engineering & Data Provisioning

• Develop, maintain, and optimise data transformation processes using SQL and dbt.
• Maintain and further develop Apache Airflow workflows and data orchestration processes.
• Prepare and consolidate data structures, including facts and dimensions, for downstream reporting and analytics.
• Optimise data processing in terms of performance, data quality, and maintainability.
• Support the evolution of the underlying data platform from Snowflake towards Databricks.

2. Microsoft Fabric Architecture

• Design, develop, and optimise the existing Microsoft Fabric architecture.
• Integrate and process data from the Sales Data Warehouse (VDWH) and Open Data Platform (ODP).
• Select and implement appropriate Microsoft Fabric components and integration patterns.
• Optimise data flows between individual architecture layers.
• Reduce data redundancy and eliminate unnecessary or duplicated transformations.
• Establish reusable data structures and consistent technical standards.

3. Power BI & Semantic Data Modelling

• Design, develop, and optimise Power BI Semantic Models.
• Build dimensional data models based on Star Schema principles.
• Define and maintain facts, dimensions, relationships, and hierarchies.
• Develop and optimise DAX measures, KPIs, and time intelligence calculations.
• Improve semantic model performance, scalability, and usability.
• Ensure consistent and reusable business logic for self-service reporting and analytics.

4. End-to-End Data Architecture & Optimisation

• Analyse and optimise the complete data pipeline, from VDWH and ODP through Microsoft Fabric to Power BI Semantic Models.
• Define and optimise the functional and technical boundaries between individual architecture layers.
• Determine where data transformations and business logic should be implemented to ensure optimal performance, maintainability, and reusability.
• Identify architectural bottlenecks, dependencies, and opportunities for improvement.
• Advise on architectural decisions and the future development of the target data platform.
• Prepare and maintain technical concepts, architecture documentation, and Architecture Decision Records (ADRs).

5. Collaboration & Knowledge Transfer

• Gather and translate business requirements into appropriate data models and technical solutions.
• Collaborate with Data Engineers, BI Developers, business departments, and other stakeholders.
• Provide technical guidance on Microsoft Fabric, Power BI, data modelling, and self-service BI architecture.
• Establish and promote standards for data quality, naming conventions, data structures, and documentation.
• Share technical knowledge and support the development of internal team capabilities.

Job Requirements:

Technical Requirements – Must-have

• Several years of hands-on experience in Data Engineering, Data Warehousing, and BI Architecture.
• Strong practical knowledge of SQL, relational data modelling, and dimensional data modelling.
• Hands-on experience with dbt and data transformation processes.
• Practical experience with Apache Airflow or comparable orchestration tools.
• Practical experience with Snowflake.
• Strong hands-on experience with Microsoft Fabric, including data integration and architecture development.
• Very good knowledge of Power BI Semantic Models and dimensional data modelling.
• Advanced knowledge of DAX, including measures, KPIs, time intelligence, and performance optimisation.
• Strong understanding of Star Schema principles, facts, dimensions, relationships, and hierarchies.
• Experience designing, analysing, and optimising complex end-to-end data pipelines and architectures.

Nice-to-have Requirements:

• Experience with Databricks and/or migrating Snowflake-based data platforms towards Databricks.
• Knowledge of Python and/or Apache Spark.
• Experience with data governance, data quality management, and standardisation.
• Knowledge of CI/CD and deployment processes for data and BI solutions.
• Experience working in Agile environments; SAFe knowledge would be an advantage.

Language Requirements

• German: B2 or higher – mandatory.
• English: B2 or higher.

What We Offer:

• Comprehensive Benefits Package – Enjoy a range of benefits, including Udemy Business, private medical care, a MultiSport card, a pet care package, language lessons, and shopping vouchers.
• Flexibility – Benefit from flexible working hours and remote or hybrid working options tailored to your lifestyle and location.
• Career Development – Access professional development and learning opportunities, including exclusive benefits through our official partnerships with global IT leaders such as Microsoft, AWS, Snowflake, and Salesforce.
• An Engaging Community – Collaborate with passionate professionals and take part in team-building activities, hackathons, and CSR initiatives.
• Team-Building Events – Join our team-building activities, including our annual company retreat in the Masurian Lake District, a long-standing company tradition.