Job Description

Description: We are seeking a highly skilled and detail-oriented Software Systems Testing & Quality Assurance Specialist to join our project team. The ideal candidate will play a key role in ensuring the reliability, performance, and integrity of our health domain data platform. This role requires strong expertise in relational database systems, SQL, and a solid foundation in software testing methodologies. Experience with Python is a strong asset. Key Responsibilities: Design, develop, and execute comprehensive test plans and test cases for the health domain data platform. Perform functional, regression, integration, and performance testing. Validate data engineering activities, ensuring data quality, integrity and optimal performance. Write and optimize complex SQL queries for data validation and analysis. Collaborate with developers, business analysts, and stakeholders to understand requirements and ensure quality standards are met. Identify, document, and track software defects using appropriate tools. Contribute to continuous improvement of QA processes and automation strategies. Provide clear and conc ise documentation and reports on testing outcomes. Requirements Experience and Skill Set Requirements: Skill Set Requirements: Public Sector Experience: 5+ years of experience working in the federal/provincial/broader public-sector in the field of software systems development, testing or operations Analytical and communications skills: Excellent documentation skills , including the ability to produce clear and concise test plans, test cases, and test summary reports. Strong collaboration and communication skills , with the ability to work effectively with cross-functional teams including business stakeholders, developers, business analysts, architects and project managers. Strong analytical skills to interpret test results, identify root causes of issues, and recommend corrective actions. Data management Skills & Experience: 5+ years of experience in data management Demonstrated experience in designing, developing or maintaining relational database management systems. Strong knowledge of relational database systems (e.g., SQL Server, Oracle, PostgreSQL). Advanced proficiency in SQL for data analysis and validation. Experience with Python for scripting and automation is an asset. Quality Assurance Skill & Experience: 10+ years of experience in quality assurance and software system testing: Extensive experience in software systems testing , including functional, regression, integration, system, and performance testing across complex enterprise applications. Strong understanding of software development life cycle (SDLC) and quality assurance methodologies, including Agile, Waterfall, and hybrid models. Proficiency in test planning and strategy development , including risk-based testing approaches and test coverage analysis. Hands-on experience with test automation tools (e.g., Selenium, PyTest) and scripting for automated test execution. Expertise in defect tracking and management , using tools such as JIRA or Azure DevOps, with a strong ability to triage and prioritize issues. Ability to design and execute test cases based on business requirements, technical specifications, and user stories. Experience with API testing using tools like Postman, SoapUI, or REST-assured is an asset Knowledge of performance testing tools such as JMeter or LoadRunner is an asset. Experience in test data management , including data creation, masking, and validation in relational database environments. Comfortable working with CI/CD pipelines and integrating testing into automated build and deployment processes.