Data Business Analyst

Saransh Inc; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading data solutions company in Toronto is seeking a Data Business Analyst with over 7 years of experience in Data Quality and Testing. The role involves developing test strategies for data pipelines in Azure and Databricks, performing data validation, and collaborating closely with Data Engineers. The ideal candidate will have strong skills in data QA, proficiency in SQL, and a hands-on approach to data profiling and reconciliation.

Qualifications

• 7+ years in Data Quality and Testing.
• Proven experience in data QA/validation in cloud-based platforms.
• Hands-on experience with data profiling, data reconciliation, and schema validation.

Responsibilities

• Develop and implement test strategies and automation scripts.
• Perform data validation, reconciliation, and comparative analysis.
• Collaborate with Data Engineers and Product Owners.

Skills

Data QA/validation in cloud-based platforms

Azure Data Factory

Databricks

SQL

Python

Data profiling

Data reconciliation

SCD Type 2

Azure DevOps

Data lineage tools

Job description

Role / Skills - Data Business Analyst

Location – Toronto, Canada

Location Options – On-site Day 1

7+ years in Data Quality and Testing

Key Responsibilities

• Develop and implement test strategies, test cases, and automation scripts to validate data pipelines in Azure and Databricks environments.
• Perform data validation, reconciliation, and comparative analysis between source and target systems.
• Validate ETL/ELT pipelines built using ADF and Databricks.
• Collaborate with Data Engineers and Product Owners to understand STM (Source-to-Target Mapping) and ensure transformation logic is correctly implemented.
• Monitor and validate data quality across Delta tables, and Data Warehouses.
• Identify data anomalies, document defects, and drive them to resolution with the engineering team.
• Support CI/CD pipelines by integrating data testing into DevOps workflows.
• Contribute to test data management, metadata validation, and regression testing.
• Provide regular reporting on test execution results, defect metrics, and QA health.

Required Skills

• Proven experience in data QA/validation in cloud-based data platforms.
• Strong knowledge of Azure Data Factory, Databricks.
• Proficiency in SQL and scripting languages such as Python.
• Hands‑on experience with data profiling, data reconciliation, and schema validation.
• Understanding of SCD Type 2 and data transformation logic.
• Familiarity with DevOps tools like Azure DevOps or GitHub Actions for CI/CD integration.
• Experience working with large datasets, performance testing, and data lineage tools.