Securities Data Analyst - Markit EDM

Securities Data Analyst - Enterprise Data Management EDM

Job Title: Securities Data Analyst - EDM

Company: Direct IT Recruiting Inc.

Location: Toronto, Ontario

Status: 6 Month Contract

Job Category: Business Systems Analyst, Data Analyst

Career Level: Senior

Number of Staff to Supervise: N/A                                                                         

Work Experience: 7+ years as a securities data analyst, CSC, Markit EDM Cadis, PL/SQL, FRM, Agile

Industry: Capital Markets

DESCRIPTION:

Responsible for providing data and process analysis and support for the management of  securities with reference to market data assets. Also responsible for developing components and data solutions using Markit EDM (Cadis) and PL/SQL. To ensure sustainable quality in the repositories and the downstream application, the candidate will work with the Data Management team and business stakeholders to conduct analysis, business and data workflows and write detailed data specifications on current and future systems. The candidate will conduct research and design of data solutions for key corporate projects.

RESPONSIBILITIES

- Write data requirements documents and detailed data specifications
- Design Markit EDM (Cadis) solutions for data and processes to achieve matching, mastering and accuracy of reference and market data for accounting, compliance, performance, risk, portfolio management systems and trading systems
- Provide global securities data and data management expertise to achieve sustainable quality of information needed by the businesses to meet their objectives
- Develop and maintain a network of relationships with the information customers in the areas of trading, risk management, compliance, clearing and settlement to manage ongoing processes, controls, and operational service levels
- Analyze application and user requirements for data, identify data sources to meet requirements, and write data specifications for Information Technology
- Understand vendor data rights and communicate our obligations to our users to ensure we remain compliant with all data vendor contracts
- Work with enterprise data vendor manager to establish agreements for new external vendor content
- Develop and implement data management processes and controls to continually monitor data quality
- Develop competency to use data quality (Oracle Enterprise Data Quality tool) to build business rules tracking and reporting to monitor data quality
- Identify root cause of data problems and specify requirements for Information Technology to Remedy the problem or implement process improvement initiatives
- Work with appropriate business unit leaders to identify opportunities to standardize, streamline and automate incoming data files and flow of data
- Understand the flow and transformations of securities data from suppliers through securities data repositories, and to end user applications for trading, risk, compliance and Back Office
- Create test plans to certify the data quality for data repository upgrades, new data feeds, and application integrations
- Conduct process improvement and reengineering project initiatives for data collection, capture, entry and distribution
- Document policies, procedures and work processes
- Conduct user training
- Build and maintain metadata
- Understand the information technology concepts and ETL processes
- Participate in large system implementations and other projects

REQUIREMENTS

- University degree or equivalent experience (Business/Finance, Financial Mathematics, Computer Science)
- CSC - Canadian Securities Course
- 5 to 8 years applicable progressive business analysis experience supporting projects or large business initiatives
- Strong proficiency in MS Excel, MS Access, MS Word, MS PowerPoint, MS Visio, SQL skills along with solid understanding of database structures
- Solid understanding of securities reference and market data
- Ability to manage change and challenge existing working patterns and processes
- Experience in developing successful and responsive relationships with a wide number of groups
- Ability to communicate effectively with the business and Information Technology
- Utilizes a structured approach to working methods including proven experience in creating and adopting controls and day to day procedures
- Proven written and verbal communication skills
- Excellent organization, planning and time management skills
- Good understanding of project management methodology (Waterfall and Agile) and system development life cycle
- Ability to work independently and in a team environment

TECHNICAL SKILLS

- Experience with building data solutions using the following technologies is required:  PL/SQL, Markit EDM (Cadis), Experience with building data quality solutions with Oracle EDQ (Datanomic) is an asset
- Experience with the following applications is an asset: SimCorp, Findur, Charles River, SunGard Adaptiv, TopQuadrant, SharePoint, IBM Connections, Lotus Notes
- CFA or FRM designation is an asset