Business Systems Analyst​/Core Trading Data Migration

NOTE

Hybrid work model, 3 days per week in Toronto, Ontario office

• 6 plus years Business Analysis
• Capital Markets
• SQL
• Data Analysis
• Data Mapping
• Requirements Gathering
• User Stories
• Snowflake
• Data Migration
• Agile

Financial Services, Investment Management, Enterprise Technology

We are seeking an experienced Business Systems Analyst with strong domain expertise in capital markets and data analysis to support a Product Engineering team within a large enterprise technology environment.

This role supports a Cloud Data Migration initiative focused on migrating data and related components from on premise Oracle systems to Snowflake and cloud based platforms. The position operates within a collaborative, cross functional team of business analysts, developers, and product stakeholders working closely with business partners.

The successful candidate will bring strong experience working with financial datasets and data migration initiatives, along with the ability to translate business requirements into clear, actionable specifications for technical teams. This role is best suited for a Business Analyst who is comfortable working with complex data structures, understands data lineage and mapping, and can support delivery in a fast paced agile environment.

The role includes a strong emphasis on data analysis, data mapping, and validation of outputs to ensure integrity and accuracy throughout the migration process. The Business Analyst will play a critical role in ensuring that business requirements are well understood and that delivered solutions align with expected outcomes.

You will work closely with business stakeholders, product owners, and developers to support the migration of data and services while enabling ongoing enhancements to core trading systems and data platforms.

• Engage business stakeholders to understand business objectives, trading workflows, and data requirements
• Gather, analyze, and document functional and non functional requirements and translate them into clear user stories and solution specifications
• Lead requirement discussions and produce detailed documentation including meeting notes, process flows, and data mappings
• Perform detailed data analysis on existing Oracle based systems and support migration to Snowflake
• Define and maintain data mappings between source and target systems ensuring accuracy and completeness
• Work closely with developers to ensure requirements are clearly understood and implemented accurately
• Support day to day delivery of the Cloud Data Migration initiative and related enhancements
• Define and maintain data lineage and transformations across systems and data repositories
• Design and create test cases to validate system functionality and data outputs
• Perform data validation and ensure accuracy of migrated data and transformations
• Support User Acceptance Testing activities including defining test strategies, coordinating execution, and validating results
• Collaborate with developers to improve validation processes and ensure data integrity
• Contribute to continuous improvement of business analysis practices and team delivery effectiveness
• Participate in planning and estimation activities for ongoing initiatives and enhancements
• Identify risks, issues, and dependencies and communicate them clearly to stakeholders
• Other duties as assigned

• University degree in Business, Finance, Mathematics, Computer Science, Engineering, or equivalent experience
• Minimum 5 to 6 years of experience in a Business Analyst or Business Systems Analyst role
• Strong domain expertise in capital markets and financial instruments is required
• Experience working with investment data across asset classes including equities, fixed income, FX, and derivatives is preferred
• Proven experience working on data migration or data transformation initiatives
• Strong SQL and data analysis skills with experience working with large datasets
• Experience with relational databases and familiarity with platforms such as Oracle or Snowflake
• Strong understanding of data mapping, data lineage, and data validation concepts
• Strong experience translating business requirements into user stories in an agile environment
• Experience supporting testing activities including test case design and data validation
• Excellent communication and stakeholder engagement skills
• Strong analytical thinking and attention to detail, especially in working with financial and trading data
• Ability to manage multiple priorities and work both independently and collaboratively
• Familiarity with Agile and iterative delivery methodologies
• Experience with tools such as Jira, Confluence, or Excel based analysis is an asset
• Exposure to cloud data platforms such as Snowflake is considered an asset
• Experience using AI tools to support analysis and delivery is considered an asset

• This role operates within a collaborative Product Engineering team supporting a multi year Cloud Data Migration program
• The Business Analyst is expected to play a key role in…