Analyst, Public Finance DCM Technology Strategist

RBC • New York, NY

2d • $100,000 - $120,000

About The Position

What is the Opportunity? We are seeking a motivated and technically adept Quantitative Financial Analyst to join our Municipal Investment Banking DCM team. This role will be central to designing and implementing a unified Business Opportunity Identification and External Client Portal platform that will enhance the visibility of RBC as a technology leader in the Municipal Finance industry as well as drive revenue through deal identification. The candidate will work closely with senior leadership, internal developers, banking partners and municipal issuer clients to create and implement a market leading proprietary Municipal Finance quantitative platform working with complex data sets to create significant efficiencies in the identification of opportunities for the business. The 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 blends technology with client interaction to drive revenue producing results. What will you do? Use quantitative finance skills to translate complex business models into immersive AI assisted Municipal Finance technology platform. Work with large, complex SQL-based datasets to understand structure and relationships. Assist in the production of automated financial models and reports leveraging Python, Excel VBA Macros and/or SQL <–> Excel connections Meet with business stakeholders to document workflows, information management practices, and data flows. Translate business needs into clear, detailed business requirements and functional specifications. Identify gaps, inefficiencies, and opportunities for process and data integration. Collaborate with developers to deploy models and business requirements in and efficient and methodical pace. 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. Serve as a liaison between business stakeholders, senior management and technology teams. What do you need to succeed? 1-3 years of experience in quantitative finance, technology development or financial services. (Municipal Finance experience a plus) 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 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. 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 working in a fast-paced, build-from-scratch environment. Comfort managing long-term, large-scale projects. Education Bachelor's degree in quantitative finance, finance, real estate, computer science, information systems, or related field. Attributes of a Strong Candidate 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. 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 bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable 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 building close relationships with clients The good-faith expected salary range for the above position is $100,000 - $120,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. RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that: · Drives RBC’s high performance culture · Enables collective achievement of our strategic goals · Generates sustainable shareholder returns and above market shareholder value

Requirements

• 1-3 years of experience in quantitative finance, technology development or financial services.
• 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.
• 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 quantitative finance, finance, real estate, computer science, information systems, or related field.

Nice To Haves

• Municipal Finance experience a plus
• Proficiency with GitHub Copilot and/or Claude Code a plus.
• Experience using collaboration tools (JIRA, Confluence, SharePoint, Figma) preferred.
• 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

• Use quantitative finance skills to translate complex business models into immersive AI assisted Municipal Finance technology platform.
• Work with large, complex SQL-based datasets to understand structure and relationships.
• Assist in the production of automated financial models and reports leveraging Python, Excel VBA Macros and/or SQL <–> Excel connections
• Meet with business stakeholders to document workflows, information management practices, and data flows.
• Translate business needs into clear, detailed business requirements and functional specifications.
• Identify gaps, inefficiencies, and opportunities for process and data integration.
• Collaborate with developers to deploy models and business requirements in and efficient and methodical pace.
• 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.
• Serve as a liaison between business stakeholders, senior management and technology teams.

Benefits

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
• 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 building close relationships with clients

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 5,001-10,000 employees