What does working as a Microsoft Data Engineer involve? We are wizards who turn data into knowledge. We work as consultants for various clients (and sectors) – partly on-site/partly from home – to assist them with Microsoft data solutions. Our credo is to empower every professional to make the best data-driven decision. Transforming data into usable knowledge is something you have right at your fingertips.
You will concentrate on what we call the back end of Business Intelligence:
Managing and customising the ETL or ELT process (Extract, transform, load)
Setting up and customising data integrations and data modelling (SSIS , SSAS, SSRS)
You will be using Microsoft data services on-premise or in Azure, or a combination of both. Understanding the front end of BI is important. So, in due course, you will also get experience in reporting and visualising in Power BI.
Project-based or long-term assignments, all options are on the table. Depending on the assignment, you may be working on your own or in a team, taking care of the project management yourself or not. Participating in pre-sales is also a possibility. The trump cards of this job are variety and continuous learning through experience.
But don’t worry.
The roles within assignments and their complexity will be tailored to you: sufficiently challenging for learning and not over your head. If you demonstrate a keenness to learn, independence and initiative, you will be absolutely fine. Don’t forget that you have a team of helpful Koherians standing behind you who will be happy to help you and facilitate your development.
Do you have these skills?
- Azure data factory
- Azure Synapse Analytics
- Python (nice to have)
- Databricks (nice to have)
- Azure Datalake Services
- Thorough knowledge of T-SQL and of developing ETL flows with Azure components or on-premise tools (ADF / SSIS/…)
- Knowledge of Power BI would be a bonus.
- Good basic understanding of general data warehousing and modelling principles (Kimball)
- Fluency in Dutch and English is a must, and fluency in French would be a bonus.
Microsoft Azure
ETL
T-SQL
Kimball
Power BI