Drive Snowflake migration analysis from a hybrid downtown business core setting, using strong 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)
🏢 Alliance Search Partners
📍 Toronto