MS Excel consultant (20556, L5)

Package Description

Excellent Salary 

Corporate Benefits Package 

Relocation Assistance (if applicable)

And the chance to make a positive difference in a company passionate about diversity and inclusion.

Further information available from the Serco Europe Recruitment Team

Job Introduction

Serco is a partner of choice to the European Institutions and other International Organisations. For the past 30 years, we have been providing European and International Organisations a wide range of services including ICT services in support, infrastructure, operations and development as well as managing different contact centres for the key European Institutions, agencies and organisations, in Brussels and across Europe.

What connects the ever-growing Serco workforce is a passion for delivering great service –
To keep ahead, we have to evolve continually and enhance the way we deliver our services. Everyone in Serco has a role to play, here.

Serco provides the right environment to encourage ideas and a comprehensive Best Practice support network that enables them to put their ideas into action.

We are hiring a MS Excel consultant for our prestigious partner DG Mare in Brussels. DF Mare is a contract from the European Commission that proposes and manages fishing quotas for the North East Atlantic for shared stocks negotiated with the United Kingdom, Norway and other Coastal States.

If you like to work in a multi-cultural and dynamic environment, this opportunity can answer to your expectation.

We look forward meeting you!  Discover the offer below and click on ‘Apply’ if you know that your skillset and talents are a suitable match for this opportunity!

At Serco, we do not only offer a career but also the opportunity to join a community where everyone’s wellbeing matters, by living out the Serco values in all we do!

Main Responsibilities

Are you looking to secure a career in a public sector environment? We would love to hear from you! 

As MS Excel consultant you will be responsible for:

• Integrate all the provisional ad-hoc calculations made in the IT tools or on separate Excel sheets into one single and standard version of the IT tools. The reference used to compare will be the IT tool pre-Brexit.
• Adapt and create new formula links and calculations for difficult exceptions and stocks (ex: Mackerel) to cater for the addition of a new third country and the division of the stock allocations at certain points of the calculations.
• Carry out testing with the help of the relevant desk officers to make sure that output is in line with the objectives, and that desk officers can take over for the usual use of the IT tool in view of the upcoming fishing opportunities exercise.
• Prepare the IT tools for all the following years of the transition period under the TCA: adapt the relative stability keys of TACs that will change each year until 2026, by creating separate versions (or one manually adaptable version) of the Excel sheet that will be used for each of the years.

In return, we offer a friendly, supportive and professional environment that respects your work/life balance and ultimately contributes to the delivery of public services in Belgium and around the world.

Successful Candidate

You will work at DG MARE's IT sector and you will be able to balance work and family life. We are committed to a diverse workforce and enjoy multiculturalism. For practical reasons, English is the internal working language while French may be needed for communication with external stakeholders. Any other language is considered and advantage.
We expect you to be able to team work and communicate in such environment, to be strong teamplayers. Good communication skills are critical to the success in this job. You should be able to talk with peers and communicate both in technical and non-technical terms with other colleagues, including business stakeholders. Critical thinking, proactivity and forward looking are compulsory.
The applications for control of fisheries are rather complex and need an important knowledge of applicable legislation to understand business requirements. Willingness to learn the underlying business concepts, processes and modules is essential for the execution of the tasks.

Education and technical expertise

• Desirable : MO-201: Microsoft Excel Expert (Excel and Excel 2019)
• Task automation using macros and VBA
• Building complex formulas
• Cell formatting
• Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
• Task automation
• Creating dynamic reports with PivotTables
• Manipulate date, time, text, and arrays
• Building charts and graphs

Languages

• Fluent in English. French is an asset.
• Documents will be written in English.

------------

Important

Any offer of employment is contingent upon you providing documents to verify your identity and employment eligibility, as required by law.

Applicants are reminded that they will be requested to produce such documentation during the recruitment process.

Please contact a member of the recruitment team if you require further details of acceptable types of documentation required for verification of identity and work authorization. 

Data Protection:

When creating a profile on the Serco Career Centre you agreed to the Data Protection policy, a copy is available upon request.

You may submit a written request revoking your consent to this agreement at any time.

About the Company

Why should you join Serco ?

At Serco not only is the nature of the work we do important, everyone has an important role to play.

Meaningful and vital work - You’ll contribute to methodologically intercepting challenges whilst achievements will also be recognised and celebrated.

A world of opportunity - You’ll be wholeheartedly supported with development and career progression

Great people - You’ll become an integral member of a well-defined and supportive team who believe passionately in the value of our work.

What we offer

• Chance to contribute to innovation in the public services sector
• A company passionate about diversity and inclusion
• Permanent employment with comprehensive Serco Benefits package.
• Pension

About Serco

At Serco, not only is the nature of the work we do important, everyone has an important role to play when managing complex public services.  

We are a team of 50,000 people responsible for delivering essential public services around the world, we are innovators, committed to redesigning and improving public services for the benefit of everyone.

By joining Serco you will have unlimited access to our Global Employee Networks – SercoInspire (Gender), SercoEmbrace (Multicultural), SercoUnlimited (Disability) and In@Serco (LGBT & Networks). Serco Employee Networks, led by colleagues who are passionate about diversity, inclusion and belonging. 

Apply

Please click on the apply button to be taken to our careers website

Serco is a Disability Confident Employer committed to employing and retaining people with disabilities.  Disabled applicants who meet the minimum criteria for the job will be given the opportunity to demonstrate their abilities at an interview.