Data Analyst | Finance

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.

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.

• Background/Education in a quantitative discipline;
• Experience with data modelling and ability to retrieve & analyse data, and use data vizualization & data preparation tools (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.

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.