BUSINESS INTELLIGENCE MANAGER
To provide Business Intelligence solutions to monitor the financial and technical implementation of the programmes under the responsibility of the Agency (Connecting Europe Facility (CEF) and Energy and Transport parts of H2020). S/he will work in unit R1, in the reporting team under the supervision of the Reporting Coordinator and in close cooperation with the other members of the team.
Working tools: Oracle, SQL Server, Business Objects, Qlik Sense, MS Access and advanced Excel
Provide business intelligence solutions to monitor the financial, technical implementation and policy-relevant components of CEF and H2020 – Develop and maintain business intelligence solutions in Qlik Sense, Business Objects, MS Access, MS Excel or similar tools. – Ensure data quality and validate data encoding against agreed concepts and methodologies in view of maintaining a high degree of reliability of data sources. – Cooperate with parent DGs and other stakeholders in view of adapting data analytical concepts to their needs and produce management information and implementation statistics to support the top management in its decision-making process. – Support main administrative tasks by processing and producing adequate data
Data Processing and data analysis: – Design, implement and maintain an INEA Data Warehouse from several corporate systems by using ETL solutions. – Design and manage a database system on the technical and financial implementation of the Programmes to be used as an input to informed decision-making, such as call planning, optimal allocation of resources, etc. – Create Procedures, Packages, Functions using SQL, PL/SQL to effectively answer to the reporting requirements according to a specific methodology. – Write advanced SQL including query tuning, optimize query performance and other database objects. – Document the solutions and where appropriate give feedback to the stakeholders. – Follow-up IT developments and define new requirements for the corporate systems to be integrated afterwards in the Data Warehouse. – Provide support for compilation, data processing and production of data relating to proposals, contracts and participation in the programme.
Internal and external communication – Handle requests for information (i.e. to be included in briefings or presentations of the commissioner), and prepare the appropriate responses. – Support the production of leaflets and other statistical publications with the results from both Programmes.
Effective participation and contribution to teamwork – Under the leadership of the team leader, carry out his/her tasks in a timely and effective manner and work together with other team members, to support the mission and priorities of the Unit and the Agency. – Maintain effective communication and share information within the team ensuring that all team members are aware and regularly informed on all developments related to their work and performance.
A. Eligibility criteria • Be the owner of a CAST in the grade for which you are applying* Or be registered in the EPSO/CAST/P/17/2017**; • A level of education which corresponds to completed university studies of at least three years attested by a diploma Or, When in a member state of the European Union access to a profession of an equivalent level to function group IV is by State examination, professional training or any other equivalent procedure, the authority authorized to conclude contract of employment may agree to recognize this qualification as being equivalent to a university degree; • Thorough knowledge of one of the languages of the European Union and a satisfactory knowledge of another one to the extent necessary to perform his/her duties. * Candidates must be included in the European Personnel Selection Office (EPSO) database for contract agents in function group IV and have successfully passed the EPSO selection tests for that function group. Please note that candidates who are on a valid EPSO list published in 2010 (CAST2010) are eligible on the condition they have successfully passed the complementary tests (DB3), as an Annex to the selection procedure CAST2010. The candidates concerned are invited to consult the letter they received from EPSO for further information.
Other eligibility criteria
** In the context of the call for expression of interest EPSO/CAST/P/17/2017 procedure, your application will be considered only if you are available to be flagged for the EPSO testing request during the screening phase of this selection process . The pre-selected candidates will be requested by the Agency to undergo the EPSO tests. Only candidates that have successfully passed the EPSO CAST selection will then be invited for an interview. In addition, in order to be eligible, a candidate must: • be a national of one of the Member States of the European Union; • be entitled to his/her full rights as citizen; • meet the appropriate character reference as to his/her suitability for the performance of his/her duties; • have fulfilled any obligations imposed by the applicable laws concerning military service, and; • be physically fit to perform the duties linked to the post.
Please note that only candidates that comply with the Eligibility criteria will be considered for further steps of this Selection procedure.
Applications closing date: 13 September 2019