Business Analyst / Associate – Municipal Investment Banking & Community Investments

Royal Bank of Canada•Boston, WA

29d•$100,000 - $135,000

About The Position

We are seeking a motivated and technically adept Business Analyst (Associate) to join our Municipal Investment Banking & Community Investments team. This role will be central to designing and implementing a unified data platform that will consolidate disparate systems currently used across our low-income housing tax credit (LIHTC) syndication business (RBC Community Investments) along with building and enhancing systems that serve the Municipal Investment Banking business. The candidate will work closely with senior leadership, internal developers, and third-party vendors to map business processes, analyze and clean complex data sets, write business requirements, and support the design and launch of proprietary systems that will serve as the backbone of our Municipal Investment Banking and Community Investments businesses. These new systems are being designed with a heavy emphasis on AI and agentic workflows, so this candidate will have the opportunity to work with many cutting-edge AI technologies. This is a unique opportunity to join a mission-driven group within an investment bank that finances the creation of public infrastructure and affordable housing while developing innovative technology solutions from the ground up.

Requirements

Experience: 4–7 years of experience in business analysis, product management, or program/project management roles within real estate technology or financial services.
Technical Skills: Experience with AI systems and tools. Familiarity with commonly used LLMs and APIs. Strong proficiency in SQL; ability to analyze large, complex datasets. Familiarity with data modeling, ETL processes, and database design concepts. Understanding of software development lifecycles and agile methodologies.
Business Skills: Excellent requirements gathering, documentation, and stakeholder management skills. Strong written and verbal communication, able to translate technical topics for non-technical stakeholders. Experience working directly with application developers. Comfort working in a fast-paced, build-from-scratch environment. Comfort managing long-term, large-scale projects.
Education: Bachelor's degree in finance, real estate, computer science, information systems, or related field.

Nice To Haves

Experience with affordable housing, LIHTC, or asset management data (a plus, but not required).
Proficiency with GitHub Copilot and/or Claude Code a plus.
Familiarity with Python, JavaScript (React, Angular, NodeJS) and HTML/CSS.
Experience using collaboration tools (JIRA, Confluence, SharePoint, Figma) preferred.
Advanced degree or certifications (PMP, CBAP, etc.) a plus but not required.
Comfortable toggling between high-level process mapping and hands-on data analysis.
Energized by building bespoke solutions, not just implementing off-the-shelf tools.
Excited about affordable housing, community development, and impact-driven finance.
A team player who wants to stick with the platform long term, supporting both its initial launch and its ongoing evolution.

Responsibilities

Business Process Mapping: Meet with business stakeholders to document workflows, information management practices, and data flows. Identify gaps, inefficiencies, and opportunities for process and data integration.
Data Analysis & Management: Work with large, complex SQL-based datasets to understand structure and relationships. Collaborate with business users to reconcile data definitions with real-world use cases. Clean, map, and organize data for migration into a unified system.
Requirements Gathering & Documentation: Translate business needs into clear, detailed business requirements and functional specifications. Partner with banking technology team members and application developers (in-house and contractors) to assist in managing development efforts.
Technology Development & Implementation: Support design, build, testing, and rollout of the new data platform. Coordinate UAT, training, and adoption across business users. Provide ongoing support and manage iterative enhancements post-launch.
Ad-Hoc Model & Report Development: Assist in the production of automated financial models and reports leveraging Python, Excel VBA Macros and/or SQL <–> Excel connections.
Cross-Functional Collaboration: Serve as a liaison between Community Investments business stakeholders, senior management and technology teams. Ensure alignment across diverse stakeholders on project goals, priorities, and timelines.

Benefits

A comprehensive Total Rewards Program include competitive compensation and flexible benefits, such as 401(k) program with company-matching contributions, health, dental, vision, life, disability insurance, and paid-time off.
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.
Opportunities to do challenging work.
Opportunities to build close relationships with clients.
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.

Stand Out From the Crowd

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

Upload and Match Resume