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