Technical Business Systems Analyst

Akkodis; Toronto; On-site; CAD 80,000 - 100,000; Part time

Job summary

A professional services firm is seeking a Business Systems Analyst (Spark/Big Data) for a 6-month contract. This role involves leading project teams on high-quality deliverables while managing project estimates and risks. The successful candidate will work with technologies like Hadoop and SQL, and must hold a Bachelor's degree in a STEM field. This position is aimed at incorporated entities only, highlighting a B2B engagement model.

Qualifications

• Experience working on large scale projects and daily operational requests
• Hands on experience in Advanced Excel
• Familiarity with RDBMS (Oracle, SQL Server)
• Developer or BSA or Data Analysis background with 5+ years of relevant experience

Responsibilities

• Lead project teams with high quality deliverables
• Manage project estimates, risks, and communications
• Document and validate business rules requirements
• Devise testing plans for release implementation
• Assist internal audit and regulators in reviews

Skills

Advanced Excel

SDLC

Agile methodology

Relationship building

Communication skills

SQL

Python

Java

Education

Bachelor’s degree in a STEM field

Tools

Oracle

SQL Server

Hadoop

HBase

Spark

Spark SQL

Job description

Position: Business Systems Analyst (Spark/Big Data)/Technical Business Systems Analyst

Duration: 6 month assignment (contract)

Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)

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 and wholesale banking activity data and also 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 to lead project teams comprising Business System Analysts (BSAs) and Developers working on industry standard and cutting-edge technologies including Big Data and NoSQL databases (Hadoop, Hbase, Hive, SPARK and MongoDB) and help the TBSM effectively manage the risk.

Examples of projects/work activities include (but not limited to):

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.

Manage Business as Usual (BAU) activities- i.e. manage regular processes currently in production.

About this Role:

Demonstrate leadership in driving projects to their timely completion and ensuring the work is of high quality.

Assume a lead role in project management activities such as: scoping and estimating project efforts, identifying risks and recommending mitigation measures, communicating activity status, as well as escalating and communicating possible issues.

Work with other stakeholders in a project to document and validate business rules requirements.

Help BSAs and developers to translate the business requirements into technical requirements.

Work with members of the team to put together estimates for work packages.

Devise testing plans for release implementation, taking into consideration multiple factors, including but not limited to, the Business' requirements, time constraints and impact of changes to existing processes in production.

Monitor ongoing resourcing requirements and proactively flag potential issues to the manager.

Develop a solid understanding of the Indigo platform and adjacent applications including both strengths and limitations, so that the candidate can become a voice of authority and a strategic influencer.

Embrace a hands-on approach to problem solving.

Assist internal audit and regulators in their reviews and work on remediation of issues identified.

Coach new or less experienced colleagues.

Mandatory Skills:

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.

Familiarity with RDBMS (Oracle, SQL Server)

Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills

Being comfortable working in a distributed teams environment

Demonstrated success in building effective relationships in a highly cross-functional environment.

Bachelor’s degree in a STEM field.

Nice to Have 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

Developer or BSA or Data Analysis background with 5+ years of relevant experience.

Hands on experience in SQL/Python/Java

This is a business-to-business engagement. Candidates must represent an incorporated entity, hold a valid business number, maintain appropriate insurance, and invoice for services rendered.

How to Apply

Submit your resume in confidence to [e-mail] or via the Akkodis Canada website.

We thank all applicants for their interest in this opportunity. Only candidates meeting the above qualifications will be contacted for further discussions.

Accessibility:

At Akkodis, part of The Adecco Group, our purpose is simple: to make the future work for everyone. We live our values, Passion, Collaboration, Inclusion, Courage, and Customers at Heart, by fostering a workplace where diversity is celebrated and every voice matters. We encourage applications from individuals of all backgrounds and identities. Together, we’re making the future work for everyone.