Data Analytics Auditor, Global Wealth & Insurance Audit

Requisition ID : 204869

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Purpose

The Audit Department is the 3rd Line of Defense and plays a key role in the internal control system of the Bank. Its mandate is to provide independent and objective assurance over the design and effectiveness of internal controls to mitigate risks and to provide advisory services designed to improve the Bank's operations.

The incumbent will be working directly with Senior Managers and Directors in Global Wealth and Insurance Audit as well as peers within the Central data analytics team and be responsible for executing analytics required for audits over Asset Management, Wealth Distribution, and Insurance business lines, control / support functions, and other areas as required.

The ideal candidate will have working Wealth Business knowledge, and technical knowledge and experience in analytics and data acquisition, and will have the ability to provide data, execute data analytics, and develop continuous monitoring MIS dashboards.

Accountabilities

Data Analytics

Participate in data analysis engagements, executing for various business audit team.

Collaborate with business lines and other stakeholders to enhance Internal Audit's and the Bank's data analysis practices and adoption.

Working with the team, Identify, acquire and use large volumes of data to provide incremental business value through creation of new models and algorithms that help the Internal Audit group execute Audits more efficiently and allow management to identify emerging risks.

Develop innovative solutions and create products that provide business value and improve customer experience.

Develop and enhance visual dashboards to enable data-based Continuous Monitoring throughout Audit

Work with large datasets and distributed computing tools for analysis, data mining and modeling

Prepare detailed documentation to outline data sources, models and algorithms used and developed, as well as results obtained.

Support and deliver on the Data Analytics innovation initiatives.

Audit Planning :

In consultation with the Business audit team, participate in audit planning to identify analytics need.

Auditing and Execution :

Determine the efficiency, effectiveness, integrity, and reliability of internal controls in relation to defined control requirements by conducting the audit of assigned processes / units / projects.

Execute, manage, and document assigned activities independently in accordance with the department standards, ensuring the nature and extent of testing is sufficient and appropriate to support the audit opinion.

Problem Identification :

Identify and assess materiality of control weaknesses ensuring facts are gathered and their full meaning is understood for moderate to highly complex projects.

Identify underlying causes of control weaknesses and provide practical recommendations as to how they can be mitigated.

Follow-up on assigned issues in the Issue Tracking Database for timely resolution.

Reporting / Communication :

Develop and maintain good relationships with key auditee and business line management.

Education / Experience / Other Information

At least 2 years of Asset Management and Wealth Distribution data-analytics related experience is preferred.

Working knowledge of the operations and regulatory environments of Wealth and Insurance industries in Canada.

Degree in Statistics, Computer Science, or related field preferred.

Experience with statistical tools (R or Python).

Solid SQL skills for querying relational databases (e.g., SQL Server, DB2, MySQL).

Experience extracting and working with structured and unstructured data in a variety of formats residing in a variety of data systems, and data mining.

Experience using the Enterprise Data Lake or Enterprise Data Warehouse preferred.

Working knowledge or experience in Machine Learning techniques (clustering, decision trees, neural networks) and other advanced statistical analysis techniques and concepts is an asset.

Some experience using and implementing visualization tools like Microsoft Power BI or Tableau.

Ability to work on multiple projects at any given time.

Developing interpersonal and communication skills (verbal and written) to work with staff and management at various levels.

Experience in writing and presenting data analytics / MIS results.

Highly motivated self-starter with experience producing high quality data deliverables and able to work independently and in a team environment.