EC Business Analyst L(0-9)

For out client EC we are looking for Business Analyst

1. DESCRIPTION OF THE TASKS

The following tasks will be performed by the external service provider:

For the majority of the tasks described here below, the objectives consist of: production of detailed
business/use case analysis, business specifications, definition of test plans, test scenarios, execution of
functional and technical tests, production of test reports including test results and recommendations. The
objectives above will be achieved through the following contract tasks.
2.1. Task 1: Analysis of Business requirements, business process and provision of new
business process models, functional requirements.
The general purpose of task #1 is the analysis of business requirements related to the EGR application
coming from the different stakeholders regarding the definition and the detailed specification towards
further improvements to be able to rollout Profiling on the structure directly in the EGR, for all the NSIs and
all the multinational enterprise groups that will be profiled on the structure in the next cycle. Finally other
maintenance activities related to the evolution of the EGR are included in the scope of the work.
The main existing tools/environments to be taken into account for this task are:
• The EGR applications, eDamis;
• The relevant technical documentation including issues described in JIRA and documentation which
will be provided to the business analyst concerning the ongoing and future project activities.
• Any other useful documentation relevant to the subject matter, the EGR applications and the
technical environment;
This task comprises:
• Identifying, organizing and carrying out meetings with the stakeholders to collect system
requirements and their rational
• Analysing requirements coming from the task force of the future EGR, and the producers task
force, as well as various stakeholders, related to the improvements needed so that profiling on the
structure can be performed for all the groups to be profiled on the structure directly in EGR in the
next cycle. Additionally analyse requirements in order to enable complete Eu profiling on the
structure and the statistical units directly in the EGR. Finaly other necessary evolution activities of
the EGR for the EGR users and producers.
• Maintaining the business specification for the EGR.
• Maintaining business process diagrams
• Review of existing documentation related to EGR and JIRA tickets for collecting and formulating
requirements missing from the technical specification of the system
• Preparation of new specifications for the evolution of the Early initial frame, and of the fast
consolidation process, as well as for other maintenance activities related to the EGR IM and FATS.
• Analysing the requirements and processing them into business process model specifications,
updating the EGR documentation, assuring the consistent data flow in the systems
Expected deliverables are:
• Preparation of analysis documents, requirements specifications.
• Preparation of specifications of business process models and breaking/detailing them in user stories
as per the agile methodology concept
• Update existing documentation
• Production of minutes
2.2. Task 2: Functional requirements and business cases analysis
The general purpose of task #2 is to deliver functional requirements and business cases analysis for the
requirements to be implemented in the EGR applications related to the necessary improvements needed to
scalet profiling on the structure in the EGR for all the groups to be profiled on the structure in the next cycle.
Additionally analyse requirements in order to enable complete EU profiling on the structure and the
statistical units directly in the EGR. Finaly other necessary evolution activities of the EGR for the EGR
users and producers.. The main existing tools/environments to be taken into account for this task are:
• The EGR applications, the IPT, eDamis;
• The relevant technical documentation including issues described in JIRA and related to the projects
and applications documentation;
• Any other useful documentation relevant to the subject matter, the EGR applications and the
technical environment.
This task comprises:
• Analysing the requirements and processing them into specifications, use cases and user stories,
updating the EGR documentation, assuring the consistent data flow in the systems
• Assist in the mapping of test plan and requirements specifications
• Requirements Traceability Matrix definition
• Descriptions of data to be entered into the system
• Descriptions of operations performed by each screen
• Descriptions of workflows performed by the system
• Descriptions of system reports or other outputs
• Description of different roles within the system and their responsibilities
• How the system meets applicable regulation requirements;
Expected deliverables are:
• Preparation of specifications/user stories as per agile methodology
• Update existing documentation
• Production of minutes
2.3. Task 3: Functional testing of the EGR implemented requirements related to the
evolution of the Early initial frame, and of the fast consolidation, as well as other
evolutive maintenance deliverables related to the EGR Core.
The general purpose of task #3 is to provide functional testing of the EGR applications in relation to further
evolution of the EGR applications related to the improvements needed so that profiling on the structure can
be performed for all the groups to be profiled on the structure directly in EGR in the next cycle. Additionally
analyse requirements in order to enable complete EU profiling on the structure and the statistical units
directly in the EGR resulting in the phase out of the IPT application. Finaly contribute in other necessary
evolution activities of the EGR for the EGR users and producers.
Within the whole work programme, task #3 will focus on functional testing.
The main existing tools/environments to be taken into account for this task are:
• the EGR database and applications;
• the relevant technical documentation;
• any other useful documentation relevant to the subject matter, the EGR applications, IPT
application/database and the technical environment.
This task comprises:
• Functional testing;
• Support to user acceptance testing (UAT);
• Revising of final application release documentation (User Guide, Administrator Manual, Release
Notes, etc.);
• Recording of issues in CITnet JIRA and appropriate following up until resolution;
• Participation in kick-off and progress meetings with Eurostat staff and other contractors;
Expected deliverables are:
• The test plan, defining the test session;
• The test cases defining in detail which steps will be carried out, what will be the pre-requisites and
what are the expected result;
• The test scenarios, defining a series of test cases belonging logically together as they intend to test
the functioning of one or several functions;
• The execution of the test cases
• The defects, to be reported at test case level and to be presented in a defect list with a clear
description and containing all needed references;
• The defects recorded and followed up in CITnet JIRA;
• Assistance in the preparation of test data (this can be in the form of scripts for export of data from
existing EGR database, scripts for scrambling data, scripts required for implementation etc.);
• Where appropriate support material must be generated to further detail the nature of a defect.
Support material can be videos showing the sequence of actions that lead to one or more defects or
documentation containing screenshots and further explanations. In both cases clear references
should be made to the defect number;
• Participation in kick-off, and progress meetings with Eurostat staff and other stakeholders of the
project;
• Production of minutes.

2. KNOWLEDGE AND SKILLS

Following skills and knowledge are required for the performance of the above listed tasks:

• Very good knowledge of SQL.
• Expertise in IT business analysis, functional, integration, performance and security testing. More
specifically Experience in business analysis in the official statistical production process and
particularly related to the statistical business registers is necessary.
• Ability to give business and technical presentations
• Ability to apply high quality standards
• Very good communication skills with technical and non-technical audiences
• Analysis and problem solving skills
• Capability to write clear and structured technical documents
• Ability to participate in technical meetings and good communication skills
• Knowledge of the EGR statistical process, and application ecosystem will be considered as a strong
asset, as a lot of time to learn the specific business domain and applications is required for a person
without previous experience on it.

3. Specific Expertise

4. Certification and Standards

Following certificates & standards are consider an asset for the performance of tasks:
• Certifications in Oracle/SQL

5. Service Delivery

The services shall be performed remotely in Near-site location allowing to reach the Commission premises in Brussels within 2  hours.
Laptop will be provided by the Commission.
The external service provider may be requested to participate in the meetings with the Commission’s services in Brussels (and exceptionally in other locations).