Data & Databricks Test Automation Engineer

The Citco Group Limited; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading financial services firm in Toronto is seeking a qualified candidate for a role focusing on Databricks testing and AWS integration. You will be responsible for automating testing processes for data pipelines and ensuring data quality through robust testing strategies. The ideal candidate has a Bachelor's degree in Computer Science or a related field along with strong skills in Python and SQL. Our company values diversity and offers a range of benefits to support your career and wellbeing.

Benefits

Flexible working arrangements

Training and education support

Diversity and inclusion initiatives

Qualifications

• 2+ years hands-on experience with Databricks (Spark).
• Relevant certifications in Databricks or data testing are a plus.
• Strong programming skills in Python (PySpark) and SQL.

Responsibilities

• Design and implement automated testing for Databricks notebooks and workflows.
• Create test frameworks for Delta Lake tables and ACID transactions.
• Develop automated validation for structured streaming pipelines.

Skills

Databricks (Spark)

Python (PySpark)

SQL

Data testing frameworks

AWS services

Analytical skills

Education

Bachelor's degree in Computer Science, Data Science, or related field

Tools

Git

MLflow

Job description

Responsibilities

1. Databricks Testing

• Design and implement automated testing for Databricks notebooks and workflows
• Create test frameworks for Delta Lake tables and ACID transactions
• Develop automated validation for structured streaming pipelines
• Test MLflow integrations and model tracking
• Validate Delta Live Tables implementations

2. Data Pipeline Testing

• Automate testing for ETL / ELT processes in Databricks
• Implement Spark job testing and optimization validation
• Create test cases for data ingestion and processing workflows
• Develop automated checks for data transformations
• Test Unity Catalog features and access controls

3. AWS Integration Testing

• Implement automated testing for Databricks-AWS integrations
• Create test cases for S3, Glue catalog, and Lambda functions
• Validate data lake storage and access patterns
• Test secure networking configurations

4. Quality Assurance

• Design and execute data quality test strategies
• Implement automated data reconciliation processes
• Develop performance testing for large-scale Spark jobs
• Create cluster configuration testing

5. Monitoring & Reporting

• Implement pipeline monitoring test frameworks
• Create automated test dashboards
• Generate quality metrics and testing reports
• Maintaincomprehensive test documentation

Qualifications

1. Educational Background

• Bachelor's degree inputer Science, Data Science, or related field
• Relevant certifications in Databricks or data testing are a plus

2. Technical Experience

• 2+ years hands-on experience with Databricks (Spark)
• Strong programming skills in Python (PySpark) and SQL
• Experience with data testing frameworks and tools
• Knowledge of AWS services (S3, Glue, Lambda)
• Understanding of Delta Lake and Lakehouse architecture
• Experience with version control systems (Git)

3. Additional Skills

• Strong analytical and problem-solving abilities
• Experience with large-scale data processing
• Knowledge of data quality best practices
• Understanding of dataernance andpliance requirements
• Experience with Agile methodologies

4. Platform Knowledge

• Databricks workspace and notebook development
• Delta Lake and Delta Live Tables
• MLflow for ML pipeline testing
• Unity Catalog forernance testing
• Spark optimization and performance testing

Our Benefits

Your well being is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We embrace diversity, prioritizing the hiring of people from diverse backgrounds. Our inclusive culture is a source of pride and strength, fostering innovation and mutual respect.

Citco wees and encourages applications from people with disabilities. Amodations are available upon request for candidates taking part in all aspects of the selection. Job ID 300001583033600