Quality Analyst (Data-focused)

Job Description

Quality Analyst:
On behalf of our Insurance client, Procom is searching for a Quality Analyst for a 6 month contract role. This position is a hybrid position with 2 days onsite at our client’s Waterloo office.

Quality Analyst - Job Description:
The Quality Analyst will be involved in designing, developing, and executing test strategies and plans to support a platform upgrade. The role involves ensuring data accuracy and integrity across systems and providing quality-focused input throughout the delivery lifecycle.

Quality Analyst - Responsibilities:
• Design, develop, and execute ETL and application test strategies, test plans, and detailed test cases based on business requirements, user stories, and technical design documents.
• Perform end-to-end data and application testing, including data validation, data completeness, data integrity, transformation logic verification, and reconciliation between source and target systems.
• Execute SQL-based validations to ensure accuracy and consistency of data across databases, data stores, and reporting layers.
• Validate data pipelines and integrations using modern platforms and tools (e.g., Azure-based services), covering functional, system integration, regression, smoke, and sanity testing.
• Develop and execute automated test scripts for data and application validation, including reusable checks for record counts, column-level validation, data types, and transformation rules.
• Identify, log, track, and manage defects using Azure DevOps or JIRA, ensuring timely retesting, verification, and closure.
• Support UAT and production validation activities, including investigation and resolution of production support tickets in collaboration with business and technology partners.

Quality Analyst - Mandatory Skills:
• Proficiency in SQL and Azure Synapse
• Knowledge of JSON file format
• Experience with Power BI
• Excellent documentation and communication skills
• Experience with creating and reviewing test plans with stakeholders
• Strong understanding of the QA lifecycle
• Ability to address blocks/defects with PM/Developers

Quality Analyst – Nice-to-Have Skills:
• Experience with Azure DevOps or JIRA
• Familiarity with regulatory, compliance, and control requirements
• Experience with data privacy and security standards
• Technical guidance and mentoring skills
• Continuous quality improvement initiatives

Quality Analyst – Assignment Length:
This is a 6 month contract position.

Quality Analyst - Start Date:
ASAP.

Quality Analyst - Assignment Location:
Waterloo, Ontario, Canada. This is a hybrid position with bi-monthly in-office requirements.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.