RBC
Business Analyst / Associate – Municipal Investment Banking & Community Investme
RBC, Olympia, Washington, United States
Job Description
Overview 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.
Key Responsibilities
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.
Qualifications
Experience: 4–7 years in business analysis, product management, or program/project management within real estate technology or financial services.
Experience with affordable housing, LIHTC, or asset management data is a plus but not required.
Technical Skills:
Experience with AI systems and tools; familiarity with commonly used LLMs and APIs. Proficiency with GitHub Copilot and/or Claude Code a plus.
Strong 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.
Familiarity with Python, JavaScript (React, Angular, NodeJS) and HTML/CSS.
Proficient with Microsoft Excel, Word & PowerPoint; experience writing macros in VBA.
Experience using collaboration tools (JIRA, Confluence, SharePoint, Figma) preferred.
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 in a fast-paced, build-from-scratch environment and in managing long-term, large-scale projects.
Education
Bachelor’s degree in finance, real estate, computer science, information systems, or related field.
Advanced degree or certifications (PMP, CBAP, etc.) a plus but not required.
Attributes of a Strong Candidate
Comfortable toggling between high-level process mapping and hands-on data analysis.
Driven to build bespoke solutions, not just implement off-the-shelf tools.
Interested in affordable housing, community development, and impact-driven finance.
A team player who wants to contribute to the platform long term, supporting both launch and evolution.
What’s 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 competitive compensation and flexible benefits (401(k) with company matching, health, dental, vision, life, disability insurance, and paid time off).
Leaders who support your development through coaching and managing opportunities.
Opportunity to make a difference and lasting impact.
Dynamic, collaborative, progressive, high-performing team environment.
Opportunities to do challenging work.
Opportunities to build close relationships with clients.
Potential to earn more through RBC’s discretionary variable compensation program, based on business and individual performance.
RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and support attracting, engaging, and retaining talent that drives high performance, enables achievement of strategic goals, and generates sustainable shareholder value.
The expected salary range for this position is $100,000 - $135,000, depending on experience, skills, registration status, market conditions, and business needs.
Additional Job Details
Address:
2100 PENNSYLVANIA AVENUE NORTHWEST, WASHINGTON
City:
Washington
Country:
United States of America
Work hours/week:
40
Employment Type:
Full time
Platform:
CAPITAL MARKETS
Job Type:
Regular
Pay Type:
Salaried
Posted Date:
2025-09-10
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Equal Opportunity & Inclusion Inclusion and Equal Opportunity Employment: At RBC, we believe an inclusive workplace with diverse perspectives is core to our growth as a leading bank. We strive to foster a workplace based on respect, belonging, and opportunity for all.
Join our Talent Community
Stay informed about career opportunities at RBC by signing up for customized info on jobs, career tips, and recruitment events.
Expand your limits and create a new future together at RBC. Learn how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
#J-18808-Ljbffr
Overview 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.
Key Responsibilities
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.
Qualifications
Experience: 4–7 years in business analysis, product management, or program/project management within real estate technology or financial services.
Experience with affordable housing, LIHTC, or asset management data is a plus but not required.
Technical Skills:
Experience with AI systems and tools; familiarity with commonly used LLMs and APIs. Proficiency with GitHub Copilot and/or Claude Code a plus.
Strong 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.
Familiarity with Python, JavaScript (React, Angular, NodeJS) and HTML/CSS.
Proficient with Microsoft Excel, Word & PowerPoint; experience writing macros in VBA.
Experience using collaboration tools (JIRA, Confluence, SharePoint, Figma) preferred.
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 in a fast-paced, build-from-scratch environment and in managing long-term, large-scale projects.
Education
Bachelor’s degree in finance, real estate, computer science, information systems, or related field.
Advanced degree or certifications (PMP, CBAP, etc.) a plus but not required.
Attributes of a Strong Candidate
Comfortable toggling between high-level process mapping and hands-on data analysis.
Driven to build bespoke solutions, not just implement off-the-shelf tools.
Interested in affordable housing, community development, and impact-driven finance.
A team player who wants to contribute to the platform long term, supporting both launch and evolution.
What’s 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 competitive compensation and flexible benefits (401(k) with company matching, health, dental, vision, life, disability insurance, and paid time off).
Leaders who support your development through coaching and managing opportunities.
Opportunity to make a difference and lasting impact.
Dynamic, collaborative, progressive, high-performing team environment.
Opportunities to do challenging work.
Opportunities to build close relationships with clients.
Potential to earn more through RBC’s discretionary variable compensation program, based on business and individual performance.
RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and support attracting, engaging, and retaining talent that drives high performance, enables achievement of strategic goals, and generates sustainable shareholder value.
The expected salary range for this position is $100,000 - $135,000, depending on experience, skills, registration status, market conditions, and business needs.
Additional Job Details
Address:
2100 PENNSYLVANIA AVENUE NORTHWEST, WASHINGTON
City:
Washington
Country:
United States of America
Work hours/week:
40
Employment Type:
Full time
Platform:
CAPITAL MARKETS
Job Type:
Regular
Pay Type:
Salaried
Posted Date:
2025-09-10
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Equal Opportunity & Inclusion Inclusion and Equal Opportunity Employment: At RBC, we believe an inclusive workplace with diverse perspectives is core to our growth as a leading bank. We strive to foster a workplace based on respect, belonging, and opportunity for all.
Join our Talent Community
Stay informed about career opportunities at RBC by signing up for customized info on jobs, career tips, and recruitment events.
Expand your limits and create a new future together at RBC. Learn how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
#J-18808-Ljbffr