QC Reporting Analyst

Job CategoryInformation Technology
Position TypeContract
Application Deadline June 30, 2021
Experience Required3 years
Job Duration6 months
Education RequiredN/A

Our client is looking for a QC Reporting Analyst to work in Toronto.

Role Responsibilities Include (but are not limited to):

• Design, create and implement reports
o Liaise with stakeholder groups to gather reporting requirements
o Determine and build report logic
o Develop and implement daily, weekly, monthly and ad hoc reports into production using Power BI, Excel and SharePoint
• Perform Data Analysis
o Coordinate with KYC/QC analysts to investigate and determine root causes for data exception and process errors
o Perform data analytics on report outputs to deliver insights and recommendations to stakeholders
o Generate business intelligence through visualizations
• Manage report generation
o Centralized point of contact for QC reporting function; provide guidance to reporting stakeholders
o Ensure delivery of report portfolio to stakeholders
o Host weekly/monthly report meetings
• Act as SME for KYC and QC reporting
• Monitor the quality of KYC data and processes
• Ensure data is reported accurately and is accessible for reporting
Must-Have Skills:

• Completion of an applicable university degree and/or relevant professional designation is required
• 2+ years of KYC/AML/QA/QC data management experience in a similar operational role within the financial services industry (Client Onboarding, KYC/AML, Middle/Back Office Operations)
• Experience with Fenergo, or similar, client lifecycle management application
• Basic understanding of data management practices (data profiling, matching, cleansing, mastering, and exception management)
• Experience with data analysis and reference data reconciliation/remediation
• Experience with developing and delivering reporting
Nice-to-Have Skills:

• Power BI experience
o Creating reports and dashboards
o Knowledge of Dax code
• Intermediate Excel skills
o pivot, VLOOKUP, complex functions
o Fuzzy Lookup
o Structure and present data using conditional formatting, tables, charting
o Build macros using VBA
• Working knowledge of Microsoft SharePoint
• Demonstrated experience in analyzing and manipulating data sets
• Intermediate SQL skills
o Advanced joins (nested, merged)
o Pivot, subqueries
o Aggregate and group by functions
• Strong troubleshooting, analysis and problem-solving skills
• Proven ability to collaborate and build strong relationships with colleagues across Capital Markets
• Familiarity with data management tools/technologies such as Dataiku, Datameer, DbVisualizer, Excel Fuzzy Lookup, relational databases, or others, is preferred
• Excellent communication skills – written and verbal
• Ability to maintain strong attention to detail while meeting deadlines
• Strong team player who works collaboratively, demonstrates initiative, is proactive, and client-focused

If interested, send your resume to: