Business System Analyst- EN
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
RBC seeks a Business System Analyst to bridge business needs and IT solutions, analyzing organizational systems, creating user stories, and recommending technology solutions to improve business processes.
Key Skills for This Role
Responsibilities
- Translate and validate complex business rules with stakeholders, ensuring mutual agreement on definitions, logic, and expected outcomes
- Curate feature specific test data sets that align with distinct business logic, workflows, and use cases to enable comprehensive functional and regression testing
- Design and generate synthetic, anonymized, or masked test data to validate system functionality, reports, and business rules
- Gain understanding of upstream applications and the data provided, interfacing with other app teams and architects as needed to document dataflows
- Implement data masking techniques to protect sensitive information in non production environments
- Design and evaluate system solutions that meet business objectives, including assessing existing systems and recommending improvements or replacements
- Identify inefficiencies in existing systems (e.g., legacy core banking platforms) and recommend improvements
- Value Stream Analysis: Identifying bottlenecks and opportunities for automation or data driven improvements
Requirements
- Bachelor's degree in computer science, Data Science or related field
- 5+ years as a Business Systems Analyst, preferably in financial services
- Familiarity with REST/SOAP APIs to facilitate data exchange between systems
- Advanced proficiency in SQL to extract, transform, and analyze data from relational databases (e.g., Oracle, SQL Server)
- Skills in generating synthetic data, data masking, or subset extraction to support testing
- Proficiency in data visualization tools (e.g., Tableau, Power BI, Lucid chart and Visio)
- Experience with collaboration platforms like Jira, Confluence and Git version control system
- Knowledge of DB2, legacy systems and big data platforms (e.g., Snowflake, Hadoop) are big assets
Full Job Posting
Job Description
- A technical professional who bridges business needs and IT solutions.
- Analyze organizational systems, create user stories, identify inefficiencies, and recommend technology solutions to improve business processes.
- Ideal for technical problem solvers who excel at implementing innovative solutions while maintaining compliance and quality.
- Proficiency in banking systems, data flows, and associated risks is a strong asset.
What will you do?
- Translate and validate complex business rules with stakeholders, ensuring mutual agreement on definitions, logic, and expected outcomes.
- Curate feature specific test data sets that align with distinct business logic, workflows, and use cases to enable comprehensive functional and regression testing across all system modules.
- Design and generate synthetic, anonymized, or masked test data to validate system functionality, reports, and business rules, ensuring test data covers edge cases, compliance scenarios, and performance requirements.
- Gain understanding of upstream applications and the data provided, interfacing with other app teams and architects as needed to document dataflows.
- Implement data masking techniques to protect sensitive information in non production environments.
- Design and evaluate system solutions that meet business objectives, including assessing existing systems and recommending improvements or replacements, while creating system diagrams and technical specifications to guide implementation.
- Identify inefficiencies in existing systems (e.g., legacy core banking platforms) and recommend improvements.
- Value Stream Analysis: Identifying bottlenecks and opportunities for automation or data driven improvements.
What do you need to succeed?
- Bachelor's degree in computer science, Data Science or a related field with 5+ years as a Business Systems Analyst, preferably in financial services.
- API & Integration Knowledge: Familiarity with REST/SOAP APIs to facilitate data exchange between systems (e.g., integrating client data).
- SQL: Advanced proficiency to extract, transform, and analyze data from relational databases (e.g., Oracle, SQL Server). DB2, legacy systems and big data platforms (e.g., Snowflake, Hadoop) are big assets.
- Test Data Management: Skills in generating synthetic data, data masking, or subset extraction to support testing (e.g., using tools or custom scripts).
- Proficiency in data visualization tools (e.g., Tableau, Power BI, Lucid chart and Visio).
- Collaboration platforms like Jira, Confluence and Git version control system.
Job Skills
- Agile Methodology, Business Data Analysis, Business Process Modeling, Commercial Acumen, Communication, Critical Thinking, Decision Making, Group Problem Solving, Interpersonal Relationship Management, Requirements Analysis
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at RBC
Senior Manager, Brand Identity
Toronto, CAN
RBC seeks a Senior Manager, Brand Identity to lead the development and execution of the company's visual identity, ensuring consistent brand messaging across all channels. This creative and strategic role involves archit
Manager, Product Control
Toronto, CAN
RBC is seeking a Manager, Product Control to provide quality support to various banking platforms by performing daily mark-to-market valuation, P&L reporting, and reconciliation. The role requires 2+ years of Product Con
Senior Manager Digital Product Design – Design Systems
Toronto, CAN
RBC is hiring a Senior Manager Digital Product Design to lead the Design System team. You will provide product design direction for a mobile native design system, empower a team, and collaborate with cross-functional par
Senior Manager Digital Product Design – Design Systems
Toronto, CAN
RBC is seeking a Senior Manager to lead the Design System team, providing product design direction and oversight for a mobile native design system at scale. The role involves formulating design hypotheses, aligning with
Senior Manager, Business Information Management and Business Intelligence
Toronto, CAN
RBC is seeking a Senior Manager to lead a team of data and business professionals in providing streamlined reporting and insights across Regional Banking. The role involves overseeing data pipelines, ETL processes, and B
Manager, Product Control
Toronto, CAN
RBC is hiring a Manager, Product Control to support banking platforms by performing daily mark-to-market valuation, P&L reporting, and reconciliation. The role involves liaising with Front Office, Middle Office, and IT t
Manager, Product Control
Toronto, CAN
RBC is seeking a Manager, Product Control to provide quality support to banking platforms by performing daily mark-to-market valuation, P&L reporting, and reconciliation. The role requires 2+ years of product control exp
Senior Manager, Business Information Management and Business Intelligence
Toronto, CAN
RBC seeks a Senior Manager to lead a team of data and BI professionals, overseeing end-to-end data pipeline and reporting solutions for Regional Banking. The role requires expertise in ETL, big data, and team leadership
Senior Manager, Brand Identity
Toronto, CAN
Manager, Product Control
Toronto, CAN
Senior Manager Digital Product Design – Design Systems
Toronto, CAN
Senior Manager Digital Product Design – Design Systems
Toronto, CAN
Senior Manager, Business Information Management and Business Intelligence
Toronto, CAN
Manager, Product Control
Toronto, CAN
Manager, Product Control
Toronto, CAN
Senior Manager, Business Information Management and Business Intelligence
Toronto, CAN