Role

The Data Functional Analyst & BI Developer plays a key role in the development of data solutions (data warehouses and data marts) for NIHDI (INAMI RIZIV). He/she is regularly in contact with the Business to understand business needs and translate them into data and technical requirements. He/she has sufficient hands-on expertise with the Microsoft SQL Server BI technology stack. This includes knowledge of Power BI and Azure Databricks.

The Data Functional Analyst & BI Developer is part of the Data Office, a central organization delivering data services within the various NIHDI business lines. He/she works in a scrum team in close collaboration with the Proxy Product Owner and the Data Architect of the project.

Responsibilities

• Facilitate and conduct interviews with business end users to determine functional and non-functional requirements for BI solutions;
• Translate business needs into logical and physical data models with the appropriate documentation;
• Collaborate with the data architect to translate requirements into functional and technical specifications;
• Design, build, implement, and maintain BI solutions according to established standards (data integration, data warehouse, data marts) in line with the functional and non-functional requirements (performance, data volume);
• Test the analytical solution, perform troubleshooting, and ensure maintenance and 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 business users;
• Collaborate with the Project Leader (PL) throughout the entire project lifecycle to ensure appropriate delivery in an agile and pragmatic approach.

Key skills

• Master's degree in Computer Science or equivalent;
• Minimum 7 years of experience in data functional analysis and BI development in the Microsoft BI stack (including SSIS/SSAS);
• Minimum 7 years of experience in data engineering with Azure Databricks, using Python;
• Ability to translate business requirements into functional and technical specifications;
• Strong experience in data modeling (logical and physical modeling);
• Good experience in designing data warehouses (Kimball dimensional modeling);
• Very good knowledge of Microsoft SQL Server (from a development perspective), SQL queries, T-SQL;
• Very good knowledge of Python in a data engineering context;
• Good understanding of database management systems, online analytical processing (OLAP) and ETL framework;
• Experience with visualization and reporting tools such as Microsoft Power BI and SSRS;
• Experience in Master Data Management and Data Quality Management is a plus;
• Knowledge of the following tools is an asset: modeling tool (e.g., Enterprise Architect), Azure data analytics tools (Azure Data Factory, Databricks, ...);
• Experience working in an agile project mode is a plus.

Profile

• Strong conceptual thinking and technical skills;
• Proactive profile, a real doer;
• Good communicator (proactive, not passive, active listening, clear/precise/concise);
• Analytically minded with a pragmatic problem-solving approach;
• Ability to build relationships with business and data stakeholders, create trust and buy-in;
• Ability to translate business needs into workable solutions;
• Team player with the ability to work in a collaborative spirit within a transversal organization;
• Persistent, stress-resistant, and flexible;
• Eager to learn and open-minded.

Summary of the job description

As a Data Functional Analyst & BI Developer, you are responsible for gathering business requirements, translating them into functional and technical specifications, defining the data model (logical and physical), and developing a BI solution using the Microsoft stack (SSIS/SSAS) and/or Azure.