Senior Data Engineer

Prothya Biosolutions; Amsterdam; On-site; EUR 52,000 - 75,000; Full time

Benefits offered by this job

Salary: €4,702.26–€6,759.41 gross per月

Job summary

Prothya Biosolutions is seeking a Senior Data Engineer / BI Specialist to design, build, and maintain scalable data solutions using the Microsoft data platform. You will enable data-driven decision-making with Fabric, Synapse, and Power BI across the business.

In collaboration with stakeholders across Supply Chain, Production, Quality, Finance, and HR, you will develop robust data pipelines, semantic models, and governance to support analytics, automation, and long-term data strategy.

Qualifications

• Bachelor or Master degree in Data Engineering, Business Intelligence, Analytics, or related field.
• Strong experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows), Azure Data Factory, Azure Synapse, SQL, and SQL Server.
• Advanced Power BI development, including data modelling, DAX, and performance optimisation.
• Proficiency in SQL (advanced), Python or Spark (preferred for Fabric/big data).
• Experience with data warehousing concepts and modern architectures (medallion, lakehouse).
• 5+ years of relevant experience in Data Engineering/BI/Analytics with Microsoft data platforms and Power BI.

Responsibilities

• Design, develop, and optimise scalable data pipelines using Microsoft technologies (Azure Data Factory, Fabric Dataflows, Synapse / Fabric).
• Build and maintain lakehouse/warehouse data models supporting Power BI reporting and analytics.
• Develop ETL/ELT pipelines using Azure Data Factory / Fabric pipelines.
• Collaborate with stakeholders to translate requirements into data solutions and visualisations.
• Implement data governance, security, and access controls.

Skills

Microsoft Fabric

Azure Data Factory

Azure Synapse

SQL

Power BI

Python or Spark

Data Warehousing

DAX

Education

Bachelor or Master in Data Engineering, BI, Analytics

Tools

Fabric Dataflows

SQL Server

Job description

As our Senior Data Engineer / BI Specialist you will design, build, and maintain scalable data solutions using the Microsoft data platform. Your role will enable data-driven decision-making through modern data engineering, Microsoft Fabric, and Power BI, while supporting BI, analytics, automation, and long-term data strategy initiatives.

Key Responsibilities

1. Data Engineering & Architecture

• Design, develop, and optimise scalable data pipelines using Microsoft technologies (Azure Data Factory, Fabric Dataflows, Synapse / Fabric).
• Build and maintain lakehouse/warehouse data models, including facts and dimensions that support Power BI reporting and analytics.
• Implement data ingestion patterns for structured and unstructured data sources.
• Ensure high data quality, integrity, and reliability across data platforms.

2. Microsoft Fabric & Modern Data Platform

• Manage and optimise Microsoft Fabric (Lakehouse, Data Warehouse, Data Engineering).
• Define best practices for data architecture, governance, and performance tuning within Fabric.
• Support migration from legacy data platforms to Fabric (if applicable).

3. Power BI Development

• Develop and maintain Power BI reports, dashboards, and semantic models.
• Create efficient and high-performance data models including star schema design, DAX development, and report optimisation.
• Work closely with business stakeholders to translate requirements into impactful visualisations.

4. Data Integration & ETL/ELT

• Develop ETL/ELT pipelines using Azure Data Factory / Fabric pipelines.
• Integrate data from ERP systems, manufacturing systems, and other enterprise applications.
• Automate and schedule data workflows.

5. Data Governance & Compliance

• Implement data governance, security, and access controls aligned with enterprise policies.
• Ensure compliance with regulatory standards (e.g., GxP / data integrity principles, if applicable).
• Define data quality rules, monitoring, and lineage tracking.

6. Stakeholder Collaboration

• Collaborate with data analysts and business stakeholders to identify, prioritise, and deliver data needs.
• Integrate new data sources efficiently into the enterprise data platform.
• Expand analytics and automation capabilities to support innovation, growth, and digitalisation.
• Support evolving business domains including Supply Chain, Production, Quality, Finance, and HR.

Required Skills & Experience

Technical Skills

• Bachelor or Master degree in Data Engineering, Business Intelligence, Analytics, or related field.
• Strong experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows), Azure Data Factory, Azure Synapse, SQL, and SQL Server.
• Advanced Power BI development, including data modelling, DAX, and performance optimisation.
• Proficiency in: SQL (advanced level), Python or Spark (preferred for Fabric / big data scenarios).
• Experience with data warehousing concepts and modern architectures (medallion architecture, lakehouse).
• > 5 years of relevant experience in Data Engineering, Business Intelligence, Analytics, or related roles, with demonstrated experience in Microsoft data platforms and Power BI.

Nice to Have

• Experience in regulated environments (pharma, biotech, manufacturing, GxP).
• Knowledge of data governance frameworks and tools.
• Exposure to DevOps / CI-CD pipelines for data solutions.
• Experience with ERP systems (SAP preferred) and operational systems integration.

Soft Skills

• Strong analytical and problem-solving mindset.
• Excellent communication skills and ability to translate business needs into technical solutions.
• Self-motivated, ownership-driven, and able to manage priorities independently.
• Structured and documentation-oriented.
• Deliver high-quality, scalable, and maintainable data solutions.
• Contribute to standardisation of data models and reporting.
• Ensure reliable and trusted data for business decision-making.
• Act as a subject matter expert for Microsoft Fabric and Power BI.

Why This Role?

• Opportunity to contribute to enterprise-wide digital transformation.
• Work on modern Microsoft Fabric-based architecture.
• Exposure to global stakeholders and strategic initiatives.
• High impact role in shaping data and analytics capabilities.

What we offer:

• Full-time employment (40h) with flexible working hours in consultation. Working part-time can be discussed.
• Salary between€ 4.702,26 and € 6.759,41 gross per month (based on full-time employment).
• 8.33% holiday allowance and a 13th month.
• 30 holiday days (based on fte).
• A personal training budget of €2,100 every three years to foster professional growth and development.
• Contribution to travel expenses from the first kilometer.
• Excellent accessibility by public transport and private parking available.
• A pension plan with Zorg & Welzijn, providing security for your future.