Data Engineer

Capco
Toronto
Workplace: OnsiteFull timeCAD 92,000 - 118,000 annuallyFunction: Data Analytics & Business IntelligenceExperience: 3-5 yearsSkills: ["Analytical thinking","Problem-solving","Data quality focus","Root cause analysis","Stakeholder collaboration"]

Join Capco’s Technology & Engineering practice in Toronto as a Data Engineer consultant for financial services clients. You’ll validate and reconcile large datasets by building Python-based comparison and data-quality frameworks using Pandas, NumPy, and SQL. The role focuses on automating quality checks, investigating discrepancies and root causes, and reporting data quality metrics while collaborating with business, analytics, and engineering teams to support delivery and decision-making.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Capco
Capco
2 days ago

Data Engineer

✓ Verified Job

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

Source: Company careers pageValidated by: Fursa AI
Last checked: 3 hours agoStatus: Live

Job Summary

Join Capco’s Technology & Engineering practice in Toronto as a Data Engineer consultant for financial services clients. You’ll validate and reconcile large datasets by building Python-based comparison and data-quality frameworks using Pandas, NumPy, and SQL. The role focuses on automating quality checks, investigating discrepancies and root causes, and reporting data quality metrics while collaborating with business, analytics, and engineering teams to support delivery and decision-making.
Location: Toronto
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Validate and reconcile two or more datasets simultaneously.
  • •Build Python-based data validation and comparison frameworks.
  • •Use Pandas and NumPy to analyze, transform, and validate large datasets.
  • •Automate processes to detect missing, duplicate, or inconsistent data and generate discrepancy reports.
  • •Investigate data quality issues, determine root causes, and communicate findings with stakeholders while collaborating across teams.

Pay and Benefits

Salary: CAD 92,000 - 118,000 annually
Perks:Health InsuranceLife InsuranceDisability InsuranceRrspEmployee AssistanceParental LeaveWellness StipendLearning Budget

Key Requirements

  • •3-5+ years of experience in data engineering, data analytics, or data quality engineering.
  • •Strong hands-on Python experience (3+ years), with advanced Pandas and NumPy.
  • •Proficiency with SQL and experience processing and validating large structured datasets (millions of records).
  • •Experience comparing and reconciling data from multiple sources, including data cleansing and transformation.
  • •Experience building and automating validation rules and investigating data discrepancies/root causes.
Experience:3-5 yearsFinancial services
Skills:Analytical thinkingProblem-solvingData quality focusRoot cause analysisStakeholder collaboration
Languages:English
Tech Stack:PythonPandasNumPySQLPySparkAzure Data FactoryDatabricksPower BIGitCI/CDAzureAWSGCP

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
Glassdoor: 3.7
WebsiteLinkedIn