Start searching
Back to Jobs
Technology

ETL QA Engineer

AspireIT SolutionsPortland, OR🇺🇸United States

Why this role stands out

Advance your career with AspireIT Solutions as an ETL QA Engineer, where you will play a pivotal role in ensuring data integrity within cutting-edge Snowflake environments while enjoying the flexibility of a hybrid work arrangement. This position is perfect for a detail-oriented professional who thrives on complex database testing and wants to make a measurable impact on data reliability. Apply today to join a team that values your technical expertise and offers a clear path for professional growth.

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationPortland, OR, United States
SQLMicrosoft ExcelETLSnowflakePandasPythonpytestJiraAgile

Job description

Role: ETL QA Engineer

Locations: Portland ,OR /Salt Lake City ,UT / WA/ ID / Minneapolis ,MN/ North Dakota / Arkansas - Hybrid

Contract to hire


Job Summary: We're hiring ETL QA Engineers to validate data as it moves from source systems into Snowflake. You'll make sure every load is complete, accurate, and reliable, and you'll help lead database testing efforts for the team. This is a hybrid, contract-to-hire role.

Responsibilities

  • Test ETL pipelines and data warehouse loads from source to target
  • Write and run advanced SQL to reconcile data, find discrepancies, and check data quality
  • Validate transformations, data types, nulls, duplicates, and row counts
  • Test slowly changing dimension (SCD) logic
  • Build and maintain Python scripts to automate data tests and health checks
  • Use Excel and pivot tables to report defects and summarize results
  • Coordinate database testing activities and communicate findings to developers and stakeholders
  • Track your work in Jira and manage your own backlog in an agile environment

Must-Have Skills

  • Advanced SQL
  • Experience leading or coordinating database test efforts
  • Microsoft Excel, including pivot tables
  • Experience writing, running, and automating tests
  • Experience with ETL testing and data warehouse validation

Nice-to-Have Skills

  • Snowflake
  • Python for test automation (pandas, pytest, or SQLAlchemy a plus)
  • Familiarity with SCD models (Type 1 and Type 2)
  • Jira
  • Agile practices

Aspire IT Solutions is an equal opportunity employer.
All applicants must submit accurate information; misrepresentation may disqualify candidacy.
This role may require background checks/work authorization verification.
Rate/benefits are negotiable.
Aspire IT Solutions reserves the right to modify or withdraw this posting.

Similar jobs

Apply