Role description

Senior BSA / Data Migration Specialist (Salesforce)

Lead II - Data Engineering

UST is searching for an experienced Senior Business Systems Analyst / Data Migration Specialist to support data transformation or migration between Salesforce and surrounding eco system including DataStage, Snowflake, Tableau and any legacy applications. The ideal candidate will have strong business-facing skills combined with hands-on experience analyzing data, defining migration requirements, and supporting the movement of data from legacy/source systems to target platforms.

The opportunity:
• 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 and work with stakeholders to determine remediation approaches
• Perform data analysis and profiling using SQL and related tools
• Work closely with Data Engineers/ETL teams supporting migration and transformation activities
• Support data reconciliation and validation to ensure completeness and accuracy following migration
• Define business acceptance criteria and support SIT/UAT and post-migration validation
• Analyze downstream impacts of migrated data, particularly for Tableau reporting and analytics
• Work within a data environment involving Snowflake, IBM DataStage, and Tableau
• Clearly communicate complex data issues, constraints, and recommendations to both technical and non-technical stakeholders

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

What you need:
• 7+ years of experience as a Business Systems Analyst, Data Analyst, or Data Migration Specialist, preferably within large enterprise environments
• Strong experience with end-to-end data migration / system conversion projects
• Excellent requirements elicitation and stakeholder management skills
• Strong understanding of source-to-target mapping, data transformation, data profiling, cleansing, reconciliation, and validation
• Strong SQL and analytical skills
• Experience with Salesforce, Snowflake, IBM DataStage or comparable ETL/data integration platforms and Tableau is a plus
• Deep understanding of reporting and downstream data dependencies
• Ability to identify and articulate data constraints, dependencies, risks, and business impacts
• Strong documentation and communication skills
• Financial services/banking experience would be an asset

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Role Location: Ontario

Compensation Range: $104,000-$130,000

Benefits

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), paid holidays, and are eligible for paid bereavement leave and jury duty. They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year). They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Part-time regular and temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All Canadian employees who work in a province, territory or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.

#UST

#LI-AP4