Job Title : Quality Assurance Analyst

Location: Jackson, MS, Remote

Rate : Best competitive rate 

Project Overview – OTSS Project

The client is committed to providing every community with a world-class data system that supports improved student outcomes. To achieve this, MDE is modernizing its student information system and enhancing the quality of connected data systems. This initiative includes developing web-based applications, dashboards, and reports that improve data accessibility, accuracy, and usability for all stakeholders.

Position Summary

The Quality Assurance Analyst (SME Level) will play a critical role in ensuring data integrity and accuracy across MDE’s enterprise data modernization efforts. The ideal candidate will have extensive experience validating data pipelines, testing complex data transformations, and collaborating with cross-functional teams in Agile environments.

Key Responsibilities

• Validate the output of SQL and ETL development to ensure data accuracy, consistency, and compliance with business rules.
• Develop and execute detailed test plans, test cases, and validation scripts targeting Azure Synapse pipelines, stored procedures, and data transformations.
• Reconcile data between source systems, staging areas, and curated data layers within Azure Data Lake or Synapse.
• Conduct regression, performance, and user acceptance testing to ensure system stability and reliability.
• Collaborate with data engineers, developers, and business analysts to document and resolve data discrepancies.
• Maintain QA documentation, including test plans, issue logs, and validation procedures.
• Support the development of automated data quality checks using SQL, Python, or similar tools.
• Contribute to continuous improvement of QA frameworks, testing processes, and DevOps integration.

Required Education

• Bachelor’s degree (in Computer Science, Information Systems, or a related field preferred)

Required Skills and Experience

Skill/Experience

Years

QA collaboration and communication with technical and non-technical stakeholders

7+

Writing and executing detailed test plans, cases, and scripts

7+

Performing UAT, regression, performance, and end-to-end testing

7+

Reviewing user requirements for testability and traceability

7+

Creating flowcharts, workflows, and data flow diagrams

7+

Strong experience in QA management and documentation

7+

Mapping business processes into test documentation

7+

Working in Agile/Scrum environments

7+

Experience with database and software development concepts

7+

Preferred Skills

• Database Entity Design
• SQL Server / PL/SQL / Oracle
• Azure Data Factory / Synapse
• DevOps experience
• C# and Stored Procedure development
• Experience with Software Development Life Cycle (SDLC)
• Microsoft Visio
• Experience creating and maintaining technical documentation and samples

Submission Requirements

• Three (3) professional references including name, title, company, role, contact number, and email.
• Samples of previous QA documentation (e.g., test plans, test cases, reports) are strongly preferred.
• Additional required documents must be uploaded with the resume.