Lead II - Data Engineering

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

Who We Are

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live. With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world. Visit us at UST.com.

Role Description

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 setting involving Snowflake, IBM DataStage, and Tableau
- Clearly communicate complex data issues, constraints, and recommendations to both technical and non-technical stakeholders

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

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 gener

📌 Senior BSA (Montreal)
🏢 UST
📍 Montreal