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 related to the Early initial Frame, in terms of the time it takes to be produced, as well
as its use in order to achieve an event driven approach and a continuous frame, as well as the further change
of the consolidation process to become significantly faster, 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 evolution of the Early initial Frame and the fast
consolidation, or other necessary evolution activities of the EGR.
• 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 Core.
• 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 step of improvements
related to evolution of the Early Initial Frame, and of the fast consolidation, aiming towards a continuous
frame. Additionally maintenance activities regarding the evolution of the EGR Core applilcation, will also
require the elaboration of functional requirements. 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 evolution of the Early Initial Frame and of the fast
consolidation process, in order to move towards an event driven approach and a continuous frame, the
necessary subsequent maintenance releases, as well as of other evolutions of the EGR Core.
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).