Senior Business Systems Analyst – Data Integration (ETL, Databricks/Snowflake) - 8097

S I Systems; Toronto, Winnipeg; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

S I Systems seeks a Senior Business Systems Analyst – Data Integration to define requirements for complex ETL-enabled solutions across legacy and modern platforms. The role collaborates with internal teams and external vendors to map data flows, validate data quality, and guide implementation efforts in a hybrid Toronto/Winnipeg environment.

Qualified candidates will have strong data integration experience, ETL expertise, and familiarity with Databricks and Snowflake data lakehouse technologies.

Qualifications

• Post-secondary degree in a related discipline (Computer Science, Commerce, Business Administration, MIS, etc) or equivalent combination of education and experience.
• Experience with data mapping and integration processing.
• Experience with technology project methodologies, processes, and practices.
• Experience working with external vendors and consultants.
• Previous experience with Investment Systems would be an asset.
• Strong financial acumen would be considered an asset.
• Experience working with E2E System to System Integration (ETL)
• Experience working with Data Lakehouse (Databricks, Snowflake) solutions

Responsibilities

• Define and document detailed business requirements and system specifications.
• Map functionality to requirements for 3rd party solutions and in-house systems.
• Support software development and testing teams during delivery.
• Engage with vendors/consultants to ensure alignment and risk mitigation.
• Assist in test planning and validation with QA teams.
• Participate in project implementations and warranty period support.
• Translate data requirements into executable data integration solutions.

Skills

Data mapping

Data integration

ETL processing

Vendor collaboration

Financial acumen

Education

Post-secondary degree in CS/Commerce/MIS

Tools

Databricks

Snowflake

Job description

Senior Business Systems Analyst – Data Integration (ETL, Databricks/Snowflake) – 8097

Senior Business Systems Analyst – Data Integration (ETL, Databricks/Snowflake) – 8097

Duration: 5 Months initial (Extension until EOY 2027 confirmed)

Overview:

• The successful candidate will have a proven track record in defining complex requirements for solutions integrated among existing and new systems with legacy and emergent technologies and the ability to effectively work both independently as well as a member of a large local or virtual team.
• They will have experience participating in the delivery/implementation of solutions that are in-house developed and solutions that are produced/supported by 3 rd party suppliers.
• Contributes to the development of the project deliverables, with respect to definition of project scope, estimates for systems analysis tasks, identification of stakeholders, approach, methodology, communication plan, systems analyst resourcing and schedule.
• Gains clear understanding of business problems/opportunities to define and document detailed business requirements and associated detailed system specifications.
• Engages other project team members to identify and document alternatives and recommend solutions.
• Identifies, escalates and contributes to the resolution of project issues and mitigation of project risks.
• Supports Software Developers during software development and testing.
• Works closely with Quality Assurance team members to ensure adequate testing by contributing to test plans, identification of test situations and test cases, execution of test plan and verification that test results meet business expectations.
• Supports project implementation by execution of assigned project implementation activities including verification that system is performing as expected and providing support during project Warranty Period.
• Works directly with 3 rd party vendors who supply solutions that will be configured as part of a project, to ensure understanding of the solution and map functionality to requirements (both functional requirements and engineering requirements).
• Gain early understanding of a 3 rd party solution to identify data that will be contained in the solution and possibly shared with other solutions, to ensure clear end to end identification and classification of all data required.

Must haves:

• Post-secondary degree in a related discipline (Computer Science, Commerce, Business Administration, Management Information Systems, etc), or an equivalent combination of post-secondary education, training and experience.
• Experience with data mapping and integration processing.
• Experience working with technology project methodologies, processes, and practices.
• Experience working with external vendors and consultants.
• Previous experience with Investment Systems would be considered an asset.
• Strong financial acumen would be considered an asset.
• Experience working with System to System Integration (Extract, Transform, Load (ETL))
• Experience working with Data Lakehouse (i.e. Databricks, Snowflake, etc.) solutions

Senior Business Systems Analyst – Data Integration (ETL, Databricks/Snowflake) – 8097

Duration: 5 Months initial (Extension until EOY 2027 confirmed)

Location: Toronto, Winnipeg (Hybrid 3x/week)

Overview:

• The successful candidate will have a proven track record in defining complex requirements for solutions integrated among existing and new systems with legacy and emergent technologies and the ability to effectively work both independently as well as a member of a large local or virtual team.
• They will have experience participating in the delivery/implementation of solutions that are in-house developed and solutions that are produced/supported by 3 rd party suppliers.
• Contributes to the development of the project deliverables, with respect to definition of project scope, estimates for systems analysis tasks, identification of stakeholders, approach, methodology, communication plan, systems analyst resourcing and schedule.
• Gains clear understanding of business problems/opportunities to define and document detailed business requirements and associated detailed system specifications.
• Engages other project team members to identify and document alternatives and recommend solutions.
• Identifies, escalates and contributes to the resolution of project issues and mitigation of project risks.
• Supports Software Developers during software development and testing.
• Works closely with Quality Assurance team members to ensure adequate testing by contributing to test plans, identification of test situations and test cases, execution of test plan and verification that test results meet business expectations.
• Supports project implementation by execution of assigned project implementation activities including verification that system is performing as expected and providing support during project Warranty Period.
• Works directly with 3 rd party vendors who supply solutions that will be configured as part of a project, to ensure understanding of the solution and map functionality to requirements (both functional requirements and engineering requirements).
• Gain early understanding of a 3 rd party solution to identify data that will be contained in the solution and possibly shared with other solutions, to ensure clear end to end identification and classification of all data required.

Must haves:

• Post-secondary degree in a related discipline (Computer Science, Commerce, Business Administration, Management Information Systems, etc), or an equivalent combination of post-secondary education, training and experience.
• Experience with data mapping and integration processing.

• Experience working with technology project methodologies, processes, and practices.
• Experience working with external vendors and consultants.
• Previous experience with Investment Systems would be considered an asset.
• Strong financial acumen would be considered an asset.
• Experience working with System to System Integration (Extract, Transform, Load (ETL))
• Experience working with Data Lakehouse (i.e. Databricks, Snowflake, etc.) solutions

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.