Senior Data & BI Consultant (m/w/d) – Microsoft Fabric & Power BI (1-Year Contract)

BGTS International; Frankfurt; Híbrido; EUR 90.000 - 120.000; Jornada completa

Descripción de la vacante

BGTS International is seeking a Senior Data & BI Consultant (m/f/d) for a 1-year contract to modernize a legacy data and BI landscape using Microsoft Fabric and Power BI. You will design migration architecture, build scalable ELT pipelines, and create robust reports while ensuring data quality and governance.

The role requires strong German documentation skills and will operate in a hybrid German project environment with remote delivery and occasional on-site workshops (20%).

Formación

• 5+ years of designing and implementing productive data and BI solutions using Microsoft Fabric.

Responsabilidades

• Analyze existing databases, data structures, views, stored procedures, and ETL logic.
• Evaluation of BI applications, data models, and load scripts for optimization.
• Design a migration architecture based on Microsoft Fabric and Power BI.
• Develop data integration and transformation processes following ELT principles.
• Build robust data pipelines using SQL, Python, and PySpark with logging and monitoring.
• Create dimensional/semantic data models and DAX calculations.
• Develop and optimize Power BI reports/dashboards for usability and performance.
• Validate migrated data and KPIs against test references.
• Document architecture and data flows in German.
• Deploy AI-powered tools per governance guidelines.

Conocimientos

Power BI

ETL/ELT development

SQL

Python

DAX

AI-enabled development

German language

Herramientas

Microsoft Fabric

Power BI

SQL Server

T-SQL

Python

DAX

Descripción del empleo

Senior Data & BI Consultant (m/f/d) – Microsoft Fabric & Power BI (1-Year Contract)

ABOUT US

BGTS is a software and technology solutions company, powered by over 1,800 professionals. With more than 25 years of experience in digital transformation & engineering, technology consulting, and enterprise service management, we empower our clients to achieve success through a combination of engineering expertise and industry insight.

Our strategically located engineering centres and group companies in London, Sheffield, Amsterdam, Düsseldorf, and other key locations provide flexibility, speed, and convenience, enabling us to deliver tailored, impactful solutions to clients around the world.

BGTS is committed to creating value for enterprises by offering high-quality, customer-centric, and results-driven solutions. The company has received multiple international awards and is recognised as one of the largest independent software companies in its region.

For a demanding transformation project, we are looking for an experienced professional in the fields of Data Engineering, Business Intelligence, and Microsoft Fabric for one of the largest technology companies globally. The core focus is on modernizing an established legacy data and BI landscape into a scalable, future-proof cloud platform.

You combine sound technical expertise with a structured approach to analysis, migration, data modeling, and quality assurance. You will work independently on clearly defined work packages and deliver traceable, documented results.

Your Responsibilities

• Analysis of existing databases, data structures, views, stored procedures, and transformation logic.
• Evaluation of existing BI applications, data models, and load scripts, including dependencies, risks, and potentials for standardization and optimization.
• Development of a viable target and migration architecture based on Microsoft Fabric and Power BI.
• Conception and implementation of data integration and transformation processes according to modern ELT/data engineering principles.
• Development of robust, incremental, and restartable data pipelines using SQL, Python, and PySpark – including historization, logging, monitoring, and error handling.
• Design of dimensional and semantic data models as well as implementation of sophisticated calculation logic in DAX.
• Development and optimization of Power BI reports and dashboards, taking usability, data quality, and performance into account.
• Validation of migrated data, KPIs, and reports based on defined references and test cases.
• Creation of high-quality architecture, data flow, transformation, operational, and handover documentation in German.
• Deployment of suitable AI-powered tools to support analysis, development, documentation, and quality assurance in compliance with established governance and security guidelines.

Your Profile

Required Qualifications:

• At least 5 years of practical experience in the design and implementation of productive data and BI solutions using Microsoft Fabric.
• At least 5 years of experience with Microsoft Power BI, particularly with semantic models, DAX, reporting, and dashboard development.
• At least 5 years of experience in developing ETL/ELT processes using SQL and Python.
• At least 3 years of experience with AI-supported methods or tools in software or data development projects.body
• Very good written and oral communication skills in German; project documentation is produced entirely in German.

Nice to Have:

• Experience in migrating complex, legacy BI landscapes to Microsoft Fabric and Power BI.
• Practical experience in analyzing and replacing Qlik solutions, particularly data models, load scripts, and application architectures.
• Proven experience in performance optimization of Power BI models, DAX calculations, and data processing workflows.
• Very good knowledge of Microsoft SQL Server, T-SQL, database structures, views, and stored procedures.
• Experience with version control, automated technical testing, and transparent documentation of decisions, risks, and deviations.

Framework Conditions

• Senior project mandate with high functional and technical design freedom.
• Collaboration in a hybrid project environment with predominantly remote service delivery possible within Germany.
• Occasional on-site appointments for professionally necessary workshops, reviews, or handovers. (20%)
• Autonomous processing of clearly defined deliverables and work packages.