Summary of the position

The IGE Data Auditor is responsible for acquiring, executing, transforming, loading, analyzing, visualizing, and storytelling CACIB’s systems raw data in order to help identify existing and emerging risks, provide data analytics for audits and internal projects, as well as automate audit testing to increase the breadth, depth and speed of audit coverage, thus providing higher levels of assurance. The Data Auditor is also expected to document the technical specifications of re-usable queries, extracts, or analysis with source information, key fields, and usage. The Data Auditor performs audit work as needed, where he/she can provide feedback or guidance on how data analysis can improve the audit coverage.

Key Responsibilities

Audit assignments and Continuous Monitoring

·   Identify and acquire the necessary data from relevant source systems used by Internal Auditors 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, document, 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

IGE Continuous Improvement Program / Transversal topics

The Data Auditor 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
·   Maintain and update a data tools inventory (that will contain code, user guides produced during audits)
·   Actively participate in one or several knowledge communities within IGE

The Data Auditor 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). He/she must complete all the mandatory trainings within the deadlines.

Management and Reporting

Direct reporting line to Head of IT/Data/Cybersecurity Audit in the Americas

#LI-DNI

Bachelor’s or Mater’s degree in engineering , statistics or data analytics (e.g. business intelligence)

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

• Analytical skills
• Attention to details, accuracy
• Ability to communicate clearly and easily, including in writing
• Ability to analyze and summarize
• Verbal and written communication skills in English required (You will need to service Anglophone clients and work with Anglophone colleagues)
• Verbal and written communication skills in French considered a strong asset
• Relationship management
• Ability to work across disciplines

• Ability to learn new coding / use of new tools
• Proficiency with data analytics tools (Excel, PowerBI)
• Coding skills (Python is required)