Business Systems Analyst V

Robertson & Company

  • Toronto, ON
  • $70.00 per hour
  • Contract
  • Full-time
  • 1 day ago
Our client is a top financial institution with significant North American holdings. They have operations across most major verticals, including institutional & corporate, wealth management, private client, commercial banking, treasury, and retail banking.Introduction: Robertson is seeking a skilled Business System Analyst to join our client.Contract Period: 6 months with potential to extend or convert
Pay Rate: Starting $70/hour
Location: Toronto, ON
Location Type: Hybrid: onsite 2 days per week, shifting to 4 days in November
Business Hours: Monday to Friday; Core Business HoursJob Responsibilities:
  • Analyze, document and validate business rules requirements from business users.
  • As Spark SQL is used as a programming language for the business rules, a successful candidate is required to be able to write, test Spark SQL statements to translate the business requirements into the programming code.
  • Optimize performance and tune Spark SQL statements.
  • Use Visual Studio (SQL Integration Services) to analyze SSIS packages.
  • Analyze multiple system builds by completing and updating project requirements documentation; understanding project scope; determining project priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths.
  • Collaborate closely with the technology team to implement the requirements, provide necessary guidance to testers during QA process.
  • Assess business process and system inefficiencies.
  • Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
  • Participate in standup and planning meeting as part of the Agile methodology framework
Experience & Qualification Requirements:
  • 8+ years of experience working on large scale projects as well as handling day-to-day operational requests from the business.
  • 4+ years of experience with data analysis.
  • Familiarity with the general concepts of optimization and performance tuning of SQL statements.
  • Familiarity with RDBMS (Oracle, SQL Server).
  • Experience in financial services industry, specifically in Capital Markets and Treasury.
  • Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus
****ALL CANDIDATES MUST COMPLETE A CRIMINAL AND CREDIT CHECK AS PART OF THE APPLICATION PROCESS****How to Apply: If you are a motivated professional looking to contribute to a leading team, please submit your resume outlining your qualifications and experience relevant to this role. Robertson & the clients we represent, value diversity and are committed to creating an inclusive workplace. We invite all qualified individuals to apply.Robertson & the clients we represent are equal opportunity employers, committed to diversity and inclusion. Robertson is a certified diverse supplier and actively seeks to foster a representative and inclusive workforce. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, Aboriginal status, or any other legally protected factors. We champion building a diverse and inclusive environment. #LI-S1

Robertson & Company