Senior Data Analyst

Company 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.

Natixis in Portugal is part of the Global Financial Services division, where it applies technology for the development of financial expertise in its two global business lines – Corporate & Investment Banking and Asset & Wealth Management – and, transversally, for the entities of Groupe BPCE.

The Centre of Expertise, based in Porto, currently has more than 2,400 employees from over 30 nationalities, organised in three main departments: Information Technology, Banking Support Activities and Compliance. These teams work in an integrated, inclusive and transversal way, supporting and creating value for all the business lines and platforms of the group. The project in Porto is one of the biggest investments in Human Resources ever made by Groupe BPCE worldwide.

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.

In 2024, Top Employers Institute has awarded Natixis in Portugal the Top Employer Portugal accreditation for the second time. This certification recognizes excellence in people practices, following the example of our head office, in France, who was certified Top Employer France for the eight year in a row.

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.

Additional information:

• You will be part of a bi-localised team with a local manager and a functional manager Paris based, with regular interactions Paris team;
• The ability to develop a network within the various teams of the Natixis ecosystem, and an aptitude for collaborative and group work are key factors of success in this position.

Qualifications

• Strong Background/Education in a quantitative discipline, with a professional experience as a Data or Business Analyst, preferably in the finance department of a mid / large cap company or audit;
• Data or Business Analyst (notions);
• Financial Products (advanced knowledge);
• Data Viz & Data Prep Tools (Power BI, Tableau, Quicksight, Google Analytics, …) (advanced knowledge);
• Python (advanced knowledge);
• SQL (advanced knowledge);
• Microsoft Office (Excel, VBA, PowerPoint,…) (advanced knowledge);
• Project Management (advanced knowledge);
• Other Programming Languages (notions);
• Fluent English and Good Level of French (a big plus).

Soft Skills:

• Rigor and accuracy;
• Ability to analyse, summarise and report;
• Critical thinking, flexible and problem solving;
• Personal commitment and team spirit;
• Autonomy, curiosity, and willingness to move the issues forward. 

Additional Information

At Natixis, we are committed to fostering a working environment where each and every one of our people is treated with dignity and respect and where every voice is heard. Our differences make us collectively stronger and are a source of fulfilment, innovation and performance.

In the framework of its Diversity, Equity & Inclusion policy, Natixis in Portugal has implemented a Blind CV Screening process, with the purpose of reducing hiring bias. A blind CV excludes any personal details which refer to the applicant’s gender, age or ethnicity. When applying for our positions, please submit a blind CV, that is, with no picture, name, gender, age, nationality, ethnicity and address. Your personal statement, work experience, courses and certifications, education, skills and contact information is what matters to us.

#MuchMoreThanJustAJob

Early morning. Campo 24 de Agosto. In 4 minutes, you are clocking in at the office. Start your day having breakfast with the Team and grab fresh fruit on the way to your seat, in one of Porto’s most typical neighborhoods. This Purple Day is going to be a busy one: daily meeting ensuring all team members are on the same page regarding work status, priorities and blockers, language class and, just after, a Talent Management meeting with your manager, discussing your career path. 

 Lunch break. Today, your Team is onboarding newcomers, but also welcoming French colleagues: the perfect excuse to walk downtown and bond over a francesinha. When returning, inhale nature and peace of mind in Natixis Urban Garden (look at the crops; ready to harvest!). 

 Back inside. Brainstorming session on a new, exciting project in our disruptive and immersive Manaus Village. The afternoon went flying (tasks, meetings, some jokes with your teammates). End it on a high note: celebrating cultural diversity with a Diwali, the Indian festival of lights. 

 Tomorrow, you attend a conference led by influential speakers in your industry and, the day after, you will work from home, benefitting from some focus time to complete that report and soft skills course on LinkedIn Learning. Once you are done with your work for the day, strike the right note playing with Natixis band or be part of a board games session. If that is too steady for you, meet your colleagues to catch some waves or sail the Douro river during golden hour.