US Analyst - CFO Solutions

Crédit Agricole Group; New York (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

Crédit Agricole Group in the U.S. Analyst Program welcomes recent graduates to start a career in corporate and investment banking. The program provides training, mentoring and exposure across the Finance function.

It runs for up to two years with the objective of a permanent role, subject to performance and headcount. Collect and structure data from source systems, clean/reconcile data, analyze trends, and produce recurring reports for management, regulators and business lines.

Qualifications

• Strong data collection and structuring capabilities.
• Ability to clean and reconcile data from multiple sources.
• Experience translating data into clear reports and dashboards.

Responsibilities

• Collect and structure data from source systems and internal teams.
• Analyze data to identify trends, drivers, and risks for management.
• Produce recurring reports for management and regulators.
• Build dashboards and analytic tools using Python, Power BI and Excel.

Skills

Data collection

Data structuring

Data cleaning

Data analysis

Dashboard development

Reporting

Tools

Python

Power BI

Excel

AI tools

Job description

U.S. Analyst Program

The U.S. Analyst Program is for recent graduates starting a career in corporate& investment banking. It offers training, mentoring and exposure across the Finance function. The position runs for a maximum of two years, with the objective of developing the Analyst into a permanent role at the end of that period or earlier, subject to performance and available headcount.

Finance Department

The Financial Steering& ALM division sits within the Finance Department and covers3 product lines at Credit Agricole CIB Americas: Profitability & Internal Pricing (PIP), Asset/Liability Management (ALM), and CFO Solutions (CFX). This provides analysis of the Bank’s business activities across solvency, liquidity, balance sheet, profitability, regulatory status, and analysis of relevant data in order to provide optimization suggestions.

CFO Solutions is the data and analysis team within the division. It collects financial/regulatory data from a range of sources across the Bank, structures it so that it can be used with confidence, analyses it to find what is useful to management, and delivers the result through reports& analytical tools. Work is done in Python, Power BI and Excel,along withAI tools approved for use.

Position Overview

• Collect data from source systems& other teams, and structure it into a form that can be used/reused
• Check and clean data, and resolve differences between sources
• Analyze data to identify trends, drivers, risks etc. useful to management
• Produce the recurring reporting that goes to management, regulators, business lines
• Build and maintain dashboards, models and analytical tools, including business line scorecards, regulatory indicator views and balance sheet analytics
• Work with Python, Power BI and Excel, and use the Bank’s approved AI tools to work faster

Primary Responsibilities

Collecting/Structuring Data:

• Gather financial/regulatory data from source systems and from internal teams
• Clean, standardize, organize that data so it can be used consistently across reports and analysis
• Reconcile figures between sources, resolve differences where possible and escal
• Document data sources, definitions and reporting steps, so that processes do not depend on one person

Analyzing Data:

• Examine movements in P&L, balance sheet, capital and regulatory indicators, and identify what is driving them
• Look for trends, patterns and risks that management should know about
• Carry out variance and scenario analysis, and contribute to forecasting work as the team develops it
• Set out findings clearly, in writing and presentation material for senior management

Building Reports & Tools:

• Contribute to the monthly and quarterly financial reporting cycle
• Build/maintain Power BI dashboards covering P&L, balance sheet, capital, regulatory indicators
• Write Python to automate data collection, checks, report production
• Use AI tools to work faster on code, analysis, and documentation