US Analyst - CFO Solutions

Crédit Agricole CIB; New York (NY); On-site; USD 60,000 - 80,000; Full time

Job summary

The U.S. Analyst Program at Crédit Agricole CIB Americas is designed for recent graduates starting a career in corporate & investment banking.

It provides training, mentoring and exposure across the Finance function, with a maximum duration of two years and a path to a permanent role based on performance and headcount. The program operates within the Finance Department, focusing on data analytics, reporting and model development using Python, Power BI and Excel, with AI tools approved for use to

Qualifications

• Recent graduates entering corporate & investment banking and willing to develop across Finance functions.
• Ability to gather, clean and structure data from multiple sources.
• Strong analytical and presentation skills for senior management.

Responsibilities

• Collect and structure data from source systems and internal teams.
• Analyze data to identify trends, drivers, risks and forecasts.
• Build and maintain Power BI dashboards and Python-based automation for reports and tools.

Skills

Data analysis

Data cleansing

Dashboarding

Communication

Tools

Python

Power BI

Excel

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 covers 3 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 with AI 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 escalates the rest
• 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