INDIGO – Business Systems Analyst Specialist

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

Job summary

A global technology company in Toronto is seeking a passionate Business Systems Analyst Specialist. The role involves handling data analysis, onboarding feeds, and working with Big Data technologies like Hadoop and Spark. The ideal candidate should have over 3 years of experience in data analysis and a Bachelor's degree in a STEM field. This position offers a hybrid working model, allowing for flexibility while maintaining a healthy work-life balance.

Benefits

Flexible work arrangements

Wellbeing programs

Qualifications

• Experience working on large scale projects and daily operational requests.
• Hands-on experience in Advanced Excel.
• Over 3 years of data analysis.

Responsibilities

• Onboard new feeds for TBSM metrics completeness and accuracy.
• Build extraction pipelines from Indigo.
• Migrate Indigo to the Azure Cloud.

Skills

Data analysis

Communication skills

Problem solving skills

Relationship building

Education

Bachelor’s degree in a STEM field

Tools

Hadoop

Spark

SQL Server

Oracle

Advanced Excel

Job description

Overview

INDIGO – Business Systems Analyst Specialist

Banking & Financial Services

Toronto, Ontario

The Role

We are seeking a passionate, high energy, Business Systems Analyst. Our strength is built on our ability to work together. Within TBSM Technology, the Treasury Analytics Group (TAG) is dedicated to support the Treasury and Balance Sheet Management (TBSM) department in measuring and managing balance sheet, market and liquidity risks for the Bank's portfolios, both in Canada and US. This group manages technology infrastructure, processes and projects required to support various functional teams in TBSM.

Within TAG, the Indigo team manages the "Indigo" Hadoop/Spark platform, which is used for collecting and storing incoming retail banking activity data and the resulting treasury related metrics such as Non-Trading Market Risk (NTMR) and Fund Transfer Pricing (FTP). The platform also supports the generation of key regulatory liquidity reporting such as FR2052A.

This is an exciting opportunity for a SQL Analyst to join the team and work on industry standard and cutting-edge technologies including Big Data and NoSQL databases (Hadoop, Hbase, Hive, SPARK and MongoDB) and help TBSM effectively manage the risk.

If you are excited by change, and excel through autonomy, we would love to hear from you!

It takes a lot to succeed in today’s fast-paced market, and Cognizant has become a leader in the industry. We love big ideas and even bigger dreams. We stand out because we put human experiences at the core. We help clients engage customers by envisioning and building creative products and services. We develop go-to-market strategies and invent entirely new business models, ensuring that every company we work with walks away with both encouragement and a plan. Everything we do at Cognizant we do with passion—for our clients, our communities, and our organization. It’s the defining attribute that we look for in our people.

Responsibilities

• Onboarding new feeds to ensure completeness and accuracy of TBSM metrics.
• Build extraction pipelines from Indigo to other applications to support regulatory or business requirements.
• Integrate third party vendor based upstream data sources or downstream analytics with Indigo.
• Migrate Indigo to the Azure Cloud.
• Guide junior BSAs in the team.
• Code review of junior BSAs.
• Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production.
• 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.

Qualifications

• Experience working on large scale projects as well as handling day-to-day operational requests from the business
• Hands on experience in Advanced Excel.
• SDLC / Agile methodology experience.
• Over 3 years of 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 analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
• Being comfortable working in a distributed teams environment
• Strong problem solving skills
• Bachelor’s degree in a STEM field.
• 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

Work Authorization

Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.

Working arrangements

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring 2-3 days a week in a client OR Cognizant office in Toronto, ON. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.