ALTERNANCE - Analyste production ALM H/F
Groupe Crédit Agricole · Montrouge, Île-de-France, France
- On site
- Internship
- $25,000 / year
- Montrouge, Île-de-France, France
Job highlights
- Manage and produce ALM indicators using RCO tool.
- Integrate and control financial data for delivery.
- Support ALM managers with tool-related queries.
- Automate internal tools and develop reporting.
- Gain skills in data quality, SQL, Python, VBA.
About the role
About Groupe Crédit Agricole
Joining Crédit Agricole S.A. Finance means contributing to the financial and sustainable steering of the Group. It means working for our clients and society, in conjunction with subsidiaries and regional banks, and in close collaboration with other support functions.
The Group Financial Steering Department, through its expertise and skills, supports the development of all businesses by steering the Group's financial and sustainable equilibria over the long term, in compliance with regulatory requirements.
Your Role in ALM and the PALMA Support Center
You will join the Assets and Liabilities Management (ALM) Department, responsible for managing interest rate risk for the Crédit Agricole Group, and more specifically the PALMA Support Center. This mission will allow you to gain knowledge in Bank Balance Sheet Management, particularly in Interest Rate Risk management.
The PALMA Support Center (10 people) is responsible for ensuring the smooth production of ALM indicators calculated in the ALM management tool (SI PALMA/RCO). The CSP's missions include supporting ALM managers and management controllers in using the PALMA tool, monthly production according to a defined and validated schedule, and tool management with our partners (IT, Project, Users).
Your Mission
You will join agile teams, demonstrating initiative and a passion for numbers and challenges, in a constantly evolving environment. Your mission, should you accept it, is to join the PALMA production team, responsible for overseeing and ensuring the smooth production of ALM indicators calculated in the RCO (Moodys) tool.
This application covers the needs of Crédit Agricole S.A. (central body), the 39 regional banks, Crédit Agricole social entity, LCL, and the CAPFM group:
- Be trained in the CSP's monthly production process, particularly in data integration and control, a prerequisite for delivering indicators to tool users.
- Leverage your analytical skills and critical thinking by providing regular support to ALM managers in the entities (regional banks) on the various reports generated in the RCO tool (interest rate gaps, TCI calculation).
- Participate in the maintenance/evolution and automation of the CSP's internal tools.
- Produce various regulatory reports monthly (e.g., accounting-management reconciliation).
What This Role Offers
This experience will allow you to:
- Develop skills in data management and data quality (databases, office applications, query tools, etc.).
- Develop the ability to respond to requests from expert users in their field.
- Strengthen your technical abilities in various languages (SQL, Python, VBA).
Key skills/competency
This job requires a combination of technical and soft skills relevant to an Alternance Analyst Production ALM. Key competencies include data manipulation, programming languages like SQL, VBA, and Python, understanding of banking balance sheets, strong analytical skills, autonomy, rigor, and excellent interpersonal skills. Proficiency in advanced Excel, particularly with Pivot Tables and functions, is also essential.
Skills & topics
- ALM
- Finance
- Production Analyst
- Crédit Agricole
- Alternance
- SQL
- Python
- VBA
- Banking
- Risk Management
- Data Analysis
- Financial Steering
- RCO
- Moodys
- Internship
- Apprenticeship
How to get hired
- Tailor your resume: Highlight your analytical skills, data manipulation experience, and any knowledge of SQL, Python, or VBA. Emphasize your academic background in finance or IT.
- Craft a compelling cover letter: Express your strong interest in ALM, interest rate risk, and the specific tools mentioned (PALMA/RCO, Moodys). Showcase your understanding of Crédit Agricole's mission and values.
- Prepare for technical questions: Be ready to discuss your experience with Excel, SQL, Python, or VBA, and demonstrate your problem-solving approach to data integration and control tasks.
- Demonstrate behavioral fit: Prepare examples that showcase your rigor, autonomy, problem-solving abilities, and capacity to work in a team within a dynamic environment.
Technical preparation
Behavioral questions
Frequently asked questions
- What are the main responsibilities of an Alternance Analyst Production ALM at Groupe Crédit Agricole?
- As an Alternance Analyst Production ALM at Groupe Crédit Agricole, you will be responsible for supporting the monthly production of ALM indicators using the RCO tool, integrating and controlling data, assisting ALM managers, and participating in tool maintenance and automation. You will also contribute to regulatory reporting.
- What technical skills are essential for this Alternance Analyst Production ALM role at Crédit Agricole?
- Essential technical skills for this role include advanced proficiency in Excel (Pivot Tables, functions), knowledge of at least one programming language such as SQL, VBA, or Python, and ideally, a basic understanding of banking balance sheets and financial products.
- What is the PALMA Support Center and its role within Groupe Crédit Agricole?
- The PALMA Support Center is a team of about 10 people within the ALM department of Groupe Crédit Agricole. Its main role is to ensure the smooth production of ALM indicators calculated in the SI PALMA/RCO tool, support users, and manage the tool with IT and project teams.
- What kind of career development can I expect as an Alternance Analyst Production ALM at Crédit Agricole?
- This experience at Crédit Agricole will allow you to develop strong skills in data management and quality, enhance your ability to support expert users, and strengthen your technical abilities in languages like SQL, Python, and VBA, providing a solid foundation for a career in finance or IT.
- How does this role contribute to Groupe Crédit Agricole's financial steering?
- This role directly contributes to the financial steering by ensuring the accurate and timely production of ALM indicators. These indicators are crucial for managing interest rate risk, piloting financial equilibria, and ensuring compliance with regulatory requirements, supporting the Group's sustainable development.