Jobs via Dice
Job Title
QA Analyst
Job Location Tallahassee, FL (on-site)
Job Duration Contract through June + extension
Job Tasks and Activities 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 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 to reporting, ensuring business rules and transformations are correctly applied. The 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 such as 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.
Responsibilities
Analyze business requirements, ETL mapping documents, and data models.
Write and execute 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 Indicator (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, DBAs, and business users to resolve data‑related issues.
Mentor team members and ensure adherence to QA best practices.
Prepare test summary reports and present quality metrics to stakeholders.
Required Experience
A minimum of five (5) years of experience in systems development, testing, and/or business experience.
Technical Skills
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.).
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, ALM).
Experience with databases such as Oracle and SQL Server.
Preferred Experience
Industry certifications related to software testing, such as ISTQB, CSTE, CAST, and CSQA.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
#J-18808-Ljbffr
Job Location Tallahassee, FL (on-site)
Job Duration Contract through June + extension
Job Tasks and Activities 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 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 to reporting, ensuring business rules and transformations are correctly applied. The 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 such as 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.
Responsibilities
Analyze business requirements, ETL mapping documents, and data models.
Write and execute 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 Indicator (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, DBAs, and business users to resolve data‑related issues.
Mentor team members and ensure adherence to QA best practices.
Prepare test summary reports and present quality metrics to stakeholders.
Required Experience
A minimum of five (5) years of experience in systems development, testing, and/or business experience.
Technical Skills
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.).
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, ALM).
Experience with databases such as Oracle and SQL Server.
Preferred Experience
Industry certifications related to software testing, such as ISTQB, CSTE, CAST, and CSQA.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
#J-18808-Ljbffr