RBC · 4 days ago
Business Analyst / Associate – Municipal Investment Banking & Community Investments
Washington, DC
Full-time
Onsite
Mid, Senior Level
$100K/yr - $135K/yr
4+ years expRBC is seeking a motivated and technically adept Business Analyst (Associate) to join their Municipal Investment Banking & Community Investments team. The role involves designing and implementing a unified data platform for the low-income housing tax credit syndication business and collaborating with various stakeholders to enhance business processes and data management.
BankingFinancial ServicesWealth Management
Responsibilities
Meet with business stakeholders to document workflows, information management practices, and data flows
Identify gaps, inefficiencies, and opportunities for process and data integration
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
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
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
Assist in the production of automated financial models and reports leveraging Python, Excel VBA Macros and/or SQL Excel connections
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
Qualification
Required
4–7 years of experience in business analysis, product management, or program/project management roles within real estate technology or financial services
Experience with affordable housing, LIHTC, or asset management data (a plus, but not required)
Experience with AI systems and tools. Familiarity with commonly used LLMs and APIs. Proficiency with GitHub Copilot and/or Claude Code a plus
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
Familiarity with Python, JavaScript (React, Angular, NodeJS) and HTML/CSS
Proficient with Microsoft productivity applications (Excel, Word & PowerPoint), ideally with experience writing macros in VBA
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
Bachelor's degree in finance, real estate, computer science, information systems, or related field
Preferred
Experience using collaboration tools (JIRA, Confluence, SharePoint, Figma)
Advanced degree or certifications (PMP, CBAP, etc.) a plus but not required
Benefits
Competitive compensation and flexible benefits
401(k) program with company-matching contributions
Health, dental, vision, life, disability insurance
Paid-time off
Company
RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance.
10001+ employees
H1B Sponsorship
RBC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (29)
2024 (17)
2023 (3)
2022 (4)
2021 (1)
2020 (2)
Funding
Current Stage
Public CompanyTotal Funding
$16.3B2025-10-30Post Ipo Debt· $5B
2025-09-15Post Ipo Debt· $1.35B
2025-07-10Post Ipo Debt· $177.74M
Leadership Team
Graeme Hepworth
Chief Risk Officer
Kelly Bradley
Chief Human Resources Officer
Recent News
Private Capital Journal
2026-01-09
Company data provided by crunchbase