Quality Assurance Analyst (On-site)

Join Our Team

Do you want to make an impact on the world around you? The work we do at Kyra Solutions directly impacts government entities and the citizens they serve. In Transportation practice, our solutions are designed to save lives on the roadways and in our Regulatory practice, we are designing solutions to make government digital for your accessibility. Kyra works hard to offer long-term growth potential, competitive wages, and continuous professional development for our employees.

If you are interested in furthering your career with Kyra and help us improve the way governments serve their citizens, please send your resume, and make sure to include salary expectation, availability, and contact information. You do not want to miss this opportunity!

Title

Quality Assurance Analyst (On-site)

Required Skills and Experience

* Minimum of 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.)
* 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])
* 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 Skills and Experience

* 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).

Primary Responsibilities

* 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 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, Database Administrators (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.

Education

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

Location

Tallahassee, FL

Duration

Long-Term

Why Kyra?

Founded in 1997, Kyra Solutions is a national leader of transportation technology and regulatory solutions in government. We specialize in the art and science of digital transformation in government. Our commitment to providing the highest level of service and tailored solutions has supported our consistent double-digit growth for over a decade. We are headquartered in the greater Tampa Bay area with other offices across Florida and an innovation center in Silicon Valley, CA.

Because of our dedication to our employees, we have won one of the Best Companies to Work for in Florida 3 years in a row by Florida Trend magazine. Kyra has won other numerous awards including the coveted INC magazine s one of America s Fastest Growing Companies several years in a row. Kyra's commitment to our employees, to best practices in project management and business analysis, and to solution development has led to our achievement in becoming the first Project Management Institute certified company in Florida. Our proven successful track record has resulted in several prestigious awards including the State of Florida's Diversity Business of the Year Award. We are proud to be a sponsor for the TaxWatch Productivity Awards and partner to Florida TaxWatch.

Background & References

Verifiable professional references will be required along with the resume; however, references will be checked/contacted after the interview and before the project starts. Level two background check will be done on the selected candidate for employment, criminal (State & Federal), education, and others as mandated by the client. Please make sure your resume and all other information provided are accurate. Any misrepresentation will mean permanent disqualification by the client. Equal employment opportunity employer.