Senior Data Analyst - Capital Markets

Senior Data Analyst - Capital Markets

Job Title: Senior Data Analyst - Capital Markets

Company: Direct IT Recruiting Inc.

Location: Toronto, Ontario

Status: 12 Month Contract

Job Category: Data Analysis

Career Level: Senior

Work Experience: 5+ years as a Data Analyst, legal compliance, PL/SQL Scripting, capital markets

Industry: Financial

DESCRIPTION:

Seeking a Senior Data Analyst to work on a Legal Compliance program.

- Delivery of detailed data requirements documentation and sourcing data elements to support required data for a Compliance system and other projects.
- Providing data analysis effort estimates
- Delivery of detailed data requirements for new or changed data models where required, transformations logic for information technology to build new data models or implement data processing improvement initiatives.
- Writing detailed PL/SQL scripts for sourcing data and preparing test cases.
- Providing global securities data expertise and data management leadership to achieve sustainable quality of information needed by the businesses to meet their objectives.
- Developing and maintaining a network of relationships with information technology, data management and the data management project team to manage ongoing processes, controls, and operational service levels.
- Working with appropriate business unit leaders to identify opportunities to standardize, streamline and automate incoming data files and flow of data.
- Understanding vendor data rights and ++communicates our obligations to our users to ensure we remain compliant with all data vendor contracts.
- Developing and implementing data management processes and controls to continually monitor data quality.
- Creating unit tests, integration test, and UAT test plans to certify the data quality for data repository upgrades, new data feeds, and application integrations.
- Documenting policies, procedures and work processes.
- Reviewing Application Design document to assess enterprise data required for metadata registration
- Building and maintaining metadata.
- Understanding the information technology concepts and ETL processes.
- Provide status in weekly project status meeting and/or daily buzz
- Assess inter-project risks and dependencies
- Other duties as may be required.

SENIOR DATA ANALYST CONSULTANT WOULD ALSO PROVIDE:

- Oversight of a team of DM analysts including data analysis activities and deliverables
- Provide data analysis staffing and effort estimates for work stream
- Support UAT
- Delivery of Detailed Data Requirements/Specifications for work stream
- Provide metrics for weekly status reporting
- Monitor requirements in terms of quality, completeness and accuracy for a work stream
- Monitor adherence to review and approval process
- Provide status in daily buzz (daily status reporting)
- Provide status, issues and risk by participating in Operating Committee

SKILLS:

- 5+ years of experience in Capital Markets
- Advanced knowledge in PL/SQL or WIN SQL
- University degree or equivalent experience (Business/Finance, BA, BSc, Financial Mathematics, Accounting or Computer Science)
- Broad knowledge of Finance in general
- Experience in working with cross functional groups.
- Experience with the full project life cycle from conception to implementation and support
- Excellent communication skills
- Candidate must be able to work independently and as part of a team with minimal supervision
- Compliance background
- Advanced designations such as CFA, FRM, MBA, Masters Finance
- Experience with Portfolio Accounting Systems, Bloomberg, FAME, FactSet or other financial systems an asset
- Other designations that may be an asset:
- Certified Business Analyst CBAP
- Certified Data Management Certificate
- Derivatives Fundamental Course
- Canadian Securities Course CSC
- Understanding of data legal agreements