Data Engineer (m/f/d) - Microsoft Dynamics FO & Power BI

We are looking for a Data Engineer with hands-on experience in extracting data from Microsoft Dynamics 365 Finance & Operations, transforming it using Azure Synapse Analytics, and delivering insights through Power BI reports. This role bridges data engineering and BI, ensuring that high-quality, trusted data is available for business decision-making.

Responsibilities:

* Extract and transform data from Microsoft Dynamics 365 FO using best practices for performance and reliability.

* Design and maintain end-to-end data pipelines using Azure Synapse Analytics.

* Build optimized data models and datasets for reporting in Power BI.

* Collaborate with business stakeholders to understand reporting requirements and translate them into data structures and visualizations.

* Ensure data consistency, integrity, and governance across the data lifecycle.

* Develop and document scalable ETL/ELT processes for data ingestion and transformation.

* Implement data performance tuning for large-scale datasets in Synapse and Power BI

Required Skills:

* Proven experience in extracting and modeling data from Microsoft Dynamics 365 FO

* Proficiency with Azure Synapse Analytics for data integration, transformation, and querying

* Strong expertise in Power BI, including building interactive reports, dashboards, DAX, and Power Query

* Solid knowledge of SQL and experience working with relational and cloud-based databases (Azure SQL, Data Lake)

* Understanding of data governance, data modeling, and analytics best practices.

* Ability to work closely with both technical and non-technical stakeholders to deliver impactful data solutions

Preferred Qualifications:

* 3 to 5 years of experience in data engineering or BI development.

* Familiarity with the Microsoft Dynamics FO data model and entities.

* Experience delivering end-to-end reporting solutions using Power BI from Dynamics FO data.

* Microsoft certifications in Azure Data Engineering or Power BI are a strong plus.