Sr Analyst Technical Testing Oversight

What is the opportunity

The Regulatory Risk Technical Solutions Testing department is seeking a dynamic and experienced analyst to help provide technical and analytical support towards US Wealth Management Operations and its broader Operations Risk department. In this role data analysis and SQL development skills will be needed to support risk and audit related initiatives. In addition business and systems analysis skills to evaluate test consult and document artifacts associated to the yearly End User Developed Applications (EUDA) testing.

What will you do

• Offers technical assistance to the broader Risk department during the audit season with population requests key report testing and system knowledge of the RBC systems.
• Performs data mining activities when needed for Internal and External Risk and Regulatory teams
• Conducts yearly testing activities to ensure supported End-User Developed Applications (ie Microsoft Access Excel VBA SQL Server Management Studio) are following Enterprise standards and provides guidance to strengthen design.
• Performs deep data analysis to identify trends and patterns in the data and root cause analysis to assist in the resolution of data issues
• Understands regulatory and firm risks associated with business processes how work is processed from beginning to end and dependencies to other areas and department(s)
• Contributes to the process re-engineering and process improvement where applicable when testing EUDAs and consults with other technical operation teams on design standardization and best practices
• Collaborates with business partners to elicit analyze and document requirements and develop process flow diagrams as needed to facilitate data analysis activities

What do you need to succeed

Must-have

• Relevant college university or post-graduate degree in Computer Science or Business Analysis
• 5 years work experience in an analytical function (i.e. Business Systems Analyst Technical Analyst) in a regulated industry
• Excellent communication - strong verbal written and presentation skills
• Intermediate to Advanced level SQL development skills to extract data and perform various types of functions/operations to gain insight
• Proficient in development tools: SQL Server Management Studio 17 and above Microsoft Access Microsoft Excel VBA functions; experience in .NET developer platform

Nice-to-have

• Series 7 or 99 or ability to obtain in 120 days
• Experience with complex large-scale relational databases with an aptitude to analyze and resolve complex data related issues.
• Attention to detail and ability to work independently and within a team
• medium to large size systems implementations system integrations and/or systems re-engineering projects

Whats 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 good-faith expected salary range for the above position is $65000 -$115000 depending on factors including but not limited to the candidates experience skills registration status; market conditions; and business needs. This salary range does not include other elements of total compensation including a discretionary bonus and benefits such as a 401(k) program with company-matching contributions; health dental vision life and disability insurance; and paid time-off plan. RBCs 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 RBCs high performance culture
• Enables collective achievement of our strategic goals
• Generates sustainable shareholder returns and above market shareholder value

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best effectively collaborate drive innovation and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect belonging and opportunity for all.