Tech & Engineering
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.
- Use Pandas and NumPy extensively to analyze, tran