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
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: 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 work from home 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
- 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
📌 Business Analyst (Toronto)
🏢 Artech
📍 Toronto
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.