Drive Snowflake migration analysis from a hybrid downtown business core setting, using solid SQL and data modeling expertise. Modernize critical investment data domains.

This experienced Business Systems Analyst supports strategic data modernization initiatives across legacy database platforms. You will document current-state assets, define future-state models, and support migration outcomes. The work spans business requirements, lineage, governance, validation, and stakeholder collaboration.

Key Responsibilities:
Analyze Oracle data structures, definitions, lineage, and transformation logic
Define requirements for Snowflake target-state architecture
Develop mappings, glossaries, dictionaries, and lineage documentation
Validate data quality rules, reconciliations,



and business controls
Support migration testing, validation, and business sign-off

Requirements:
Seven or more years of data-focused Business Analysis experience
Robust SQL skills analyzing databases and data models
Experience with migration, source-to-target mapping, and lineage
Understanding of Snowflake, cloud platforms, and dimensional modeling
Investment data platform experience, including Bloomberg PORT or FactSet

Apply your SQL, Snowflake, migration, and investment data expertise to modernize governed analytics-ready data platforms.

📌 Business Systems Analyst Snowflake Migration Toronto (Canada)
🏢 Alliance Search Partners
📍 Canada