Quality Assurance Analyst, Advanced

Advanced Systems Design is seeking a Quality Assurance Analyst, Advanced for  our client located in Tallahassee, FL.

This position is onsite in Tallahassee, FL, and requires in-person availability starting day 1. 

This position also requires in-person interviews before selection.

Job Overview:

The Quality Assurance (QA) Analyst is responsible for developing and executing formal test plans to ensure the accuracy, consistency, and reliability of data processed through Extract, Transform, Load (ETL) pipelines and stored in the data warehouse for reporting and analytics. The QA Analyst validates the data flow from source to staging, to warehouse, and to reporting, ensuring that business rules and transformations are correctly applied. This role involves test planning, writing test cases/scripts, and executing tests to verify data integrity and system functionality. The QA Analyst defines and tracks Testing and QA metrics, including defects, defect counts, test results, and test status. The QA Analyst also collects and analyzes data for process evaluation, integrates findings into business processes, documents defects, and assists in their resolution. The QA Analyst delivers quality process and tools training to technical and business staff and serves as an internal quality consultant to advise or influence business or technical partners. The duties and responsibilities of this position are as follows:

• Analyze business requirements, ETL mapping documents, and data models;
• Write and execute Structured Query Language (SQL) queries to validate data;
• Test ETL jobs: extraction, transformation, and loading into target tables;
• Validate fact and dimension tables (keys, measures, attributes);
• Perform data reconciliation between source and target systems.
• Check data quality (nulls, duplicates, invalid values, referential integrity);
• Verify aggregations, derived columns, and business logic;
• Test BI reports/dashboards against data warehouse tables;
• Work with developers, analysts, and DBAs to resolve defects;
• Automate regression and sanity testing where possible.
• Collaborate with the QA Lead/Manager to develop test strategies and test plans for Data Warehouse (DWH)/ETL Projects;
• Review ETL mappings, data models, and business rules with architects and analysts;
• Perform source-to-target mapping validation and data transformation testing;
• Conduct data reconciliation between multiple layers: source systems, staging, Operational Data Store (ODS), and data warehouse;
• Validate fact/dimension integrity, business rule implementation, and Key Performance Indicators (KPIs) in reports;
• Perform performance and scalability testing of ETL jobs and SQL queries;
• Implement automation frameworks for regression testing and data validation;
• Collaborate with developers, Database Administrators (DBAs), and business users to resolve data-related issues;
• Mentor team members and ensure adherence to QA best practices; and
• Prepare test summary reports and present quality metrics to stakeholders.

Required Qualifications:

• A minimum of five (5) years of experience in systems development, testing, and/or business experience.
• Strong SQL skills (joins, aggregations, window functions);
• Strong understanding of Data Warehouse concepts, testing methodologies (manual and automated), and different types of testing (business process, functional, integration, regression, performance, security, etc.); and
• Ability to define test plans, test cases, test execution, defect management, and reporting in an enterprise application development environment; Basic Unix/Linux skills for job monitoring and log analysis.
• Hands-on experience with ETL tools, BI/Reporting tools, and test management tools (e.g., JIRA, Application Lifecycle Management [ALM]); and
• Experience with databases such as Oracle and SQL Server.
• Ability to analyze complex issues, identify root causes, and propose effective solutions.
• Excellent communication and interpersonal skills to effectively collaborate with team members and stakeholders.
• Keen eye for detail to identify even minor defects, using prior experiences and lessons learned.
• Ability to evaluate information, assess risks, and work with the project team to make sound judgments.
• Ability to prioritize tasks, manage time effectively, and meet project internal milestones and deadlines.

Preferred Qualifications:

• Industry certifications related to software testing, such as International Software Testing Qualifications Board (ISTQB), Certified Software Tester (CSTE), Certified Associate in Software Testing (CAST), and Certified Software Quality Analyst (CSQA).

Education Required:

• A bachelor's degree from an accredited college or university in Computer Science, Information Systems, Technical Writing, Business Administration, or a related field, or five (5) years of equivalent work experience is required. Relevant experience may be substituted for education on a year-for-year basis when applicable.

Advanced Systems Design, Inc. is:

• A leading Information Technology provider for Federal, State & Local government agencies.
• A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.
• A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful, innovative solutions for our government customers.
• A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988. 
• Applicants who have a signed offer of employment or contractor agreement are subject to:
  • the pre-employment testing protocol:
    • background investigation
    • drug screening

Our Employees:

• Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC, and a wide array of Federal, State, and Local agencies throughout the United States
• Are eligible for wide-ranging benefits and perks, including but not limited to:
  • Comprehensive Health Insurance with PPO and HDHP/HSA options
  • Dental Insurance
  • Vision Insurance
  • Short/Long-Term Disability
  • Group Life Insurance - Company Paid
  • Voluntary Life Insurance
  • 401(k) Plan with Employer Match
  • Paid Time Off (Vacation/Sick)
  • Holiday Pay - Company Paid Federal Holidays
  • Tuition Assistance
  • Professional Certification Incentive Plan
  • Employee Referral Plan
  • Technology Exposure

For additional information regarding Advanced Systems Design, please check out our WEBSITE or click HERE for all current job openings.

Advanced Systems Design is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.