Sr. Ultra High Net Worth Client Reporting Analyst

RBC•Minneapolis, MN

1d•$70,000 - $130,000

About The Position

What is the opportunity? The Reporting Analyst serves as the key subject matter expert and creator of customized performance analysis for UHNW and institutional clients of the Private Client Group at RBC USWM. The Reporting Analyst is responsible for collaborating with financial advisors and developing customized investment performance information, aggregating held away asset data, and compiling reports for the most sophisticated clients at RBC WM. The role is responsible for developing a deep understanding of RBC’s performance reporting application and implementing processes that will support advisors and clients while ensure appropriate supervisory review. This role will have significant interaction with Financial Advisors and may include limited interaction with end clients. What will you do? Build and maintain UHNW & Institutional (non-profit) report templates that are available firm-wide for all FAs and clients Create custom blended benchmarks for UHNW and institutional clients Ensure the accuracy of investment performance data, including RBC portfolio, held away assets and benchmark information Create custom reports for UHNW/I clients Develop a process to aggregate held away accounts/assets via RBC’s performance reporting system and include them in performance calculations. Develop a process to collect and input valuations for hard assets (e.g., yachts, investment properties), and include them in reports for UHNW clients. Respond to requests for this functionality by creating transactions in the performance reporting system and incorporate assets to reports Develop and use a process to collect liability information from UHNW clients for Net Worth Statement reporting purposes Audit underlying performance records for accuracy and reasonableness Respond to performance inquiries; provide performance support Consistent delivery of accurate investment performance information to clients and advisors Clear articulation of primary drivers of investment returns to advisors, through attribution analysis and risk adjusted return metrics Effective working relationship with internal groups and operations to ensure accuracy and compliance with firm policies What do you need to succeed? Must-have Deep understanding of time weighted return calculations and impact of cash flows on performance calculations Ability to reconcile performance calculations Familiarity with Wealth Management and experience in financial services Technological skills – will need to become expert on performance reporting system’s functionality, including both the UI as well as reporting Process-oriented – development and execution of processes, including ongoing data entry and management Solution-oriented & creative problem solver – able to interface with FAs and potentially UHNW/institutional clients to understand what they are trying to achieve, and to build a report that meets the need or suggest alternatives Series 7, 65/66 BA/BS in business, finance, or marketing with 3+ years securities or financial markets experience Understanding of fundamental performance measurement concepts – e.g., time weighted returns, IRR, attribution analysis Detail and process oriented Ability to manage and prioritize multiple tasks Ability to work in a fast-paced and changing professional environment Willingness to aggressively learn new skills in a short period of time Strong analytical skills needed to understand data inputs and outputs, and identify anomalies Excellent verbal, written and presentation skills Experience and comfort collaborating with Financial Advisors and external clients; service orientation Strong customer service orientation Nice-to-have CFA and/or CIPM designation Self-directed and pro-active team player, who works well under minimal supervision Bias for action and execution Adaptable to change Organizational awareness and understanding of the portfolio management process Strategic influencing, negotiating and persuasion skills (ability to assertively express ideas, needs and requests and build group consensus – “sells” ideas) Experience with performance calculation and reporting software What’s in it for you? We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual. A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable Leaders who support your development through coaching and managing opportunities Ability to make a difference and lasting impact Work in a dynamic, collaborative, progressive, and high-performing team Flexible work/life balance options Opportunities to do challenging work Opportunities to take on progressively greater accountabilities Access to a variety of job opportunities across business The expected salary range for this particular position is $70,000-$130,000, depending on your experience, skills, and registration status, market conditions and business needs. You have the potential to earn more through RBC’s discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals. RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that: Drives RBC’s high-performance culture Enables collective achievement of our strategic goals Generates sustainable shareholder returns and above market shareholder value

Requirements

Deep understanding of time weighted return calculations and impact of cash flows on performance calculations
Ability to reconcile performance calculations
Familiarity with Wealth Management and experience in financial services
Technological skills – will need to become expert on performance reporting system’s functionality, including both the UI as well as reporting
Process-oriented – development and execution of processes, including ongoing data entry and management
Solution-oriented & creative problem solver – able to interface with FAs and potentially UHNW/institutional clients to understand what they are trying to achieve, and to build a report that meets the need or suggest alternatives
Series 7, 65/66
BA/BS in business, finance, or marketing with 3+ years securities or financial markets experience
Understanding of fundamental performance measurement concepts – e.g., time weighted returns, IRR, attribution analysis
Detail and process oriented
Ability to manage and prioritize multiple tasks
Ability to work in a fast-paced and changing professional environment
Willingness to aggressively learn new skills in a short period of time
Strong analytical skills needed to understand data inputs and outputs, and identify anomalies
Excellent verbal, written and presentation skills
Experience and comfort collaborating with Financial Advisors and external clients; service orientation
Strong customer service orientation

Nice To Haves

CFA and/or CIPM designation
Self-directed and pro-active team player, who works well under minimal supervision
Bias for action and execution
Adaptable to change
Organizational awareness and understanding of the portfolio management process
Strategic influencing, negotiating and persuasion skills (ability to assertively express ideas, needs and requests and build group consensus – “sells” ideas)
Experience with performance calculation and reporting software

Responsibilities

Build and maintain UHNW & Institutional (non-profit) report templates that are available firm-wide for all FAs and clients
Create custom blended benchmarks for UHNW and institutional clients
Ensure the accuracy of investment performance data, including RBC portfolio, held away assets and benchmark information
Create custom reports for UHNW/I clients
Develop a process to aggregate held away accounts/assets via RBC’s performance reporting system and include them in performance calculations.
Develop a process to collect and input valuations for hard assets (e.g., yachts, investment properties), and include them in reports for UHNW clients.
Respond to requests for this functionality by creating transactions in the performance reporting system and incorporate assets to reports
Develop and use a process to collect liability information from UHNW clients for Net Worth Statement reporting purposes
Audit underlying performance records for accuracy and reasonableness
Respond to performance inquiries; provide performance support
Consistent delivery of accurate investment performance information to clients and advisors
Clear articulation of primary drivers of investment returns to advisors, through attribution analysis and risk adjusted return metrics
Effective working relationship with internal groups and operations to ensure accuracy and compliance with firm policies

Benefits

A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Flexible work/life balance options
Opportunities to do challenging work
Opportunities to take on progressively greater accountabilities
Access to a variety of job opportunities across business

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume