Data Engineer

Capco; Toronto; On-site; CAD 92,000 - 118,000; Full time

Benefits offered by this job

Healthcare & life insurance

RRSP with employer matching

Virtual health care

Employee & Family Assistance Program

Parental leave and wellbeing benefits

Job summary

Capco, in Toronto, is seeking a hands-on Data Engineer to validate, reconcile, and analyze large datasets using Python, Pandas, and NumPy, delivering reliable data quality checks for financial services clients.

You will work with cross-functional teams to develop scalable pipelines, create reports, and continually improve data processing workflows, while focusing on data validation and transformation to drive trusted insights.

Qualifications

• 3-5+ years of experience in Data Engineering, Data Analytics, or Data Quality Engineering.
• Strong hands-on experience with Python, Pandas, NumPy, and SQL.
• Experience working with large structured datasets.
• Experience comparing and reconciling data from multiple sources.

Responsibilities

• Validate and reconcile two or more datasets simultaneously.
• Build Python-based data validation and comparison frameworks.
• Use Pandas and NumPy extensively to analyze, transform, and validate large datasets.
• Develop automated processes to identify missing, duplicate, or inconsistent data.
• Investigate data quality issues and determine root causes.
• Create reports highlighting discrepancies and data quality metrics.
• Collaborate with business, analytics, and engineering teams to resolve data issues.
• Optimize large-scale data processing workflows.
• Receive data extracts from multiple systems.
• Load and process large datasets using Python, Pandas, and NumPy.
• Compare datasets to identify gaps, inconsistencies, and anomalies.
• Build validation rules and automated quality checks.
• Investigate data issues and communicate findings to stakeholders.
• Create reusable scripts and frameworks for ongoing validation activities.
• Support data migration, onboarding, and integration projects.

Skills

Python

Pandas

NumPy

SQL

Data validation

Tools

PySpark

Azure Data Factory

Databricks

Power BI

Git

CI/CD

Cloud platforms (Azure, AWS, GCP)

Job description

Capco is looking for a Consultant, Data Engineer to join our Technology & Engineering practice in Toronto. This is an exciting opportunity for an analytical professional who enjoys solving complex data challenges, validating large datasets, and delivering high-quality insights for leading financial services clients.

Working alongside multidisciplinary teams, you will help ensure the integrity, accuracy, and consistency of critical business data, enabling successful technology delivery and informed decision-making.

The Data Engineer will have strong Python, Pandas, and NumPy expertise to support data validation, reconciliation, and processing of large datasets. This role focuses on comparing multiple datasets, identifying data quality issues, automating data validation workflows, and supporting analytics initiatives. This is a hands‑on engineering role with a strong emphasis on Python-based data processing and data quality management.

What We're Looking For

Programming & Data Processing

• Python (3+ years of hands‑on experience)
• Pandas (Advanced)
• NumPy (Advanced)
• SQL

Data Engineering & Analytics

• Experience processing and validating large datasets (millions of records)
• Data reconciliation and dataset comparison
• Data cleansing and transformation
• Data quality analysis and validation
• ETL/Data Pipeline fundamentals
• Root cause analysis of data discrepancies

Key Responsibilities

• Validate and reconcile two or more datasets simultaneously.
• Build Python‑based data validation and comparison frameworks.
• UsePandas and NumPy extensivelyto analyze, transform, and validate large datasets.
• Develop automated processes to identify missing, duplicate, or inconsistent data.
• Investigate data quality issues and determine root causes.
• Create reports highlighting discrepancies and data quality metrics.
• Collaborate with business, analytics, and engineering teams to resolve data issues.
• Optimize large-scale data processing workflows.

Experience Required

• 3-5+ years of experiencein Data Engineering, Data Analytics, or Data Quality Engineering.
• Strong hands‑on experience with:
• Python
• Pandas
• NumPy
• SQL
• Experience working with large structured datasets.
• Experience comparing and reconciling data from multiple sources.

Day‑to‑Day Activities

• Receive data extracts from multiple systems.
• Load and process large datasets usingPython, Pandas, and NumPy.
• Compare datasets to identify gaps, inconsistencies, and anomalies.
• Build validation rules and automated quality checks.
• Investigate data issues and communicate findings to stakeholders.
• Create reusable scripts and frameworks for ongoing validation activities.
• Support data migration, onboarding, and integration projects.

Nice to Have

• PySpark
• Azure Data Factory
• Databricks
• Power BI
• Git
• CI/CD
• Cloud platforms (Azure, AWS, GCP)

Ideal Candidate

A hands‑on Data Engineer with strongPython, Pandas, and NumPyexpertise who can efficiently validate, reconcile, and analyze multiple large datasets while building automated solutions to improve data quality and consistency.

Why Join Capco

• Deliver high‑impact technology solutions for Tier 1 financial institutions.
• Work in a collaborative, flat, and entrepreneurial consulting culture.
• Access continuous learning, training, and industry certifications.
• Be part of a team shaping the future of digital financial services.
• Help shape the future of digital transformation across financial services.

Benefits

• Comprehensive Benefits Coverage – 100% company‑paid health, life, and disability insurance effective from Day 1 of employment.
• Retirement Savings Program – Registered Retirement Savings Plan (RRSP) with the option of receiving a matching employer contribution.
• Virtual Health Care – Company‑paid program available to all employees and their dependents/partners.
• Employee & Family Assistance Program (EFAP) – Company‑paid support services for employees and their dependents/partners.
• Additional support including enhanced parental leave, wellness reimbursement, a Business Coach from Day 1, and other employee wellbeing benefits.

Inclusion at Capco

We’re committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know—we’ll be happy to help. We value each person’s unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration—a mindset that shapes how we work with clients and each other every day.

Use of Artificial Intelligence in Talent Acquisition

At Capco, we use artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI‑enabled features within LinkedIn to help source potential candidates, speeding up routine recruitment communications such as emails and creating compelling and brand‑aligned job postings that accurately reflect role requirements, and AI‑scheduling applications to improve the efficiency of interview coordination.

AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.

Why This Role Is Open

We are currently hiring for this role due to an existing or newly created vacancy within our organization. This position is open as part of our ongoing business needs, and we are actively reviewing applications to fill this role with a qualified candidate who can make an immediate impact.

Pay Transparency

The salary range for this position is listed below. Additionally, this position may also be eligible to receive an annual discretionary/variable bonus payment.

Capco is committed to providing fair and equitable compensation to our people. Our compensation policies and salary ranges are designed to allow our people to progress through the salary range as they demonstrate strong performance and develop in their role over time. The base pay offered to selected candidates will be within the salary range and the placement will vary based upon a variety of factors, including, but not limited to job‑related knowledge, skills, experience and internal equity.

Canada Pay Transparency

$92,000—$118,000 CAD