Senior BSA / Data Migration Specialist

Compunnel Inc.

Toronto

On-site

CAD 95,000 - 125,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Compunnel, Inc. in Toronto, Canada is seeking a Senior Business Systems Analyst / Data Migration Specialist to drive data transformation between Salesforce and surrounding ecosystems (IBM DataStage, Snowflake, Tableau, and legacy apps).

You will translate business requirements into precise mapping, transformation, migration, reconciliation, and validation tasks. You will collaborate with business stakeholders, data teams, architects, developers, and QA to ensure successful system conversion and

Qualifications

  • 7+ years as a Business Systems Analyst or related role in large enterprises.
  • Strong end-to-end data migration experience.
  • Excellent requirements elicitation and stakeholder management.
  • Deep knowledge of data mapping, transformation, validation, and reconciliation.

Responsibilities

  • Understand business processes, data usage, and reporting needs with stakeholders.
  • Lead requirements gathering and facilitate discussions between business and technology teams.
  • Analyze source/target systems to understand data structures, relationships, and constraints.
  • Document source-to-target mappings, business rules, transformation logic, and migration needs.
  • Identify data quality issues, gaps, anomalies, and migration risks.
  • Collaborate with Data Engineers and ETL teams to support migration activities.
  • Support data reconciliation and validation to ensure completeness after migration.
  • Define acceptance criteria and assist SIT/UAT and post-migration validation.

Skills

Data migration
Requirements elicitation
Stakeholder management
SQL
Data profiling

Tools

Salesforce
Snowflake
IBM DataStage
Tableau

Job description

Job Summary

The Senior Business Systems Analyst / Data Migration Specialist will support data transformation and migration initiatives between Salesforce and surrounding data ecosystems, including IBM DataStage, Snowflake, Tableau, and legacy applications. The role will work closely with business stakeholders, data teams, architects, developers, and QA teams to understand business requirements and translate them into clear data mapping, transformation, migration, reconciliation, and validation requirements. The position will also analyze downstream data dependencies and support successful system conversion and post-migration validation.

Key Responsibilities
  • Engage with business stakeholders to understand business processes, requirements, data usage, and reporting needs
  • Lead requirements gathering and facilitate discussions between business and technology teams
  • Analyze source and target systems to understand data structures, relationships, dependencies, and constraints
  • Define and document source-to-target mappings, business rules, transformation logic, and data migration requirements
  • Identify data quality issues, gaps, anomalies, duplicates, and migration risks
  • Work with stakeholders to determine appropriate approaches for data remediation
  • Perform data analysis and profiling using SQL and related tools
  • Collaborate with Data Engineers and ETL teams to support data migration and transformation activities
  • Support data reconciliation and validation to ensure data completeness and accuracy following migration
  • Define business acceptance criteria and support SIT, UAT, and post-migration validation activities
  • Analyze downstream impacts of migrated data, particularly for Tableau reporting and analytics
  • Work within data environments involving Salesforce, Snowflake, IBM DataStage, Tableau, and legacy applications
  • Communicate complex data issues, constraints, dependencies, risks, and recommendations to technical and non-technical stakeholders
Required Qualifications
  • 7+ years of experience as a Business Systems Analyst, Data Analyst, Data Migration Specialist, or related role, preferably within large enterprise environments
  • Strong experience with end-to-end data migration or system conversion projects
  • Excellent requirements elicitation and stakeholder management skills
  • Strong understanding of source-to-target mapping, data transformation, data profiling, data cleansing, reconciliation, and validation
  • Strong SQL and data analysis skills
  • Experience identifying and articulating data constraints, dependencies, risks, and business impacts
  • Deep understanding of reporting and downstream data dependencies
  • Strong documentation and communication skills
Preferred Qualifications
  • Experience with Salesforce
  • Experience with Snowflake
  • Experience with IBM DataStage or comparable ETL/data integration platforms
  • Experience with Tableau and downstream reporting and analytics
  • Experience supporting financial services or banking environments
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

OPEN: Data Migration Lead – Enterprise Transformation
OPEN: Data Migration Lead – Enterprise Transformation

Cpus Engineering Staffing Solutions Inc. • Toronto

Hybrid
CAD 120,000 - 150,000
Data Migration Lead - GCP Dataproc, Salesforce Cloud
Data Migration Lead - GCP Dataproc, Salesforce Cloud

Astra-North Infoteck Inc. • Brampton

On-site
CAD 70,000 - 120,000
Salesforce Technical Lead – Salesforce Development, Integration & Data Migration
Salesforce Technical Lead – Salesforce Development, Integration & Data Migration

Astra-North Infoteck Inc. • Toronto

On-site
CAD 120,000 - 170,000
Senior Data Engineer
Senior Data Engineer

Apply Digital • Vancouver

On-site
CAD 120,000 - 180,000
Senior Salesforce Technical Lead – Salesforce Development, Enterprise Implementation & Integration
Senior Salesforce Technical Lead – Salesforce Development, Enterprise Implementation & Integration

Astra-North Infoteck Inc. • Toronto

On-site
CAD 150,000 - 190,000
Senior Business Analyst
Senior Business Analyst

SiriusXM Canada Inc. • Canada

On-site
CAD 90,000 - 120,000
Senior Salesforce Financial Services Cloud Business Analyst
Senior Salesforce Financial Services Cloud Business Analyst

Winobell Inc • Toronto

On-site
CAD 110,000 - 140,000
Senior Business Systems Analyst
Senior Business Systems Analyst

Manulife John Hancock • Southwestern Ontario

On-site
CAD 90,000 - 120,000
Senior Data Analyst / BI Analyst
Senior Data Analyst / BI Analyst

High Tech Genesis • Ottawa

On-site
CAD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Montreal

On-site
CAD 90,000 - 120,000