Compliance Enablement Support Analyst

Royal Bank of Canada•Los Angeles, CA

10d•$110,000 - $190,000

About The Position

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.

Requirements

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 Haves

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.

Responsibilities

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.