Quality Assurance Analyst evaluating and testing software programs at SHAZAM. Leading QA activities and mentoring analysts while ensuring software quality.
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
Quality Assurance Lab Technician ensuring product quality for specialty chemicals at Rochester Midland. Conducting inspections and calibrating laboratory instruments to meet company specifications.
Installation Technician providing services on security system products at customer locations. Overseeing subcontractor teams and resolving post - installation issues.
QA Technician ensuring all manufactured products meet stringent quality standards at Vibrant Ingredients. Collaborating with teams to implement corrective actions and continuous improvements.
QA Engineer 2 ensuring world - class systems and performance through process improvement and customer satisfaction at ABBA Roller. Requires extensive experience in a regulated manufacturing environment.
Display Quality Engineer leading quality and warranty analysis for interior displays. Driving improvements and collaborating with engineers at Ford to enhance product quality.
RN - Quality Assurance focused on quality initiatives supporting compliance within PHS Oregon. Primarily onsite role with occasional hybrid (remote) work.
POS Tester for a global consulting leader in technology and engineering services. Responsible for executing test cases and validating POS applications throughout the testing lifecycle.
Expert Patient Access Representative at Cedars - Sinai handling admissions, registrations, and financial clearances. Responsible for patient demographics and insurance verifications.
Quality engineer coordinating and supporting investigations of complaints for mechatronic products. Engaging in process improvements and documentation at SEW - EURODRIVE in Germany.