IT - Bus Systems Analyst V

ICONMA; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A banking company is seeking an IT Bus Systems Analyst V located in Toronto. The role involves analyzing business requirements and writing Spark SQL statements while collaborating closely with technology teams. Candidates should have over 8 years of experience, particularly in financial services. The position offers health benefits and opportunities for growth.

Benefits

Health Benefits

Referral Program

Growth opportunities

Qualifications

• 8+ years of experience in large-scale projects and operational requests.
• 4+ years of experience in data analysis.
• Familiarity with RDBMS such as Oracle or SQL Server.
• Experience in financial services, especially in Capital Markets and Treasury.

Responsibilities

• Analyze and document business rules requirements.
• Write and test Spark SQL statements based on business needs.
• Collaborate with technology teams during implementation.
• Participate in standup and planning meetings.

Skills

Data analysis

SQL optimization

Problem-solving

Communication skills

Agile methodology

Tools

Spark SQL

Visual Studio

SQL Integration Services

Hadoop

Job description

Our Client, a Banking company, is looking for an IT - Bus Systems Analyst V for their Toronto, ON / Hybrid location.

Responsibilities

• Analyze, document and validate business rules requirements from business users.
• As Spark SQL is used as a programming language for the business rules, write and test Spark SQL statements to translate the business requirements into 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, and 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 meetings as part of the Agile methodology framework.

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).
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills.
• Ability to work in distributed teams environment.
• Strong problem-solving skills.
• 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.

Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities

As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or expression, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.