Data Analyst

Data Analyst

The Data Service Delivery, Securities Master File (SMF) team, is accountable and responsible for the accurate and timely daily collection, validation and dissemination of market data to support RBC Investor Services’ core products. The combination of our product suite and the downstream impact of our outputs create a unique and challenging function supporting RBC I&TS operational teams. 

As the Data Analyst, you will ensure that all securities are set up and delivered to our various applications in a timely and accurate manner in order to meet our clients’ requirements. You will be responsible for the quality of the production delivery and respect of the deadlines.

Job Description:

• Set up various types of public and private securities (funds, bonds, money markets, etc.)
• Provide a high level of service by responding to all client inquiries within a reasonable timeframe.
• Verify and confirm with vendor sources for any discrepancies in security set up information.
• Establish communication networks with all business units for the receipt of security set up data.
• Ensure that the end of day checking procedure for any same day requests are completed; and existing procedures are followed and kept informed on all policies and compliance issues.
• Review/monitor all set up issues to ensure timely follow up and resolution.
• Act as a team player, participate in the team’s cross training activities, and provide coverage during staff absences.
• Identify issues and problems and escalate immediately.

Daily Responsibilities:

Staff will start the day with checking the generic inbox, ensuring request are completed, any troubleshooting queries are answered appropriately- main priority is keeping the inbox clean. They may also learn some reports depending on the learning curve given the timeline.

What program/technology/software knowledge is essential for this role?

Interactive Data, Bloomberg, Six Financial, CDS, BNY and Cusip Global. We work off MDF

Must Haves:

• University degree preferably in Business/Finance/Accounting
• 2+ year’s financial services experience

Nice to Have:

• Canadian Securities Course designation
• Technical skills such as VBA
• Strong analytical thinking and ability to work effectively and efficiently under pressure.