Key Responsibilities

I – Audit/Loan review assignments and Continuous Monitoring

·Identify and acquire the necessary data from relevant source systems used by Internal Auditors and Loan Review Analysts to develop data analytics needed to support IGE team

·Contribute to audits’ planning, analyzing data and identifying areas to automate the testing

·Present automation proposals to IGE’s management on existing processes and/or testing

·Collaborate with audit teams to design and execute testing

·Perform testing creating codes that can be used in different audits

·Design and build data analytics scripts to meet specific audit objectives and determine if these can be reused on a continuous basis to strengthen the assessment of internal controls

·Publish analytics results to the Internal Audit teams, and provide support / training as necessary to interpret and refine the results of the analytics provided

·Expand the library of Python automation scripts currently used by the department during continuous monitoring mission

II – IGE Continuous Improvement Program / Transversal topics

The Data Analyst contributes to the continuous improvement of IGE methodologies and processes. As part of his/her responsibilities, he/she can be requested to:

·Build and share knowledge (e.g. through contributing to SynerGIA, preparing and presenting   Knowledge Express, taking active part in various Methods and Support projects)

·Perform continuous monitoring of the different portfolios and business lines by analyzing data and trends using data analytics

·Prepare different committee presentations, summarizing the findings from the continuous monitoring performed

·Actively participate in global initiatives aimed at improving Internal Audit’s processes and procedures

·Create codes that will allow IGE to conduct continuous monitoring on a global basis

·Actively participate in one or several knowledge communities within IGE

The Data Analyst is regularly trained on banking and regulatory matters and must always maintain a sufficient knowledge of the different data tools that he/she has access to (Python, PowerBI, Dataiku, etc). He/she must complete all the mandatory trainings within the defined timelines.

Management and Reporting 

Direct reporting line to Head of IGE Americas

Key Internal contacts

IGE Americas team

IGE HO Data Analyst

Auditees, other control functions

Role specific requirements

Data Analyst must comply with the CACIB Audit Charter, in particular the five fundamental ethical principles (integrity, objectivity, confidentiality, expertise, and transparency) and all other locally applicable regulations.

Bachelor’s or Mater’s degree in engineering or statistics

At least 2 years of experience in data analytics (internal / external)

Essential

·         Ability to communicate clearly and easily, including in writing

·         Ability to analyze and summarize

·         Ability to learn new coding / use of new tools

·         Rigor and sense of organization

·         Attention to details, accuracy

·         Analytical skills

·         Autonomy

·         Ability to work with global teams

·         Team player

·  Proficiency with data analytics tools (Excel, PowerBI)

·  Python / Coding skills

·  Basic knowledge and understanding of the risks generated by banking / securities activities

Desirable

·  Relationship management

·  Capacity to cooperate

·  Ability to work across disciplines

·  Basic French

·  Dataiku, SQL Server, SAS, Access

·  DataViz (Power BI, MicroStrategy…)

·  coding (Python, R, Cypher…)

·  Big Data