We are looking for Azure Synapse/ Power BI Engineer (Controlling department) so the successful candidate will need to work effectively as part of a team.
Core Responsibilities and Duties:
- Identification and analysis of business processes
- Development and maintenance of the existing analytics architecture
- Monitoring, analysis, and expansion of existing ETL/ELT processes
- Connection of various source data (e.g., ERP, CRM, support tickets system, partner managements system)
- Active participation in the planning and implementation of data modeling and data management processes with Azure Data Factory/Azure Synapse
Additional Responsibilities and Duties:
- Coordination with stakeholders
- Support of the specialist departments in connecting BI tools (e.g., Excel, Power BI, …) and implementation of reports
Must have:
- Knowledge and experience in dealing with Microsoft Azure components:
- SQL Database, SQL Managed Instance
- Azure Data Lake Storage Gen 2
- Azure Data Factory, Azure Synapse
- Logic Apps
- Log Analytics
- Databricks
- Efficient orchestration of pipelines
- Working with/in Azure DevOps/Git Hub
Sound knowledge:
- in the field of databases, data warehousing, data lakehouse o in the field of (T-)SQL (syntax, structures, stored procedures, …)
- in Power Query/M
- in the area of visualization and modeling of data in Power BI, as well as advanced calculations with the help of DAX (Data Analysis Expression)
Certifications (nice to have, not mandatory):
Data: DP-900, DP-203, DP-300, DP-600, DP-700
.NET/Azure: AZ-900, AZ-204, AZ-400, AZ-305, AI-900, AI-102