Report Solution AnalystSpecialist
Job Summary
The purpose of this role is to design develop maintain and support SQL Server Reporting Services (SSRS) reporting solutions that provide accurate timely and actionable business information. The role is responsible for translating business requirements into scalable reports ensuring data integrity improving reporting efficiency and enabling stakeholders to make informed business decisions through reliable reporting and analytics.
Role and 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
Qualifications :
- 2 years of hands-on experience developing and supporting SSRS reports in a production environment or in a similar position
- Bachelors degree is a minimum
- Masters 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
- Experience is financial services industry or related area is an asset
Essential:
Strong experience with SQL Server Reporting Services (SSRS)
Proven experience writing complex SQL queries stored procedures views functions and performance optimization
Preferred:
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
Additional Information :
Whats in it for you to join MUFG Investor Services
Take a look at our careers site and youll find everything youd expect from a career with the fastest-growing business at one of the worlds largest financial groups. Now take another look. Because its how we defy expectations that really defines us. Youll feel that difference in all kinds of ways. Our vibrant CULTURE. Connected team. Love of innovation laser client focus and next-level LEARNING & DEVELOPMENT. Oh and we really walk the talk when it comes to HYBRID WORKING. So why settle for the ordinary Apply now for a Brilliantly Different career. We thank all candidates for applying; however only those proceeding to the interview stage will be contacted.
This is a newly created position.
Remote Work :
No
Employment Type :
Full-time
About Company
Were more than just fund administration. Our offerings include a scope of solutions not historically provided by asset servicing companies. From fund financing to subscription lines of credit, securities lending, foreign exchange (FX) services, consulting services and beyond, we help ... View more