Securities Data Analyst (12-months contract)
What is the opportunity?
As a Senior Analyst, you will be responsible for ensuring the accuracy and completeness of the data in Securities Data Repository by leveraging advanced analytics techniques, and for providing insight into data through reporting and analytics.
***This is a 12-month fixed term contract opportunity***
What will you do?
- Support complex data query requests to provide insight into the coverage and nature of reference data
- Be responsible for large scale multi-way comparisons of Securities data against various internal and external sources to identify trends and to measure overall data quality
- Overseeing the integrity and maintenance of organizational data.
- Reviewing and recommending policies and procedures for collecting and managing organization data.
- Develop and implement reporting and data visualization dashboards to articulate trends and data quality measurements
- Develop monitoring to proactively identify data quality gaps
- Support the root cause analysis of data issues relating to security data, and perform complex remediation requiring advanced pattern recognition and machine learning
- Identify and coordinate system and process enhancements and improvements
What you need to succeed?
Must Have
- Completion of an applicable university degree and/or relevant professional designation.
- A minimum of two years of experience in Python, R and or other programming languages.
Advanced Excel Skills:
- Analyze large data sets using pivot tables and pivot reporting
- Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit
- Build macros using VBA (Visual Basic for Applications)
- Ability to structure and present data for reporting using conditional formatting, tables and charting
Intermediate SQL skills
- Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions
- Understanding and usage of update and insertion statements and syntax for altering and creating structures
- Can generate complex data reports using GROUP BY and aggregate functions
- Understands SQL concepts of foreign keys, transactions, triggers, and stored procedures
- Excellent communication skills – written and oral
- Strong troubleshooting and problem solving skills
What’s in it for you?
We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.
- A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation
- Leaders who support your development through coaching and managing opportunities
- Work in a dynamic, collaborative, progressive, and high-performing team
- Opportunities to do challenging work
- Flexible work/life balance options
Job Skills
Analytical Thinking, Business Intelligence Tools, Communication, Decision Making, Financial Products, GoldenSource, Group Problem Solving, Microsoft Access, Microsoft Excel, Relationship Building, University Education