Project Management jobs in Canada
Consultant(e) en Mise en Oeuvre sur le Terrain
Lightspeed Commerce (FR)
Discover more opportunities than anywhere else. Find more jobs nowSoftware Development Manager - Lead ML Platforms (4-Day Week)
CARFAX
Connect with headhunters to apply for similar jobsGestionnaire de Projet – Ingénierie Civile (Fly‑In/Fly‑Out)
Place aux Jeunes
Assistant.e chargé.e de projet – Ingénieur.e civil.e - Fly-in/Fly-out
Place aux Jeunes
Construction Scheduler: Master Plans & 4D Scheduling
PCL Construction
Coordonnateur.rice, communications et marketing numérique - (contrat de 12 mois) - salaire jusq[...]
Uman recrutement
Postdoctoral Fellow Position in Standoff Quantum Sensing
University of Alberta
BI & ETL Tester - Hybrid
Job summary
A global SAP consulting firm is seeking a BI & ETL Tester to validate and analyze data pipelines and BI reports. The role includes responsibilities for ETL testing, SQL validations, and collaborating with data teams. Candidates should have strong QA experience, SQL skills, and familiarity with BI tools like Power BI and SAP BO. This is a hybrid position based in Toronto with a contract duration of 6-12 months.
Qualifications
- 510+ years of BI/ETL testing or QA experience.
- Strong SQL skills (joins, window functions, aggregations, CTEs).
- Experience with BI tools such as Power BI, SAP BO.
Responsibilities
- Validate end-to-end ETL workflows including data extraction, transformation, and loading.
- Perform source-to-target data validation, record counts, reconciliation, and schema checks.
- Create detailed test plans, test cases, test scenarios, and acceptance criteria.
Skills
Tools
Software International (SI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to small and mid-sized organizations in Canada/US and Europe.
We currently have a multiple, re-extendable, long term contract role as a BI & ETL Tester - Hybrid with our global SAP consulting client, working onsite at large CPG/Entertainment client's office 2-3 days a week in downtown Toronto. This is a 6 month contract initially, but will be extended long term.
Role: BI & ETL Tester - Hybrid
Type: Contract
# of Roles: 1
Duration: 9-12 months to start + possible extensions
Location: Toronto, ON - Hybrid, 2-3 days onsite in downtown Toronto
Rate: Open based on expectations as a C2C contractor
We are seeking a skilled BI & ETL Tester to validate, analyze, and ensure the accuracy, performance, and reliability of data pipelines, BI reports, dashboards, and analytics solutions. The ideal candidate will have strong experience in data validation, SQL, ETL process testing, and working with modern data platforms.
1. ETL / Data Pipeline Testing
- 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.
2. BI / Reporting Testing
- 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.
3. SQL & Data Quality Validation
- Write complex SQL queries to validate business rules, calculations, and data transformations.
- Identify data issues, anomalies, and integrity gaps.
- Collaborate with Data Engineers, BI Developers, and Data Analyst to resolve defects.
4. Test Planning & Execution
- 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.
- Participate in sprint planning, reviews, and Agile ceremonies.
- 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.
- Experience with SAP source systems (SAP ECC, S/4HANA, SAP BW, SAP IBP) for data validation.
- Exposure to big data technologies (BigQuery).
- Automation experience using Python or SQL-based frameworks.
- Knowledge of CI/CD pipelines for data testing.
- Experience with version control (Git).
- Strong analytical and problem-solving abilities.
- Excellent communication with business and technical teams.
- Ability to work independently and manage multiple assignments.
- Detail-oriented with a focus on data accuracy and quality.
* The salary benchmark is based on the target salaries of market leaders in their relevant sectors. It is intended to serve as a guide to help Premium Members assess open positions and to help in salary negotiations. The salary benchmark is not provided directly by the company, which could be significantly higher or lower.