About This Job

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.

Position Name

Quality Analyst (Data-focused)