JOB SUMMARY:

As a Business Systems Analyst, you will support treasury data transformation initiatives by analyzing, documenting, and optimizing business rules and data integration processes. This role requires strong SQL and Spark SQL expertise, excellent communication, and the ability to thrive in a collaborative Agile environment within a top Canadian financial institution.

REQUIRED EXPERIENCE:

• 8+ years on large-scale projects and handling operational requests
• 4+ years of data analysis experience
• Strong knowledge of SQL optimization and performance tuning
• Experience with RDBMS (Oracle, SQL Server)

NICE-TO-HAVE EXPERIENCE:

• Financial services, capital markets, or treasury background
• Big Data / NoSQL exposure (Hadoop, HBase, Spark, Spark SQL)

PREFERRED SKILLS:

• Agile methodology experience
• Ability to work in distributed teams
• Comfort with multi-tasking and deadline management

ADDITIONAL SKILLS:

• Post-secondary education or relevant certifications
• Documentation and process analysis capabilities

• Analyze, document, and validate business rules and requirements
• Write, test, and optimize Spark SQL statements to translate requirements into programming logic
• Tune and optimize SQL queries for performance
• Use Visual Studio (SSIS) to analyze data integration packages
• Update project requirements documentation and prioritize deliverables
• Provide guidance to testers and collaborate with developers to ensure successful implementation
• Assess system inefficiencies and recommend improvements
• Participate in Agile standups, planning sessions, and retrospectives