What is the Opportunity?

In this role, you will design, develop, and implement small applications and business tools to streamline processes, improve efficiency, and enhance productivity across various teams. Your primary focus will be on building solutions that enable teams to work smarter, not harder, by leveraging technology to automate manual tasks, visualize large datasets and simplify complex workflows.

What will you do?

• Collaborate with compliance partners and stakeholders to design, develop, and implement small business solutions that streamline processes, improve efficiency, and reduce risk.
• Oversee the collection, cleansing, and integration of banking data from multiple sources, including databases, spreadsheets, and external data providers, to ensure accuracy, consistency, and compliance with regulatory requirements.
• Assist in developing and enhancing processes and standards related to the usage of data and technology for compliance purposes, including data governance, data quality, and data security.

• Identify and support the execution of opportunities to automate compliance processes using advanced tools and technologies, such as:
• Python for data analysis, machine learning, and automation
• Power Automate for workflow automation and integration
• Access for database development and management
• SQL for data modeling and querying
• PowerApps for custom business app development
• SharePoint for collaboration and content management
• Azure services for cloud-based data storage, processing, and analytics

• Lead the development of in-house business tools and applications to support compliance workflow management, data analysis, and reporting requirements, using platforms such as:
• VBA for Excel automation and integration
• Power Apps for custom business app development

• Influence and promote innovation within Compliance Testing, Compliance Monitoring, Risk Assessments, and Reporting teams by implementing new approaches and methodologies
• Provide guidance and mentorship to junior colleagues, fostering a culture of continuous learning within the compliance team, and promoting the adoption of best practices in data analysis, automation, and compliance management.
• Collaborate with cross-functional teams, including IT, risk management, and audit, to identify and prioritize compliance needs, develop effective controls and monitoring mechanisms, and implement process improvements.

What do you need to succeed?

Must-have:

• Demonstrated ability to work independently as a self-starter, proactively identifying opportunities and solutions in a data-driven environment. 
• Must be comfortable navigating ambiguity, leveraging creativity, and employing unconventional approaches to solve complex problems.
• Strong aptitude for conducting data analysis, data mining, and writing SQL queries in environments with limited documentation or subject matter expert (SME) support.
• Strong track record of working in platforms such as SQL, Python, Power BI, Excel, Power Apps, Power Automate, Azure, Tableau and Archer, with an excellent understanding of data ETL and visualization techniques.
• Proven experience in implementing compliance solutions and frameworks, including automation and optimization of compliance processes.
• Strong leadership and strategic planning skills, with the ability to drive compliance initiatives, influence stakeholders, and foster innovation within the compliance function.
• Excellent communication and interpersonal skills, with the ability to convey complex technical concepts to non-technical stakeholders and senior management.
• Strong problem-solving and decision-making abilities, with a proactive and results-oriented approach to compliance management.
• Strong organizational and project management skills, with discipline in managing priorities and meeting deadlines.

Nice to Have:

• Knowledge of banking regulations and experience with regulatory examinations and audits.
• Substantial experience in banking compliance, risk management, regulatory affairs, or a related field, with a focus on data analysis and regulatory compliance.
• Experience in process improvement and implementing effective controls and monitoring mechanisms.
• Knowledge of in-house business tool development using platforms such as VBA, Power Apps, and Visual Studio.
• Familiarity with quality assurance processes for data analysis and automation, including testing, validation, and verification.
• Experience with cloud-based services, such as AWS or Google Cloud, and containerization technologies.
• Proficiency in Archer or similar GRC (Governance, Risk, and Compliance) platforms, with experience in configuration, customization, and administration is a plus.

For New Jersey/LA: The good-faith expected salary range for the above position is $110,000 - $190,000 depending on factors including but not limited to the candidate’s 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.

For Minneapolis & Newark, DE: The good-faith expected salary range for the above position is $85,000 - $150,000 depending on factors including but not limited to the candidate’s 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.

Job Skills

Analysis and Reporting (Inactive), Analysis and Reporting (Inactive), Analytical Thinking, Automation Technology, Big Data Analytics, Business, Compliance Analysis, Compliance Management Systems, Compliance Monitoring, Compliance Strategies, Compliance Testing, Critical Thinking, Data Administration, Data Analysis, Data Compilation, Data Management, Data Mining, Data Modeling, Data Quality, Datasets, Detail-Oriented, Documentation Reporting, Documentations, Group Problem Solving, Innovation {+ 13 more}

Additional Job Details

CNB, 350 SOUTH GRAND AVENUE:LOS ANGELESLos AngelesUnited States of America40Full timeCHIEF LEGAL & ADMIN OFFICE GRPRegularSalaried2025-10-272026-01-09

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.

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.