Advanced Associate managing assessment content production for General Qualifications portfolio working with external associates to ensure high - quality assessments on deadlines.
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
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
QA Engineer implementing AI - assisted testing to maintain quality standards at Podimo, a podcast and audiobook platform. Collaborating across teams using E2E automation in a hybrid work environment.
Quality Assurance Analyst ensuring product quality for Viamericas, a leading money transmitter. Focused on developing tests for web and windows applications, enhancing software quality and functionality.
Quality Assurance Engineer ensuring software quality for fintech startup dopay. Focusing on testing methodologies and collaboration with development teams in Cairo.
Quality Assurance Analyst ensuring quality, reliability, and usability of applications at Air Apps. Collaborate with product managers, developers, and designers to deliver high - performing user experiences.
QA Engineer ensuring quality and performance in mobile applications at Air Apps. Collaborating with teams to build robust automated tests and improve user experience.
QA Engineer ensuring quality, reliability, and performance of mobile applications. Collaborating with cross - functional teams to improve user experience at Air Apps.
Quality Assurance Analyst validating mobile and web application quality for AI - powered resource planner at Air Apps. Collaborating cross - functionally to ensure high - performing user experiences.
Frontend QA Engineer ensuring quality of user interface for TradingView’s platform used by millions. Collaborating on testing processes to enhance product stability and user experience.
Business Test Analyst focusing on testing data solutions within an insurance tech company. Validating functional behavior and collaborating with product, analysis, and engineering teams in a hybrid set - up.