Business Intelligence Analyst

Context

 For supporting its Gas Flow Management related processes, our client has developed the GSmart application suite. Initiallystarted in 2004 with the liberalization of the Belgian and European energy markets, the application suite has evolved a lot on both functional and technical level.

Today it is a modern, user friendly and web-based suite that is not only used by our client but also by 8 different European TSOs (Transmission System Operators) both within and outside the Group. It covers the whole cycle from transmission capacity contracting, demand processing, optimized flow planning, network balancing, billing, invoicing, data publication and reporting, and business-to-business messaging (likewise for storage and terminalling).

The suite is developed by 8 teams of about 80 persons in total. As a Business Intelligence analyst, you will be part of the transversal reporting team that manages the central datawarehouses and handles all reporting needs from the functional product processes (e.g. contracting, flow planning, invoicing, data publication,). You will be involved in all aspects of the product lifecycle: gathering business process definitions and requirements from the business users, designing functional and technical solution specifications, creating test scenarios and assisting users in the user acceptance testing (UAT) as well as providing end user support.

Role & responsibilities

• As functional analyst you will also be responsible to analyse the different types of support and actively propose solutions to reduce it. As a technical analyst, you will need to performs technical analysis on the databases of the different software applications within Gas Flow Management to determine which data needs to be retrieved.  
• Actively participate in an agile development team using scrum 
• Collaborate with the team to break down a business requirement into estimated user stories, refine them to tasks and deliver user stories within a sprint
• Analyse user stories and translate them into the most appropriate conceptual model, while respecting the existing architecture and systems
• Create business process and functional system documentation using UML-artifacts (use case diagrams, activity diagrams, information models,…) using the standard tools and methodology
• Handover analysis to developer clarifying models, requirements and business context.
• Create and execute test scenarios on different levels (component, system, UAT)
• Assist the users during the execution of user acceptance tests
• Challenge and review your analysis and test results with team members
• Provide support to end-users on (critical) production systems
• Analyse the support work and propose improvements to reduce the amount of support
• Review functional documentation of peers

Profile

• Good analytical and synthesizing skills to clearly define problems and requirements as well as to determine solutions for data reporting (MUST)
• Experience working in agile Business Intelligence development team for at least one year (MUST)
• Knowledge and experience in multidimensional modelling (MUST)
• Knowledge of relational databases and good data investigation/querying skills.(MUST)
• Knowledge of UML (MUST)
• Good communication skills to interview end-users: listening actively to their needs, asking the right questions and interpreting the answers correctly (MUST)
• Experience providing support to end-users is an asset
• Background knowledge in the energy sector is an asset
• Fluency in the use of UML modeling tools (e.g. Sparx Enterprise Architect) (MUST)
• Data management in Microsoft SQL Server
• Management Studio
• Documentation / Communication tools (e.g. Microsoft Office)
• Knowledge of Microsoft SQL Server data warehouses, SSRS, SSIS and SSAS is an asset
• It is an asset to have knowledge of PowerBI
• Ability to work and communicate in a team (e.g. work together with developers to explain analysis, peer-review the analysis of other analysts, escalate impediments to scrum master, being flexible to help the team achieve its goals)
• Goal directed attitude: focus on delivering the planned user stories
• Pragmatic approach: talking to people and taking action to solve problems
• Improvement-minded: propose new improvement ideas during the sprint retrospectives
• Ability to adapt in an ever-changing environment
• Ability to advise stakeholders on different possible solutions
• Lifelong learner (e.g. new business processes, ways of working together or technical matters)
• Ability to fluently communicate in Dutch (spoken) or French (spoken) and English (spoken and written) (MUST)

We use the pronoun « they » or « the candidate » wherever possible to include all individuals when talking about candidates, regardless of their gender identity. We believe that everyone should be treated with respect, regardless of their gender identity.