Quality Assurance Data Engineer

GENERAL SUMMARY

The QA Data Engineer will design and execute automated tests, set up monitoring alerts, and perform manual verifications to ensure the quality and reliability of data engineering projects such as ETL pipelines, reports, business intelligence dashboards, and data management applications. This role is essential to delivering trusted data solutions that drive business insights and decisions.

ORGANIZATIONAL RELATIONSHIP

Under the general supervision of the Manager of QA, the QA Data Engineer works closely with developers in the Data Engineering team.

DUTIES & RESPONSIBILITIES

-    Develop comprehensive test plans and test cases as part of project planning and execution.

-    Create and maintain automated tests to validate project requirements and functionality.

-    Schedule and manage automated test runs, ensuring consistent and reliable execution.

-    Define and develop key performance indicators (KPIs) for measuring the effectiveness of test automation.

-    Collect, consolidate and analyze test automation results to identify trends and patterns.

-    Write and optimize SQL queries for use in automated tests and monitoring alerts.

-    Assist with the verification and recreation of user-reported issues.

-    Work collaboratively with engineers to troubleshoot defects and validate fixes.

-    File detailed and actionable defect reports, including recreate steps and expected outcomes.

-    Continuously improve QA processes, frameworks, and tools to align with best practices.

QUALIFICATIONS

•    3+ years of experience in writing automated QA tests, including data-focused testing.

•    Experience in manual testing and working in iterative development cycles.

•    Strong proficiency in writing complex SQL queries from scratch.

•    Proficient in at least one scripting or programming language (e.g., Python, JavaScript, C#, etc.).

•    Familiarity with test automation frameworks and tools such as Selenium.

•    Excellent analytical and problem-solving skills with a high level of attention to detail.

•    Strong communication and collaboration skills to work effectively with cross-functional teams.

•    Experience with CI/CD pipelines and version control systems (e.g., Jenkins, Git).

•    Knowledge of business intelligence tools such as Power BI or Tableau.

•    Understanding of Agile development processes.

WORKING CONDITIONS

This role follows a hybrid working model, with a base out of one of the following Preferred Travel Group office locations: Chicago, IL; or Newport Beach, CA. Associates are generally expected to work from the office 2-3 days per week, allowing for a balance of in-person collaboration and flexible remote working. Office space is beautifully as well as functionally decorated including all required technology tools. Remote work-from-home opportunities will be considered for candidates located more than 50 miles from the abovementioned office locations. Employee is seated most of the time. 

REQUIRED TRAINING

1.    Orientation via some live remote and some pre-recorded video sessions

2.    IT security training

3.    Internal development process and procedures

DISCLAIMER

The above information on this description has been designed to indicate the general nature and level of work performed by associates within this classification.  It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

Salary range: USD $55,000-75,000 annually; actual compensation within this range will be determined by multiple factors including candidate location, experience and expertise.