About the role

  • BI & ETL Tester validating data pipelines for global consulting client. Working onsite 2-3 days a week in downtown Toronto.

Responsibilities

  • Validate end-to-end ETL workflows including data extraction, transformation, and loading
  • Perform source-to-target data validation, record counts, reconciliation, schema checks, and transformation logic checks
  • Test data ingestion from multiple sources (databases, files, SAP, cloud platforms)
  • Verify scheduling, dependencies, and error-handling processes in ETL jobs
  • Conduct regression, functional, and sanity testing for data loads
  • Validate BI reports and dashboards for accuracy, formatting, filters, drill-downs, KPIs, and aggregations
  • Compare visual outputs with backend data using SQL queries
  • Test performance, data refresh cycles, row-level security, and report-level access
  • Write complex SQL queries to validate business rules, calculations, and data transformations
  • Identify data issues, anomalies, and integrity gaps
  • Create detailed test plans, test cases, test scenarios, and acceptance criteria
  • Perform manual testing and assist in setting up automated testing frameworks (e.g., Python, PyTest, dbt tests)
  • Document defects in tools like JIRA and follow through to closure

Requirements

  • 510+ years of BI/ETL testing or QA experience
  • Strong SQL skills (joins, window functions, aggregations, CTEs)
  • Experience testing ETL tools such as Airflow
  • Experience with BI tools: Power BI, SAP BO, etc.
  • Understanding of data warehousing (Star/Snowflake schema, dimensions, facts)
  • Knowledge of cloud data platforms (GCP is a plus)
  • Familiarity with Agile/Scrum methodology
  • Experience in defect management and test documentation tools

Benefits

  • Onsite work 2-3 days a week in downtown Toronto
  • Possible contract extensions

Job title

BI & ETL Tester

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job