Lead Business Analyst - Data Solutions

What is the opportunity?

This is an experienced business and data analyst role focused on supporting Retail Credit, Climate and Innovation Technology Portfolio of Projects. Projects support and seek to modernize several application and systems primarily in the Enterprise Risk areas and Climate Data Strategy and Innovation Technology (AI applications and Data Strategy)  

Climate Risk and Data Strategy set of initiatives involve strategic sourcing of data from multiple data sources, building a framework for storing this data and making the data available to a data modeling environment from which support multiple business initiatives.

You will handle business analysis aspects of IT delivery for Climate Data Strategy and Risk initiatives with focus on delivering requirements, data and functional specifications documentation, excel prototypes of data processing and providing walkthrough of the detailed business requirements to Dev and QA teams.

What will you do?

• Lead all business and systems analysis activities for the Climate Data project portfolio of work.
• Develop detailed understanding of current state including data feeds required for Climate Risk Data Stores and Climate Data Hub. Data sources can include a range of (PCAF) Asset Classes – Residential Real Estate, Commercial Real Estate, Sovereign Debt, Project Finance, Listed Equity and Corporate Bonds, Business Loans and unlisted Equities.
• Map and provide rules for the transformation of data from multiple sources into standardized data feeds required for the Climate Risk engines.
• Work closely with business users to understand and elicit business requirements and demo system functionality.
• Prepare high level and detailed requirements and functional specifications, and support developers on projects.
• Efficiently perform business analysis tasks including documentation of requirements, data analysis and support UAT testing.
• Work closely with development team, explain the requirements, validate the design assumptions for various business scenarios and testing.
• Support QA/Business team in creation of UAT test cases against business requirements.

What do you need to succeed?

Must Have:

• Experience working on Risk Data projects (Agile methodologies), sourcing, standardization, and aggregation of risk in one of the functional risk areas such as Counterparty/Credit Risk. Skills acquired in a market and/or counterparty risk management environment are transferable.
• 10+ years previous work experience as a Business or Data Analyst, or in a technical/functional Role in software development.
• Superior experience in the use of Python, Pyspark, SQL technologies to perform complex data analysis and support developers working with a technology stack including Linux, Hadoop, Hive, Spark.
• Expert proficiency in producing and using data catalogues, data modeling and business process modeling.
• Communication and documentation skills – ability to succinctly write requirements, summarize data analysis and present to business users and development team. Experience building enterprise scale applications involving large data volumes and computations.
• Bachelor’s degree in Engineering, Sciences, Information Technology, Computer Science or other quantitative discipline.

 Nice to Have:

• Good understanding of Climate Data Initiatives, Environmental, Social and Governance investment policies & frameworks for financial institutions.
• Understanding of financial Instruments including several types of Fixed Income and Equity Instruments and their valuation; Exposure to Banking Loan Book and other products.

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.

• Opportunities to build distributed systems using the latest big data frameworks for advanced analytics
• 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 take on progressively greater accountabilities    

#LI-POST

Job Skills

Agile Methodology, Agile Methodology, Apache Hadoop, Big Data, Business Analysis, Business Appraisals, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Credit Risks, Critical Thinking, Data Analysis, Data Modeling, Data Solutions, Data Strategies, Functional Specifications, Group Problem Solving, Interpersonal Relationship Management, PySpark, Python (Programming Language), Requirements Analysis, Resource Management, Structured Query Language (SQL), Team Management {+ 1 more}

Additional Job Details

120 WESTERN PKY:BEDFORDBedfordCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2025-07-092025-09-30

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.