Business Systems Analyst
About the role
Pay Range: CAD 50-55/hr POSITION OVERVIEW Royal Bank of Canada is seeking an experienced Business Systems Analyst (BSA) to support a critical regulatory compliance initiative focused on automating NYS employment tax compliance processes. Requiring deep expertise in SAP payroll systems, tax compliance, and multi-system integrations.
BUSINESS CONTEXT RBC recently settled a NYS employment tax audit related to under-withholding and underreporting of wages for business travelers and trailing compensation. This project will automate compliance processes to prevent future audit exposure and ensure accurate tax withholding across multiple data sources and systems. KEY RESPONSIBILITIES (as listed below but not limited to)
Requirements Elicitation & Documentation • Conduct detailed interviews with Payroll, Global Mobility, Concur, EY, Finance, and other stakeholders to gather functional and technical requirements • Document current-state processes and identify gaps related to: o NYS wage withholding for nonresidents and travelers o Trailing compensation tax withholding during vesting periods o Relocation tracking and management o Remote work location capture • Create detailed requirements specifications for system integrations and process automation • Validate requirements across multiple stakeholder groups for alignment and completeness SAP Payroll & Tax Expertise • Analyze SAP US Payroll module configuration for NYS tax withholding calculations • Identify configuration gaps and recommend enhancements to support automated withholding • Understand wage types, vesting periods, and tax sourcing logic within SAP • Collaborate with Solution Architect on SAP update process automation design • Validate compensation data mapping and transformation rules Multi-System Integration Requirements • Define requirements for Concur → SAP data integration (travel and expense data) • Define requirements for TI (Tech Infrastructure) → EYMP BT (Ernst & Young Mobility Program Business Travel) tool data integration (travel and expense data) • Document compensation data flow: RBC Payroll → SFTP → EY Tool → SAP • Specify badge swipe location data integration points and validation logic • Identify data quality requirements and reconciliation procedures across systems • Define SLAs and turn-around times for data processing (especially critical for yearend close) NY State Tax Compliance • Understand NYS employment tax requirements and audit findings • Translate regulatory requirements into system/process requirements • Work with Payroll to clarify: o Workday definition (actual work vs. travel booking days) o Trailing compensation sourcing and withholding rules o Non-resident wage allocation and reporting o Relocation impact on tax withholding • Ensure requirements documentation is audit-defensible Location & Travel Data Requirements • Define requirements for capturing actual NYS workdays (vs. travel bookings) • Specify badge swipe data integration: data elements, frequency, validation rules • Assess feasibility of alternative data sources (Transit data, IP tracking, mobile location) • Document employee validation and reconciliation workflows • Define how remote work locations are captured and tracked for tax purposes Compensation Integration with EY Tool • Document detailed compensation data requirements for EY platform transmission: o Total wages, individual trailing compensation, MTI, bonus information o Data frequency (monthly + ad-hoc/o-cycle) o Return data specifications from EY • Define SFTP transmission specifications and schedules • Specify data validation and reconciliation rules between RBC and EY • Document turn-around time requirements for year-end close processing • Identify data governance and security requirements Stakeholder Coordination • Serve as primary point of contact between IT and business stakeholders (Payroll, Global Mobility) • Facilitate working sessions and requirements validation meetings • Escalate blockers and ambiguities to Sr. Project Manager and Solution Architect • Provide regular status updates on requirements clarity and feasibility assessment REQUIRED QUALIFICATIONS • 5+ years as Business Systems Analyst in financial services or similar regulated environment • Strong expertise in SAP US Payroll module (BSI Tax Factory) – configuration, data structures, withholding calculations • Experience with tax compliance systems and processes (preferably including state/local tax) • Understanding of payroll withholding concepts (wage allocation, sourcing, multistate compliance) • Experience documenting and validating system integration requirements • Excellent stakeholder management and communication skills • Ability to translate regulatory requirements into technical specifications • Strong analytical and problem-solving skills PREFERRED QUALIFICATIONS • NY State employment tax compliance experience (highly valued) • Experience with Concur Travel & Expense system • Familiarity with badge/location tracking systems or data sources • Experience with EY tools or third-party tax/compliance platforms • Knowledge of compensation integration workflows or deferred compensation systems • Prior experience on regulatory compliance or audit remediation projects KEY COMPETENCIES Competency Importance SAP Payroll Expertise -Critical Requirements Analysis -Critical Tax/Regulatory Knowledge -Critical
Competency Importance Multi-System Integration -Thinking High Stakeholder Management -High Documentation & Process Mapping -High Problem-Solving- High Communication (Verbal & Written)- High
Similar Jobs
Business Systems Analyst
About the role
Pay Range: CAD 50-55/hr POSITION OVERVIEW Royal Bank of Canada is seeking an experienced Business Systems Analyst (BSA) to support a critical regulatory compliance initiative focused on automating NYS employment tax compliance processes. Requiring deep expertise in SAP payroll systems, tax compliance, and multi-system integrations.
BUSINESS CONTEXT RBC recently settled a NYS employment tax audit related to under-withholding and underreporting of wages for business travelers and trailing compensation. This project will automate compliance processes to prevent future audit exposure and ensure accurate tax withholding across multiple data sources and systems. KEY RESPONSIBILITIES (as listed below but not limited to)
Requirements Elicitation & Documentation • Conduct detailed interviews with Payroll, Global Mobility, Concur, EY, Finance, and other stakeholders to gather functional and technical requirements • Document current-state processes and identify gaps related to: o NYS wage withholding for nonresidents and travelers o Trailing compensation tax withholding during vesting periods o Relocation tracking and management o Remote work location capture • Create detailed requirements specifications for system integrations and process automation • Validate requirements across multiple stakeholder groups for alignment and completeness SAP Payroll & Tax Expertise • Analyze SAP US Payroll module configuration for NYS tax withholding calculations • Identify configuration gaps and recommend enhancements to support automated withholding • Understand wage types, vesting periods, and tax sourcing logic within SAP • Collaborate with Solution Architect on SAP update process automation design • Validate compensation data mapping and transformation rules Multi-System Integration Requirements • Define requirements for Concur → SAP data integration (travel and expense data) • Define requirements for TI (Tech Infrastructure) → EYMP BT (Ernst & Young Mobility Program Business Travel) tool data integration (travel and expense data) • Document compensation data flow: RBC Payroll → SFTP → EY Tool → SAP • Specify badge swipe location data integration points and validation logic • Identify data quality requirements and reconciliation procedures across systems • Define SLAs and turn-around times for data processing (especially critical for yearend close) NY State Tax Compliance • Understand NYS employment tax requirements and audit findings • Translate regulatory requirements into system/process requirements • Work with Payroll to clarify: o Workday definition (actual work vs. travel booking days) o Trailing compensation sourcing and withholding rules o Non-resident wage allocation and reporting o Relocation impact on tax withholding • Ensure requirements documentation is audit-defensible Location & Travel Data Requirements • Define requirements for capturing actual NYS workdays (vs. travel bookings) • Specify badge swipe data integration: data elements, frequency, validation rules • Assess feasibility of alternative data sources (Transit data, IP tracking, mobile location) • Document employee validation and reconciliation workflows • Define how remote work locations are captured and tracked for tax purposes Compensation Integration with EY Tool • Document detailed compensation data requirements for EY platform transmission: o Total wages, individual trailing compensation, MTI, bonus information o Data frequency (monthly + ad-hoc/o-cycle) o Return data specifications from EY • Define SFTP transmission specifications and schedules • Specify data validation and reconciliation rules between RBC and EY • Document turn-around time requirements for year-end close processing • Identify data governance and security requirements Stakeholder Coordination • Serve as primary point of contact between IT and business stakeholders (Payroll, Global Mobility) • Facilitate working sessions and requirements validation meetings • Escalate blockers and ambiguities to Sr. Project Manager and Solution Architect • Provide regular status updates on requirements clarity and feasibility assessment REQUIRED QUALIFICATIONS • 5+ years as Business Systems Analyst in financial services or similar regulated environment • Strong expertise in SAP US Payroll module (BSI Tax Factory) – configuration, data structures, withholding calculations • Experience with tax compliance systems and processes (preferably including state/local tax) • Understanding of payroll withholding concepts (wage allocation, sourcing, multistate compliance) • Experience documenting and validating system integration requirements • Excellent stakeholder management and communication skills • Ability to translate regulatory requirements into technical specifications • Strong analytical and problem-solving skills PREFERRED QUALIFICATIONS • NY State employment tax compliance experience (highly valued) • Experience with Concur Travel & Expense system • Familiarity with badge/location tracking systems or data sources • Experience with EY tools or third-party tax/compliance platforms • Knowledge of compensation integration workflows or deferred compensation systems • Prior experience on regulatory compliance or audit remediation projects KEY COMPETENCIES Competency Importance SAP Payroll Expertise -Critical Requirements Analysis -Critical Tax/Regulatory Knowledge -Critical
Competency Importance Multi-System Integration -Thinking High Stakeholder Management -High Documentation & Process Mapping -High Problem-Solving- High Communication (Verbal & Written)- High