General Description
The BI developer & Data Functional Analyst plays a key role in the development of data processing solutions and data warehouses. He/she is in regular contact with the Business to understand business needs and translate them into data and technical requirements. He/she works in
close collaboration with the data architect and the Project Leader. The Bi & Data Functional Analyst developer sits within the central Data Office Organization. The Data Office Organization is a central organization providing data services across the different business lines.

Roles & Responsibilities
• Interviews end business users to determine requirements for BI projects
• Translate business needs into data model with appropriate documentation.
• Works with data architects to translate requirements into technical specifications
• Develops, manages, and updates data models, including physical and logical models of the data warehouse and data marts
• Design, build and deploy BI solutions according to established standards (data processing, data warehouse, data marts)
• Participate in the definition and documentation of the technical architecture of the data warehouse, including the physical components and their functionality.
• Develop data processing solutions (data acquisition, ETL, ELT,..) that meet the functional and non-functional requirements (performance, data volume)
• Create visualizations and reports for requested projects in Power BI or SSRS
• Maintain and support data analytics platforms. Evolves models to meet new and changing business requirements
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Develop and update technical documentation
• Conduct prototype reviews and demo’s including training on the data model to the business users
• Works with the Project Leader (PL) along the entire project lifecycle to ensure appropriate delivery in an agile and pragmatic approach.

Key Skills
• Master degree in Computer Science or equivalent
• Minimum 5 years of experience in data functional analysis and BI development 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
• Strong Data modelling experience (conceptual, logical and physical modelling)
• Good experience in data warehouse design (Kimball dimensional modeling and Data Vault)
• Excellent Knowledge of SQL queries, 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 tool such as Microsoft Power BI and SSRS
• Experience in SAS tool is a plus (SAS Viya)
• Experience in Master data Management and Data quality Management is a plus
• Knowledge of the following tools is a plus : modeling tool (e.g. Enterprise Architect), Azure data analytics tools (Azure data factory, Databricks,…)
• Experience in project management is a plus

Profile
• Strong conceptual, communications, and technical skills
• Analytical mind with a problem-solving aptitude
• Ability to develop relationship with the Business and data stakeholders, develop trust and buy-in with active listening and assertiveness
• Ability to translate business needs into technical solutions
• Strong problem-solving, 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
• Good command of Dutch, French and English