Jobs via Dice
Quality Assurance Analyst SME Level
Jobs via Dice, Jacksonville, Florida, United States, 32290
Project Scope
The Mississippi Department of Education aims to modernize its current student information system to improve data quality and provide actionable insights. This involves web‑based application development, dashboards, and reports that enhance data accessibility, accuracy, and usability across stakeholders.
Roles/Responsibilities
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.
Mandatory Skills
Effective verbal and written communication of test cases with stakeholders and the development team.
Collaboration with the Project Manager, Architect, Business Analyst, and developers to ensure test cases are communicated, accepted, and meet expectations.
Creation of test plans, test cases, and test scripts from scratch, validating that user expectations are achieved during the testing process.
Close working relationship with Business Analysts to formulate test plans, prepare test cases, execute the tests, and fully document and report the results.
Execution of 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, Technical Use Cases, and User Stories.
Strong experience in acceptance testing.
Ability to analyze business functions.
Experience with Scrum and Agile methodologies.
Desirable Skills
Database Entity Design
Samples of previous documents created (strongly preferred)
PL/SQL
Data Factory/Synapse
SQL Server
DevOps
Oracle
Stored Procedures
Visio
Software Development Life Cycle
Scrum / Agile
C#
Seniority Level
Mid‑Senior level
Employment Type
Full‑time
Job Function
Quality Assurance
Industries
Software Development
#J-18808-Ljbffr
Roles/Responsibilities
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.
Mandatory Skills
Effective verbal and written communication of test cases with stakeholders and the development team.
Collaboration with the Project Manager, Architect, Business Analyst, and developers to ensure test cases are communicated, accepted, and meet expectations.
Creation of test plans, test cases, and test scripts from scratch, validating that user expectations are achieved during the testing process.
Close working relationship with Business Analysts to formulate test plans, prepare test cases, execute the tests, and fully document and report the results.
Execution of 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, Technical Use Cases, and User Stories.
Strong experience in acceptance testing.
Ability to analyze business functions.
Experience with Scrum and Agile methodologies.
Desirable Skills
Database Entity Design
Samples of previous documents created (strongly preferred)
PL/SQL
Data Factory/Synapse
SQL Server
DevOps
Oracle
Stored Procedures
Visio
Software Development Life Cycle
Scrum / Agile
C#
Seniority Level
Mid‑Senior level
Employment Type
Full‑time
Job Function
Quality Assurance
Industries
Software Development
#J-18808-Ljbffr