Full Description

Quality Assurance Analyst – SME Level

location: Jackson, MS

Duration: 12 months

Position type: Contract.

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

Tasks

Job Duties

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.

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

Required Skills/Experience

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

development team.

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.

Must be able to perform user acceptance testing, functionality testing, regression testing, performance testing, and

end-to-end system testing on various applications. Documentation includes: Formal Test Plan, Test Case Document,