Data, Reporting & Automation Analyst (Payroll) | French Speaker - Viseu

EY; Ranhados, Lisboa; On-site; EUR 26,000 - 38,000; Full time

Job summary

EY is hiring a Payroll Data, Reporting & Automation Analyst (Payroll) to join our Portugal Shared Service Center in Viseu, supporting French payroll operations. The role focuses on data analysis, reporting, controls and automation to improve payroll accuracy and efficiency.

You will collaborate with teams in France, develop Excel-based tools and VBA solutions, and contribute to digital transformation initiatives within Payroll, ensuring high-quality service delivery in an international

Qualifications

• Bachelor’s degree in a relevant field and at least 1 year of experience in data analysis or reporting.
• Advanced Excel skills with PivotTables, Power Query and complex formulas.
• Experience with VBA and automation.
• Ability to work with large datasets and ensure data quality.
• Fluent French (C1) and English (B2) for communication in an international environment.

Responsibilities

• Support French Payroll teams with data extraction, validation, analysis and reporting.
• Prepare control, reconciliation and analysis files for payroll production.
• Perform data quality checks and investigate anomalies.
• Produce operational reports and dashboards for payroll teams and management.
• Develop and maintain Excel-based tools and automation solutions including VBA macros.
• Identify opportunities to automate repetitive activities and reduce manual workload.
• Contribute to improving existing reporting and analytical tools.
• Support continuous improvement and digital transformation in Payroll.

Skills

Analytical skills

Advanced Excel

Data analysis

Automation mindset

Communication in English & French

Education

Bachelor's degree in Information Systems

Bachelor's degree in Data Analytics

Bachelor's degree in Finance

Tools

Power Query

VBA

Excel macros

Microsoft 365 tools

Job description

Data, Reporting & Automation Analyst (Payroll) | French Speaker - Viseu

Other locations: Anywhere in Country

Date: Oct 20, 2026

Requisition ID: 1754531

The opportunity

At EY, you’ll have the chance to build a career as unique as you are, with the support, inclusive culture and technology to become the best version of you.

We are looking for a Payroll Data, Reporting & Automation Analyst to join our Payroll Shared Service Center in Portugal, supporting our French Payroll operations.

In this role, you will work closely with Payroll, Project and Management teams based in France, supporting payroll operations through data analysis, reporting, operational controls and automation.

This is an opportunity for someone who combines strong analytical capabilities, advanced Microsoft Excel skills and fluency in French with an interest in process improvement and automation. You will contribute not only to the accuracy and efficiency of payroll-related activities, but also to the development of smarter and more automated ways of working.

Working in an international environment, you will collaborate regularly with colleagues in France and contribute to the continuous improvement and digital transformation of payroll operations.

Your key responsibilities

As a Payroll Data, Reporting & Automation Analyst, you will:

• Support French Payroll teams with data extraction, validation, analysis and reporting activities;
• Prepare control, reconciliation and analysis files to support payroll production;
• Perform data quality and consistency checks, identifying anomalies and supporting their investigation and resolution;
• Produce operational reports and dashboards to support payroll teams and management;
• Analyse payroll-related data, identifying trends, inconsistencies and potential operational risks;
• Develop and maintain Excel-based tools and automation solutions, including VBA macros;
• Identify opportunities to automate repetitive activities and reduce manual workload;
• Contribute to the improvement and optimization of existing reporting and analytical tools;
• Support continuous improvement and digital transformation initiatives within Payroll;
• Contribute to the standardization and documentation of processes and working methodologies;
• Collaborate with teams based in France and participate in meetings conducted in both French and English;
• Support the achievement of service quality, accuracy and delivery objectives.

Skills and attributes for success

To succeed in this role, you should have:

• Strong analytical and problem-solving skills;
• Advanced knowledge of Microsoft Excel, including PivotTables, Power Query, advanced formulas and reporting/dashboard functionalities;
• Knowledge of VBA and Excel automation;
• Ability to work with and analyse large datasets;
• Strong attention to detail, data quality and accuracy;
• A proactive and continuous improvement mindset;
• Ability to identify opportunities for process optimization and automation;
• Strong organizational and prioritization skills;
• Ability to manage multiple activities and deadlines effectively;
• Strong communication and collaboration skills in an international environment;
• A client and stakeholder-oriented mindset.

To qualify for the role, you must have

• A Bachelor's degree in Information Systems, Data Analytics, Management, Finance, Economics, Engineering, or another relevant field;
• At least 1 year of professional experience in data analysis, reporting, finance, HR, payroll or other relevant operational activities;
• Advanced proficiency in Microsoft Excel;
• French at C1 level or above, with the ability to communicate effectively in both written and spoken French in a professional environment;
• English at B2 level or above;
• Ability to work effectively with international and remote teams.

Ideally, you’ll also have

• Experience developing VBA macros or other automation solutions;
• Experience with Power Query and data transformation;
• Previous experience in a Shared Service Center or international service delivery environment;
• Experience supporting offshore or nearshore operations;
• Knowledge or previous exposure to payroll processes;
• Experience with Microsoft 365 collaboration tools;
• Portuguese language skills, although these are not mandatory.

What we look for

We are looking for someone who is analytical, curious and detail-oriented, but who also enjoys challenging existing ways of working and finding opportunities to make processes more efficient.

You should be comfortable working with data, investigating inconsistencies and translating operational needs into practical reporting or automation solutions.

As you will work closely with teams based in France, strong communication skills and the ability to build effective working relationships in a remote and international environment will be particularly important.

Above all, we are looking for someone who combines data and technical capabilities with a strong service mindset, and who is motivated to contribute to the continuous improvement and digitalization of Payroll operations.

EY | Shape the future with confidence.

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.
At EY, we're committed to providing recruitment and career opportunities to all, regardless of gender, sexual orientation, social background or disability. We believe that equality and diversity are central to our recruitment process, as they enhance creativity and efficiency, leading to improved performance and productivity. In line with this commitment, EY Portugal recently became a member of the Inclusive Community Forum. This initiative, led by Nova SBE, focuses on the recruitment of individuals with disabilities, advocating for a more inclusive community. Moreover, EY Portugal has also endorsed the Diversity Charter of APPDI (the Portuguese Association for Diversity and Inclusion), pledging to establish and develop internal policies and practices which support diversity. Through these initiatives, EY seeks to actively contribute to the inclusion process, and promote a more inclusive community for people with disabilities, by actively participating in creating solutions.

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.