Description
General Description
The data engineer plays a key role in the development of data ingestion, data integration and analytics solutions (data warehouses, data marts) for NIHDI (INAMI-RIZIV).
The data engineer sits within the central Data Office which is a central organization providing data services across the different NIHDI business lines. He/she works in an agile scrum team in close collaboration with the Project Leader, the Data Functional Analyst and the Data Architect of the project.
Roles & Responsibilities
· Translate business, functional and data architectural requirements provided by the Data Functional Analyst and the Data Architect into technical specifications.
· Design, build, deploy and maintain data solutions (ETL pipeline, database objects, physical and virtual datamarts) according to established standards (data processing, data warehouse, data marts) in accordance with the functional and non-functional requirements (performance, data volume).
· Test the analytics solution, ensure the data correctness, conduct troubleshooting, provide maintenance and adequate technical documentation.
· Works with the Project Leader (PL) along the entire project lifecycle to ensure appropriate delivery in an agile and pragmatic approach.
· Integrate referential data into a central data hub.
Key Skills
· Bachelor or Master degree in Computer Science or equivalent
· Minimum 4-5 years of experience as a data engineer in the Microsoft BI on-prem stack (Visual Studio, SSIS, SSAS, SSMS)
· Ability to translate business requirements into technical requirements
· Data modelling experience (logical and physical modelling)
· Good experience in data warehouse design (Kimball dimensional modelling)
· Very good knowledge of Microsoft SQL Server (from a development perspective)
· Very good Knowledge of SQL queries, T-SQL, SQL Server Integration Services (SSIS).
· Very good understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
· Experience in master and reference data integration and usage.
· Experience in working in an agile project mode.
· Experience in building a data validation engine (business rules, semantic validation) is a plus
· Experience in visualization tool such as Microsoft Power BI and SSRS is a plus.
· Experience in data functional analysis is a plus.
Profile
· Analytical mind with a problem-solving aptitude
· Good technical skills
· Go-getter profile
· Ability to translate business needs into technical solutions
· Pragmatic approach and delivery focus
· Team player with an ability to work in a collaborative spirit within a transversal organization
· Perseverance, stress resistant and flexibility
· Like to learn and open-minded
Job description summary
As a data engineer you will be in charge of understanding and translating the business and functional requirements into technical specifications, collaborate in the definition of the data model (logical and physical) and implement an efficient data solution using the Microsoft on-prem stack (SQL Server / SSIS / SSAS).
Keywords
SSIS, SSAS, SQL Server, T-SQL, Agile Scrum, Power BI, Master Data Management