Data Analyst (Student)

Advisor Monitoring is a team of data analysts in Market Conduct (part of Corporate Compliance) that perform descriptive analytics looking for insights into advisor behaviour and market conduct risk while performing second line oversight of Advisory Network.

Reporting into the Manager – Advisor Monitoring, the Data Analyst role contributes to the execution of the Advisor Monitoring team by combining advanced analytical skills with strong industry knowledge. The ideal candidate is able to combine these abilities to efficiently and effectively draw conclusions and make recommendations to mitigate risk in Advisory Network. This includes detecting anomalous data patterns, analyzing these patterns using knowledge of Distribution processes and products and projecting the results across the rest of the business to recommend control changes where appropriate.

• Provide valuable data analytics to influence effective change:
  • Combine expert industry knowledge with advanced data analytics skills to enhance predictive capabilities of Advisor Monitoring team while detecting emerging trends.
  • Collaborate with data scientists and other IT partners to continuously enhance the efficiency and effectiveness of the Advisor Monitoring program.
  • This includes tying trends identified during advisor case assessments to population studies to determine the prevalence of trends and recommend next steps.
• Assist with the execution of advisor monitoring program:
  • Analyze large volumes of transactional data to identify key risks with a focus on advisor misconduct. This includes ongoing advisor case assessment work.
  • Apply industry knowledge to assess potential advisor misconduct and resolve findings. This may require contacting advisors and/or customers where appropriate.
  • Conduct root cause analysis of market conduct complaints and use findings to set business requirements and execute upgrades to existing data analytics program.
• Provide effective oversight of Advisory Network:
  • Leverage program findings and understand controls framework and leverage program findings to provide effective challenge for upstream controls.
  • Share analytical best practices with business partners to drive the continuous improvement of business processes across Risk & Compliance.
  • Follow up on referred cases to ensure successful achievement of advisor outcomes.

• Advanced data analytics skills with ability to work effectively in Microsoft Excel, Microsoft Power BI and Tableau Software.
• Creative thinker with the ability to understand the root cause of an issue and use data to establish detective controls for the issue.
• Strong interpersonal skills and a demonstrated experience working effectively in a team environment as well as independently.
• Well-developed planning and organizational skills with the ability to prioritize and handle multiple tasks while meeting tight deadlines.
• Excellent verbal and written communication/documentation skills.
• Strong influencer with the ability to provide effective challenge to legacy processes.
• Advanced knowledge of insurance and wealth products, particularly for Individual Customer.
• Understanding of advisor compensation is an asset.
• Knowledge of internal admin systems an asset (ie. Univeris, legacy systems, OnBase, etc.)
• Post-secondary education in a related field.
• Professional designation or diploma (ie. CPA, CFA, CSC, IFIC) an asset.