Data Analyst | Finance

Natixis in Portugal; Porto; Hybrid; EUR 45,000 - 65,000; Full time

Benefits offered by this job

Green Transportation Budget

Electric bikes

Honolulu Wellness Club

Prayer Room

Lactation Room

Themed Villages

Job summary

Natixis in Portugal is seeking a Data Analyst to join the Data Sourcing Accounting Data team within the Financial Data Integrity division. You will help uphold the accuracy of financial data across CIB activities, working in a bi-local team in Porto and Paris, and collaborating with Finance partners and IT teams.

You will monitor data quality, develop controls, perform queries, and support remediation plans to ensure reliable reporting and compliance with internal standards and regulatory

Qualifications

• Experience with data modelling and ability to retrieve & analyse data, and use data vizualization & data preparationtools (such as Power BI, Tableau, Quicksight, Google Analytics, ...)
• Knowledge in Microsoft Office (Excel, VBA, PowerPoint,…)

Responsibilities

• Monitor and analyse data at a granular level to ensure data quality for financial reporting
• Set up meetings with internal partners after quarterly closings to review outcomes
• Develop, test and deploy new data controls to improve completeness, accuracy and timeliness
• Oversee data acquisition and treatment within the financial data chain
• Detect anomalies and root causes and report findings to management and partners
• Prepare operational procedures and support Data Sourcing activities

Skills

Data modelling

SQL

Python

Power BI

Tableau

Quicksight

Google Analytics

Excel

VBA

PowerPoint

Tools

Power BI

Tableau

Quicksight

Google Analytics

Job description

Natixis in Portugal is a Centre of Expertise whose mission is to transform traditional banking by developing innovative solutions for the business, operations and work culture of Groupe BPCE worldwide.

As part of Groupe BPCE’s international division, Natixis in Portugal designs and delivers solutions for its two core areas — Corporate & Investment Banking and Asset & Wealth Management — as well as transversal services that support all entities across the Group.
With more than 3,000 employees representing 46 nationalities, the teams work across Information Technology, Banking Support Activities, and Compliance, in an integrated, inclusive, and cross-functional way, supporting all business lines and platforms of the Group.

A disruptive mindset and a culture of proximity and agility identify Natixis in Portugal Team and reflect the company's mission to transform traditional banking at a global scale: a perfect match in the Portuguese dynamics and entrepreneurial ecosystem.

Job Description

Team presentation and main goal:

Join the Data Sourcing Accounting Data team, within the Financial Data Integrity (FDI) division at Natixis, as part of the Finance Direction dedicated to upholding the integrity and accuracy of financial data across CIB activities (balance sheet and off-balance sheet).

Our team is split between Paris and Porto, part of a department, of around 150 professionals, and is on the frontline of labelling financial data for both balance sheet and off-balance sheet activities.

Data Sourcing is split between Paris and Porto, and you'll be an integral part of a 10-member team.

You will be part of an integral part of a 10-member bi-localised team with a local manager and a functional manager based in Paris.

As a Data Analyst, for of a major French banking institution with international dimension, you will:

Support Data quality initiatives to meet both internal standards and regulatory requirements, with a particular focus on ensuring the accuracy, completeness, and reliability of Critical Data Elements (CDEs). These efforts are crucial for enhancing the integrity of financial reporting and analysis across the institution.

Engaging in comprehensive data monitoring activities for Corporate and Investment Banking (CIB) sectors, including Financing and Global Markets. Your analysis will support data-driven decision-making and operational excellence in these key areas.

You will be in contact with the Operations department (middle and back offices), the other teams of FDI & the internal Finance partners, and Finance IT teams.

Functions:

Monitoring and analysing data at the granular level to ensure the quality of the data required for all financial reporting or indicators (ALM, Solvency, Liquidity, FINREP,…):

Set up meetings with final internal partners to do a post-mortem of quarterly closing;

Study and propose new controls to be implemented or to evolve existing controls (especially completeness, existence, accuracy, consistency, or freshness controls):

Analyze the needs of the final internal partners;

Perform database queries to study the relevance of results;

Test and launch in production new controls.

Controlling the data acquisition & treatment on the financial chain inputs, along the flow;

Detecting anomalies & analyzing the root causes;

Reporting and alerting the management and the internal partners (accounting and ratio teams);

Defining remedial short and long term actions;

Writing and updating of operational procedures;

Support the data sourcing activities.

As a Data Analyst, you will be integral in ensuring the quality and integrity of data across all levels, crucial for financial reporting and compliance with indicators such as ALM, Solvency, Liquidity, and FINREP. Your responsibilities include:

Post-Mortem Meetings: Organize debrief sessions with key internal stakeholders after quarterly closings to review outcomes and identify improvement areas.

Control Evolution and Implementation:

Collaborate with internal partners to understand their data requirements and challenges.

Conduct database queries to assess the relevance of data and identify gaps, particularly focusing on Critical Data Elements (CDEs) to ensure their accuracy and completeness.

Develop, test, and deploy new controls or refine existing ones to enhance data completeness, existence, accuracy, consistency, and timeliness.

Data Acquisition & Treatment: Oversee the data collection and processing stages within the financial chain, ensuring smooth and error-free data flow.

Anomaly Detection: Proactively identify data discrepancies, delve into their root causes, and communicate findings with relevant teams, emphasizing the importance of managing CDEs effectively.

Communication: Report findings, anomalies, and recommendations to management and internal partners (accounting and ratio teams), fostering a culture of transparency and continuous improvement.

Action Planning: Develop both immediate and long-term remediation plans to address identified issues, ensuring the robustness of financial data.

Operational Documentation: Regularly review and update operational procedures to reflect current best practices and data management strategies.

Data Sourcing Support: Play a key role in assisting the Data Sourcing teams by:

Implementing automation strategies to streamline data retrieval and analysis processes.

Enhancing the efficiency and reliability of data sourcing activities, ensuring high-quality data is available for decision-making and reporting.

Qualifications

• Experience with data modelling and ability to retrieve & analyse data, and use data vizualization & data preparationtools (such as Power BI, Tableau, Quicksight, Google Analytics, ...), SQL and Python.
• Knowledge in Microsoft Office (Excel, VBA, PowerPoint,…)

Soft Skills:

• Critical thinking, flexible and problem solving;
• Personal commitment and team spirit;
• Curiosity, and willingness to move the issues forward.

Additional Information

Our workplace reflects the vibrant spirit of our locations, with initiatives such as a Green Transportation Budget, electric bikes and a flexible Hybrid Work Policy. We promote wellbeing through the Honolulu Wellness Club, a Prayer Room, a Lactation Room, and themed Villages that inspire creativity and collaboration. Through our ESG and DEI strategies, we are committed to being inclusive, caring, and fair, ensuring every voice is heard and valued.