Skip to content
Sr Analyst Technical Testing Oversight
| Company | Royal Bank of Canada |
|---|
| Location | Minneapolis, MN, USA |
|---|
| Salary | $65000 – $115000 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s, Master’s |
|---|
| Experience Level | Senior |
|---|
Requirements
- 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
Responsibilities
- 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
Preferred Qualifications
- 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
