The Quality Assurance Analyst will validate SQL and ETL outputs, develop test plans, conduct regression and user acceptance testing, and collaborate with stakeholders to improve QA processes.
Job Title: Quality Assurance Analyst – SME Level (Remote)
Location: Jackson, MS
Duration: 3 Years
Job Description:
This position will require a qualified Quality Assurance Analyst to take the lead on the following tasks:
REQUIRED SKILLS/EXPERIENCE
Preferred Skills / Must also meet minimum requirements
Location: Jackson, MS
Duration: 3 Years
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 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, Technical Use Cases and Test Plan, User stories, etc.
- Must be able to review user requirements to ensure that requirements are testable.
- Must be able to create diagrams, flowcharts, and workflows of data flow through systems.
- Must be able to create and manage test cases for Quality Assurance.
- Must be familiar with software and database development concepts.
- Must have experience as a Quality Assurance Analyst working on a software development team.
- Must have strong experience in QA management and creating all documents listed above.
- Must have strong experience in mapping business processes into test case documentation.
- Must understand software quality best practices, test strategy and planning, test case development, test case deployment and execution, test data, defect tracking, and test manuals. Must actively participate in process improvements.
- Strong experience in acceptance testing
- Ability to analyze business functions
- Scrum
- Agile
Preferred Skills / Must also meet minimum requirements
- 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#
Top Skills
Azure Data Lake
Azure Synapse
C#
Data Factory
DevOps
Oracle
Pl/Sql
Python
SQL
SQL Server
Similar Jobs
Financial Services
The Quality Assurance Analyst ensures accurate processing of transactions, identifies inefficiencies, supports quality control, and collaborates with teams to improve processes.
Top Skills:
ExcelMs-OfficePowerPointWord
Gaming • News + Entertainment • Sports • Esports
As a Senior Quality Assurance Analyst, you will oversee testing processes, risk management, and quality evaluation for Last Epoch, ensuring a bug-free player experience.
Top Skills:
ConfluenceIssue Tracking DatabasesUnity
32 Seconds Ago
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead the Strategy and Planning team for the STEP organization, managing cross-functional collaboration and integrating AI into strategic decision-making.
Top Skills:
Advanced AnalyticsAI
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
