Capco

2 weeks ago

Business Systems Analyst/Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 4 hours agoStatus: Live

Job Summary

Bridge business needs and modern data engineering by gathering and documenting business and data requirements, then designing and delivering enterprise reporting and analytics solutions. Build scalable ETL/ELT pipelines in Azure, perform data profiling and validation to ensure quality, and create source-to-target mappings, data models, and technical specifications. Work in Agile delivery teams with architects, developers, and QA to deploy and continuously improve reliable data products.

Location: Toronto

Workplace: Onsite

Employment Type: Full time

Job Function: Software Engineering

Seniority: Mid level

Key Responsibilities

•Partner with business stakeholders to gather, analyze, and document business, functional, and data requirements for reporting and analytics solutions.
•Design, develop, and maintain scalable ETL/ELT data pipelines to ingest, transform, and integrate data in Azure-based environments.
•Perform data profiling, validation, reconciliation, and data quality assurance to maintain accuracy, integrity, and consistency.
•Create source-to-target mappings, data models, technical specifications, and support system integration testing, UAT, and production deployments.
•Collaborate in Agile delivery teams with solution architects, developers, and QA while contributing to continuous improvement initiatives.

Pay and Benefits

Salary: CAD 118,000 - 152,000

Perks:Health InsuranceLife InsuranceDisability InsuranceRrspParental LeaveEmployee AssistanceGym Membership

Key Requirements

•5+ years of experience as a Business Systems Analyst, Data Engineer, or in a hybrid BSA/Data Engineering role with strong business and technical analysis skills.
•Advanced SQL skills with hands-on experience building ETL/ELT pipelines, data modelling, and data warehousing solutions.
•Programming experience with Python and PySpark, plus practical knowledge of Azure-based data platforms.
•Excellent analytical, communication, stakeholder management, and problem-solving skills working in Agile environments.
•A collaborative mindset to translate business requirements into scalable, reliable data solutions.

Experience:5+ years

Skills:Analytical skillsCommunicationStakeholder managementProblem-solvingCollaboration

Languages:English

Tech Stack:SQLETLELTPythonPySparkAzureMicrosoft FabricAzure Data FactoryAzure Synapse AnalyticsAzure DatabricksAzure SQL DatabaseSQL ServerPower BIAzure DevOpsGitJiraConfluenceAgileData modellingData warehousing

Company Brief

Capco

Global management and technology consultancy specializing in financial services. Capco advises banks, insurers, and capital markets firms on digital transformation, risk and compliance, technology implementation, and operational improvement, combining industry expertise with advisory and engineering capabilities.

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

Capco

2 weeks ago

Business Systems Analyst/Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 4 hours agoStatus: Live

Job Summary

Location: Toronto

Workplace: Onsite

Employment Type: Full time

Job Function: Software Engineering

Seniority: Mid level

Key Responsibilities

•Partner with business stakeholders to gather, analyze, and document business, functional, and data requirements for reporting and analytics solutions.
•Design, develop, and maintain scalable ETL/ELT data pipelines to ingest, transform, and integrate data in Azure-based environments.
•Perform data profiling, validation, reconciliation, and data quality assurance to maintain accuracy, integrity, and consistency.
•Create source-to-target mappings, data models, technical specifications, and support system integration testing, UAT, and production deployments.
•Collaborate in Agile delivery teams with solution architects, developers, and QA while contributing to continuous improvement initiatives.

Pay and Benefits

Salary: CAD 118,000 - 152,000

Perks:Health InsuranceLife InsuranceDisability InsuranceRrspParental LeaveEmployee AssistanceGym Membership

Key Requirements

•5+ years of experience as a Business Systems Analyst, Data Engineer, or in a hybrid BSA/Data Engineering role with strong business and technical analysis skills.
•Advanced SQL skills with hands-on experience building ETL/ELT pipelines, data modelling, and data warehousing solutions.
•Programming experience with Python and PySpark, plus practical knowledge of Azure-based data platforms.
•Excellent analytical, communication, stakeholder management, and problem-solving skills working in Agile environments.
•A collaborative mindset to translate business requirements into scalable, reliable data solutions.

Experience:5+ years

Skills:Analytical skillsCommunicationStakeholder managementProblem-solvingCollaboration

Languages:English

Company Brief

Capco

Industry: Management Consulting

Company Size: Enterprise (1,001+ employees)

Growth: Established Company

Headquarters: London, United Kingdom

Founded: 1998

Glassdoor: 3.7

Website LinkedIn