RiseMe
LoginSign Up
Holistic Partners, Inc logo
Holistic Partners, Inc Verified
Consulting, Business Services

Senior Automation Engineer

Mutual, Ohio, United StatesHybridContractSeniorPosted 2 months ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Seeking an experienced Sr. Automation Engineer with strong Data Warehouse (DWH) and automation expertise to support large-scale DWH cloud migration and modernization initiatives. The role involves defining test strategies, developing test plans, and leading execution across various testing types. Key responsibilities include hands-on Python development, API automation using frameworks like PyTest and Postman, CI/CD integration with tools like Jenkins and Azure DevOps, and extensive SQL for data validation. Experience with cloud data platforms (Snowflake, Databricks, BigQuery, Redshift) and NoSQL databases is required. The position also requires leading BPT and managing QE teams, operating in Agile/Hybrid environments.

Job Title
- Sr. Automation Engineer

Location
- Remote - Occasional Travel to
Frisco and San Antonio for Meetings

Duration
- 6+ Months contract

Interview Process
- Video

Job Description
:

Sr. Automation Engineer- Data Warehouse Supports

This is primarily a remote role; however, the candidate must reside within the DFW area and be available for occasional onsite visits to our Frisco and San Antonio offices.

This position has a potential conversion to FTE. Hence we are seeking candidates who are authorized to work in the U.S. without sponsorship (e.g., U.S. Citizens or Green Card holders).

Job Description:

We are seeking an experienced Sr Automation engineer in DWH, with strong Data and Automation expertise to support large-scale Data Warehouse (DWH) cloud migration and Modernization initiatives across complex enterprise platforms.

The ideal candidate will:

  • Define and drive a comprehensive test strategy, develop detailed test plans, and lead execution across functional, integration, data validation, API, and automation testing.
  • Bring deep hands-on expertise in Python, API automation, and modern data engineering testing practices, including building automation utilities using PyTest, Postman/Newman, or similar frameworks, and integrating them within CI/CD pipelines using Git, Jenkins, Azure DevOps, and GitOps-based automation.
  • Have strong working knowledge of cloud and data platforms such as relational DB ( Informatica Cloud IDMC, DVO, CDV, Snowflake, Databricks, BigQuery, or Redshift) and NoSQL DB like Cassandra, MongoDB Possess additional experience in real-time data streaming, messaging queues like Kafka, SQS etc.
  • Ability to test/automate these cases Strong working knowledge of building complex SQL queries and stored procedures for validations, data profiling, and complex data integration validations.
  • Demonstrate strong coordination and leadership skills, including leading Business Process Testing (BPT) with multiple upstream and downstream application teams at an enterprise scale, as well as managing onshore/offshore QE teams.
  • Be comfortable operating in fast-paced, multi-modal delivery environments (Waterfall, Agile, Hybrid), ensuring consistent, high-quality delivery across data, integration, and business workflows.
Ready to apply?
You'll be redirected to Holistic Partners, Inc's application page.

Similar roles