Back to Jobs
Recently postedTechnology

DATA WAREHOUSE DEVELOPER

QUANTUM TECHNOLOGIES LLCAustin, TX🇺🇸United States

Quick overview

Salary$85/hr
SeniorityMid Senior
Work modeHybrid
LocationAustin, TX, United States
OracleSQLGitETLSnowflakePythonGenerative AIPostgreSQLSQL Server

Job description

Job Title:  Data Warehouse

Location: Austin,TX

Duration: 6 Months + Extension

Bill Rate: $85/hour

Job Type: W-2 Contract

Client: To Be Discussed Later

Work Authorization: H-1B, OPT-EAD, GC-EAD, -EAD

Job Summary
A Data Warehouse (DWH) / ETL Tester ensures the accuracy, integrity, performance, and reliability of data moving through extraction, transformation, and loading (ETL) pipelines into a centralized data warehouse

Key Responsibilities:

  • Validate ETL/ELT data pipelines across Bronze (Raw), Silver (Cleansed), and Gold (Curated) Medallion architectures.
  • Perform source-to-target mapping verification, data quality checks, and complex business logic validation on Medicaid/MMIS datasets.
  • Write advanced, multi-table SQL queries and Python scripts to perform automated data reconciliation, null checks, and referential integrity testing.
  • Collaborate with data engineers and business analysts to create comprehensive test plans and lead defect triage.
  • Leverage AI tools (e.g., GitHub Copilot) daily to streamline test-case generation and SQL writing ($\ge$90% weekly usage required).

Key Requirements:

  • Deep proficiency in SQL and modern database platforms (Snowflake, Oracle, SQL Server, PostgreSQL).
  • Strong scripting skills in Python for data validation and test automation.
  • Hands-on experience with Medicaid/MMIS data migrations or healthcare domain datasets.
  • Bachelors degree in Computer Science, IT, or equivalent experience.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs