Automation Engineer II

GAINSCO • Richardson, TX

145d • Hybrid

About The Position

GAINSCO is seeking an Automation Engineer II to design, develop, and execute automated tests that ensure the reliability of data pipelines, ETL processes, and backend workflows. Working in an Agile environment, you’ll collaborate with developers, data engineers, and QA teams to support frequent releases and deliver accurate, consistent data for business insights.

Requirements

• Bachelor’s degree in Computer Science or a related field required.
• Minimum 5+ years developing automated test scripts using Java, JavaScript, or C#.
• At least 2+ years in Big Data or Data Warehouse testing; BI testing is a plus.
• Strong SQL experience required.
• Experience with Source Control Management (Git) and Azure DevOps.
• Proficiency with Selenium WebDriver or WebdriverIO.
• API testing experience (Postman or JMeter preferred).
• Knowledge of Power BI or Tableau.
• Excellent troubleshooting skills with a keen attention to detail.
• Outstanding written and oral communication skills.
• Ability to work collaboratively in a team environment.
• Exceptional organizational and time management skills.
• Self-driven with a comprehensive understanding of Enterprise SDLC processes.
• Commitment to delivering excellent customer service.
• Willingness to work occasional weekends and extended hours as required.
• Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity.

Nice To Haves

• BI testing is a plus.

Responsibilities

• Design, develop, and maintain automated test scripts and data validations using SQL and APIs.
• Enhance reusable automation frameworks for validating data pipelines and ETL processes.
• Perform source-to-target data validation and reconciliation across staging, ODS, and data warehouse layers.
• Troubleshoot and debug defects, collaborating with developers for timely resolution.
• Optimize existing automated scripts for scalability and efficiency.
• Document test scenarios, execution results, and communicate findings to stakeholders.
• Support BI validation for reports and dashboards to ensure accurate insights.
• Collaborate with Data Engineering and QA teams to implement enterprise data quality standards.
• Perform manual and exploratory testing as needed.

Benefits

• medical & dental
• vision insurance
• life insurance
• short-term and long-term disability insurance
• Parental Leave Policy
• 401K + Company Match
• PTO Plan + Paid Company determined Holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level