INDIGO – Business Systems Analyst Specialist

Banking & Financial Services

Toronto, Ontario

ABOUT US

Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant, a member of the NASDAQ-100, is ranked 195 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients with digital at www.cognizant.com.

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.