Job description
Business type
Types of Jobs - General Inspection / Audit
Job title
Data Auditor - Associate
Contract type
Permanent Contract
Management position
Job summary
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 analyticsPrepare different committee presentations, summarizing the findings from the continuous monitoring performedActively participate in global initiatives aimed at improving Internal Audit’s processes and proceduresMaintain and update a data tools inventory (that will contain code, user guides produced during audits)Actively participate in one or several knowledge communities within IGEThe 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.
Supplementary Information
Management and Reporting
Direct reporting line to Head of IT / Data / Cybersecurity Audit in the Americas
Position location
Geographical area
America, Canada
City
Montreal
Candidate criteria
Minimal education level
Bachelor Degree / BSc Degree or equivalent
Academic qualification / Speciality
Bachelor’s or Mater’s degree in engineering , statistics or data analytics (e.g. business intelligence)
Experience
At least 2 years of experience in data analytics (internal / external)At least 2 years of experience in audit (internal / external)Required skills
Analytical skillsAttention to details, accuracyAbility to communicate clearly and easily, including in writingAbility to analyze and summarizeVerbal 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 assetRelationship managementAbility to work across disciplinesTechnical skills required
Ability to learn new coding / use of new toolsProficiency with data analytics tools (Excel, PowerBI)Coding skills (Python is required)Languages
English, French