Senior BSA / Data Migration Specialist

Compunnel, Inc.

Toronto

Hybrid

CAD 95,000 - 125,000

Full time

3 days ago

Be an early applicant

Application generator

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