Business Systems Analyst - Capital Markets, Big Data Project

TEKsystems; Toronto; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

A leading bank in Canada seeks a highly skilled Business Systems Analyst to support risk management of balance sheets and portfolios using cutting-edge technologies. This hybrid role requires substantial experience in SQL and financial services, providing a rewarding opportunity for those passionate about financial risk management.

Qualifications

• 10+ years of experience in Business Systems Analysis.
• 5+ years of advanced SQL experience for data manipulation.
• 5+ years experience in Capital Markets or Financial Risk.

Responsibilities

• Analyze, document, and validate business rules requirements.
• Write, test, and optimize Spark SQL statements.
• Collaborate with technology teams to implement requirements.

Skills

SQL

Data analysis

Business analysis

Agile methodology

Tools

Hadoop

NoSQL

Spark

Oracle

SQL Server

Job description

About the Role :

We are seeking a highly skilled Business Systems Analyst to join our client, a leading bank in Canada. This role involves supporting the measurement and management of balance sheet, market, and liquidity risks for portfolios. The successful candidate will work with cutting-edge technologies, including Big Data and NoSQL databases, to enhance risk management processes.

Key Responsibilities :

• Analyze, document, and validate business rules requirements from business users.
• Write, test, and optimize Spark SQL statements to translate business requirements into programming code.
• Use Visual Studio (SQL Integration Services) to analyze SSIS packages.
• Complete and update project requirements documentation, ensuring efficient and on-time delivery of project tasks and milestones.
• Collaborate closely with the technology team to implement requirements and provide guidance during the QA process.
• Assess business process and system inefficiencies, recognizing patterns and conceptualizing processes.
• Participate in standup and planning meetings as part of the Agile methodology framework.

Top Skills Required :

10+ years of experience in Business Systems Analysis, including gathering and interpreting business requirements, and creating data solutions.

5+ years of advanced SQL experience for data manipulation, database relationships, file formatting, data analysis, testing, and validation.

5+ years of experience in the financial services industry, specifically in Capital Markets, Treasury, or Financial Risk (Market Risk / CCR / Liquidity Risk).

Secondary Skills - Nice to Have :

Experience with Big Data and NoSQL databases (Hadoop / HBase / Spark) and Spark SQL.

Familiarity with RDBMS (Oracle, SQL Server), and Liquidity Monitoring Report FR 2052a.

This is an exciting opportunity for a SQL Analyst to join a team working on industry-standard and cutting-edge technologies. You will play a crucial role in managing risk effectively and supporting various functional teams.

If you are passionate about financial risk management and have the required skills and experience, we encourage you to apply for this challenging and rewarding position.

Pay and Benefits :

The pay range for this position is $90.00 - $95.00 / hr.

Workplace Type :

This is a hybrid position in Toronto, ON.

À propos de TEKsystems :

Nous sommes partenaires dans la transformation. Nous aidons les clients à activer des idées et des solutions afin de profiter d’un nouveau monde d’opportunités. Nous sommes une équipe solide de 80 000 personnes, nous travaillons avec plus de 6 000 clients, dont 80 % faisant partie du Fortune 500, partout en Amérique du Nord, en Europe et en Asie. En tant que chefs de file de l’industrie des services technologiques complets, des services aux talents et des applications du monde réel, nous travaillons avec des leaders progressistes pour favoriser le changement. C’est le pouvoir d’un vrai partenariat. TEKsystems est une société du groupe Allegis.

About TEKsystems :

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe, and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

J-18808-Ljbffr