Hiring.Camp

Business Systems Analyst - Data Modernisation

Cg Consulting

·

3 weeks ago

Location
Toronto, Canada
Workplace
Hybrid
Type
Full-time
Seniority
Mid
Experience
7+ years
Source
PCRecruiter

Description

Business Systems Analyst - Data Modernisation

Client is a dynamic Toronto-based IT consulting boutique that strives for excellence in customer service and delivery in financial services and fintech industry.
They focus on technology advisory services, application development, cloud computing, integration solutions, and enterprise big data and analytics.
With a team of highly knowledgeable business and technical experts, we provide strategic, mission critical solutions to our clients.
We are looking for a Business Systems Analyst for Data Modernisation initiative. Our preference is to look for a smart Intermediate BSA who is eager to learn and grow, instead of a Senior BSA.

Company location: Downtown Toronto,
Hybrid work environment - 2-3 days in office/week
Perm / FTE role: Salary: Market rate + benefits and performance bonus

DESCRIPTION:
We are looking for an experienced Business Systems Analyst to support strategic data modernization initiatives migrating management data from legacy database platforms to Snowflake. The role will partner with business stakeholders, data architects, and engineering teams to document current-state data assets, define future-state data models, and ensure successful migration of critical front-office and investment data domains

RESPONSIBILITIES
• Analyze and document current-state data structures, business definitions, lineage, and transformation logic across Oracle-based platforms.
• Elicit and define business and data requirements for the Snowflake target-state architecture.
• Lead workshops with portfolio management, trading, performance, attribution, operations, and technology stakeholders.
• Develop source-to-target mappings, business glossaries, data dictionaries, and data lineage documentation.
• Define and validate data quality rules, reconciliation requirements, and business controls.
• Support migration testing, data validation, and business sign-off activities.
• Collaborate with architects and engineers to design scalable, governed, analytics-ready Snowflake data models.
• Act as the liaison between business stakeholders, data owners, implementation partners, and technology teams to drive data modernization and migration outcomes.

REQUIRED EXPERIENCE
• 7+ years of Business Analysis experience focused on data and analytics initiatives.
Strong investment management domain knowledge, including: Performance measurement and reporting
Performance attribution
ETF and portfolio management workflows
OMS and trade data
Security master data
Pricing and market data
Benchmark, holdings, and transaction data
● Experience with investment data platforms such as Bloomberg PORT, Bloomberg pricing services, FactSet, and related front-office systems.
● Strong SQL skills and experience analyzing databases and data models.
● Proven experience with data migration, source-to-target mapping, and data lineage documentation.
● Knowledge of Oracle an asset
● Understanding of Snowflake, modern cloud data platforms, dimensional modeling, and data governance practices.

PREFERRED QUALIFICATIONS
• Experience in asset management, wealth management, or capital markets organizations.
• Familiarity with Agile delivery methodologies.
• Knowledge of data quality, metadata management, and data governance frameworks.
• Experience supporting large-scale cloud data modernization programs.


NOTE:
G.G. Consulting Group uses advanced ATS systems to track and manage candidates and jobs. We do not use AI tools for candidate screening.

Skills

SQLOracleSnowflakeAgileCustomer Service

Similar Jobs

30

Business Systems Analyst

M.H. Eby·Ephrata, Pennsylvania

Business Systems Analyst

Deloitte Consulting·Remote

Business Systems Analyst

TMHCC enables you to take·Georgia, US·Onsite

2d ago

Analyst, Business Systems

Edwards·Costa Rica-Cartago-BSC·Hybrid

2d ago

Business Systems Analyst

Ci·CDA ON Head Office - 15 York, Canada

2d ago

Business Systems Analyst

Ameresco bring employees to the·US·Remote

2d ago

Business Systems Analyst

Red Arch Solutions·Reston, Virginia·Onsite

2d ago

Business Systems Analyst

TransUnion·Chicago, Illinois·Hybrid

2d ago

Business Systems Analyst

Brainerd Chemical Company Inc·Tulsa, Oklahoma·Onsite

3d ago

Business Systems Analyst

Kinders·Walnut Creek, California

4d ago

Business Systems Analyst

Price Industries Limited·Winnipeg, Manitoba

4d ago

Business Systems Analyst

Greystar·Texas, US·Remote

5d ago

Business Systems Analyst

U.S. Engineering·Kansas City, Missouri

5d ago

Business Systems Analyst

Searchlabs·Markham, Ontario·Hybrid, Onsite

Business Systems Analyst

ABM UK·Hounslow, England·Hybrid

Business Systems Analyst

Dallascollege·Brookhaven, Georgia +5·Hybrid

6d ago

Business Systems Analyst

Sarahbush·Remote Office - IL, US·Remote

6d ago

Business Systems Analyst

Why work for Toyota Come and join our team.·Port Melbourne, Victoria·Onsite

6d ago

Business Systems Analyst

Flyzipline·South San Francisco, California

Business Systems Analyst

Flextronics·Illinois, US

1w ago

Business Systems Analyst

Ascot Underwriting Holdings Limited·Iselin, New Jersey·Hybrid

1w ago

Business Systems Analyst

Data Edge·Bucharest, București·Hybrid

1w ago

Business Systems Analyst

Endex·New York City, New York·Onsite

1w ago

Business Systems Analyst

Clarivate·India·Hybrid

1w ago

Business Systems Analyst

Career opportunities·India·Hybrid

1w ago

Business Systems Analyst

ASHA·Rockville, Maryland

1w ago

Business Systems Analyst

Ksturnpike·Wichita, Kansas

1w ago

Business Systems Analyst

Dentsuaegis·USA-Office-Michigan-Detroit-3000 Town Center, US·Hybrid

1w ago

Business Systems Analyst

Goodlord·London, England +1·Hybrid

1w ago

Business Systems Analyst

Yeticoolers·VNM - Vietnam

1w ago