Report Solution Analyst/Specialist at MUFG Investor Services | CA | Rezi

Report Solution Analyst/Specialist at MUFG Investor Services

Report Solution Analyst/Specialist

MUFG Investor Services · CA

3 weeks ago

Report Solution Analyst/Specialist

MUFG Investor Services · CA

23 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Design, develop, maintain, and support SQL Server Reporting Services (SSRS) reporting solutions to provide accurate, timely, and actionable business information. Translate business requirements into scalable reports, ensure data integrity, improve reporting efficiency, and enable informed business decisions through reliable reporting and analytics.

Responsibilities

  • Maintain and quality-control global reference database for various financial products including exchange traded, broker-dealer platform, and OTC derivatives.
  • Ensure accurate and timely pricing and evaluation, perform price validation, and interact with market data vendors (Bloomberg, ICE, Markit, Refinitiv, etc.) such as price challenges.
  • Responsible for set-up, maintenance and monitoring of automated processes such as trade capture, investment pricing, and OTC derivatives evaluation.
  • Design, develop and maintain reports (RSL/RDL) and dashboards using SQL Server Reporting Services (SSRS).
  • Create and optimize SQL queries, stored procedures, functions, views and datasets.
  • Gather business requirements and translate into reporting solutions.
  • Work with cross-functional teams to deliver reporting solutions.
  • Troubleshoot report performance and data issues, support report deployment, testing and ongoing enhancements.

Requirements

  • 2 years’ of hands-on experience developing and supporting SSRS reports in a production environment or in a similar position.
  • Bachelor’s degree is a minimum.
  • Experience is financial services industry, or related area is an asset.
  • Strong experience with SQL Server Reporting Services (SSRS).
  • Proven experience writing complex SQL queries, stored procedures, views, functions and performance optimization.
  • Experience with Bloomberg, Refinitiv, ICE, IHS Markit, and/or other market data vendors.
  • Working knowledge with VBA, Python or other scripting languages.
  • Experience gathering and translating business requirements into reporting and analytical solutions.
  • Experience with report deployment, scheduling, subscriptions, report maintenance and automated delivery.
  • Working knowledge with Advent Geneva.

Skills

  • SQL Server Reporting Services (SSRS)
  • SQL
  • VBA
  • Python
  • Advent Geneva
  • Bloomberg
  • Refinitiv
  • ICE
  • IHS Markit

Work Type

  • Permanent Full Time

Experience Level

  • Senior Associate

Education Level

  • Bachelor's degree
  • Master's in finance, Economics, Business Analytics, Mathematics, Computational Finance, Financial Engineering, or other quantitative fields preferred
  • CFA, FRM or enrolment in such professional programs is strongly desired

Salary/Compensations

  • CAD 69998 - CAD 102663 - yearly

About the Company

  • MUFG Investor Services is a trusted partner to many of the world’s largest public and private funds, providing asset servicing and operational solutions built for alternatives.
  • With over $1 trillion in client assets under administration, we offer fund administration, banking, payments, fund financing, foreign exchange overlay, corporate and regulatory services, custody, business consulting, and more.
  • Operating from 17 locations worldwide, we help clients mitigate risk, enhance efficiency, and navigate the operational complexities of today’s investment management landscape.
  • As a division of Mitsubishi UFJ Financial Group (MUFG), one of the world’s largest financial institutions with approximately $3 trillion in assets, we combine deep expertise with the strength and stability of a leading financial institution.
  • To learn more, visit us at www.mufg-investorservices.com.