3 hours, 49 minutes ago

BI Developer Medior

General Description

The BI developer plays a key role in the development of data analytics solutions (data warehouses, data marts) for NIHDI. He/she works in close collaboration with the Data Functional Analyst, the Data Architect and the Project Leader of the project. He participates in the technical requirements documentation.

The BI developer sits within the central Data Office which is a central organization providing data services across the different NIHDI business lines. He/she works within an agile scrum team.

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 BI solutions according to established standards (data processing, data warehouse, data marts).
  • Test the analytics solution and provide adequate technical documentation.
  • Create visualizations and reports for requested projects in Power BI or SSRS.
  • Conduct prototype reviews and demos including training on the data model to the business users.
  • Work with the Project Leader (PL) along the entire project lifecycle to ensure appropriate delivery in an agile and pragmatic approach.
  • Make data migration from model A to model B.

Key Skills

  • Bachelor or Master degree in Computer Science or equivalent
  • Minimum 5 years of experience as a BI Developer in the Microsoft BI stack SSIS/SSAS
  • Very good knowledge of Microsoft SQL Server (from a development perspective)
  • Good knowledge of the Microsoft development stack (Visual Studio, Visual Studio Code, SSMS, TFS)
  • Ability to translate business requirements into technical requirements
  • Good experience in data warehouse design (Kimball dimensional modeling and Data Vault)
  • Excellent knowledge of SQL queries, T-SQL, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Strong data modelling experience (conceptual, logical and physical modelling)
  • Experience in visualization tools such as Microsoft Power BI
  • Experience in master and reference data integration and usage is a plus
  • Experience in data functional analysis is a plus

Apply for this Job

This position was originally posted on Pro Unity.

It is publicly accessible, and we recommend applying directly through the Pro Unity website instead of going through third party recruiters.

Newsletter signup illustration