Role & seniority: Senior QA Analyst (lead on QA tasks for data/ETL initiatives)

Stack/tools: Azure Synapse, Azure Data Lake, SQL, ETL pipelines, stored procedures; Python; Data Factory/Synapse; DevOps concepts; data quality/testing docs

Top 3 responsibilities

Design, execute, and maintain data test plans, test cases, and validation scripts for Azure Synapse pipelines and data transformations; perform regression tests on modified pipelines/SPs/data models.
Validate and reconcile data across source systems, staging areas, and curated layers; collaborate with data engineers, ETL developers, and business analysts to resolve discrepancies.
Maintain QA documentation (test results, issue logs, validation procedures); support automated data quality checks and contribute to QA process improvements and DevOps testing integration.

Must-have skills

Strong written and verbal communication; ability to document and present test cases to stakeholders and developers
Experience creating test plans/cases/scripts from scratch; performing UAT, functional, regression, performance, and end-to-end testing
Ability to map requirements to test artifacts; familiarity with software and database concepts; experience on a software development team
Proficiency with QA documentation, defect tracking, and test data management
Familiarity with Scrum/Agile environments

Nice-to-haves

Experience with Data Factory/Synapse, SQL Server, PL/SQL, Oracle; stored p

Full Description

Position: QA Analyst

Location: Mississippi (Remote)

Duration: 3 years

Project Detail

The Mississippi Department of Education has a current goal for every community to effectively use a world-class data system to improve student outcomes. This goal has an outcome to increase the availability of quality data to drive decisions that improve student outcomes. MDE is planning to satisfy this goal in part by modernizing its current student information system along with improving the quality of data in connected systems. This will include web-based application development and the creation of dashboards and reports that will improve access, accuracy, and ease of use for all stakeholders.

Job Description

This position will require a qualified Quality Assurance Analyst to take the lead on the following tasks

Review and validate the output of SQL and ETL development to ensure data accuracy, consistency, and alignment with business rules.
Develop and execute detailed data 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 in Azure Data Lake or Synapse.
Conduct regression testing on modified pipelines, stored procedures, or data models to confirm that changes do not introduce new issues.
Collaborate with data engineers, ETL developers, and business analysts to document and resolve data discrepancies.
Maintain data QA documentation including test results, issue logs, and validation procedures.
Support the development of automated data quality checks or unit tests using SQL, Python, or other approved tools.
Contribute to continuous improvement of QA processes, data validation frameworks, and DevOps testing integration

Required Degree

Bachelor's degree

Required Skills

YEARS

Must be able to effectively communicate (verbally and written) test cases with stakeholders as well as the development team.

No min.

Must be able to collaborate with the Project Manager, Architect, Business Analyst, and developers to ensure test cases are communicated, accepted, and meet expectations.

Must be able to write test plans, test cases, and test scripts from scratch, validating that user expectations are achieved during the testing process.

Must be able to work closely with the Business Analysts to formulate test plans, prepare test cases, execute the tests, and fully document and report the results.