DATA WAREHOUSE DEVELOPER

Quantum Technologies
Austin, TX, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Compensation
$176,800
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Business Logic Automation of Tests Software Bug Management Databases Data Validation Data Integrity Extract Transform Load (ETL) Data Warehousing PostgreSQL Microsoft SQL Server Medicaid Management Information Systems (MMIS)
+7 more
Oracle (Applications) SQL Databases Scripting GitHub Copilot Snowflake Information Technology Data Pipelines

Job description

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, * 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).

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…