Contract Length: until Oct 31st (potential extension)
Location: Toronto, WFH
Story Behind the Need:
Business Group: Seeking a Data Analyst for a new regulatory regime called that requires remediation of clients as part of the Dodd Frank Requirement. This resource will be responsible for data analysis including scope determination, reporting and remediation support.
The Project is currently in the initial planning phase and the completion of the overall project is anticipated to be Jan 2022
Typical Day in the Role:
-Provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions
Must Have Skills:
1) Data Analyst (data reporting/fulfilling business analyst related responsibilities, analyzing large amounts of data) – 2+ years of professional experience
2) Microsoft Office suite: Outlook, Access, SharePoint(integrating with Access or Database), PowerPoint, Excel (Advanced)
• Excel functions: VBA/Macros, Powerquery, Fuzzy Match, Pivot tables (advanced), Joining tables, Advanced formulas – 3+ years of hands on experience
3) Tableau or PowerBI reporting (data analytics & visualization) – 2+ years of hands on experience
4) Experience in reporting KPIs and reconciling large data sets – 2+ years of hands on experience
5) Experience creating dashboards and executive-level reports – 2+ years of hands on experience
Nice to Have Skills:
– Experience working at a global financial institution or asset manager a plus
– BA background helpful
– Familiarity with KYC/AML/Trade Reporting regulations nice to have
– Data Science background
– Experience managing a small-mid size database and/or managing the scope of a remediation project (i.e., database management and scope control)
– Experience with SQL
– Experience working with and reconciling Capital Markets or Institutional client transactional data
Soft Skills:
– Strong communication skills – written & verbal (explain/translate the data/analysis and communicate it to the teams & stakeholders in business terms)
– Positive attitude
– Team player
– Open to learning
Education:
– Bachelor’s Degree