1 day ago
Chicago, IL, USA +2 moreMid Level
Base Salary
$89k - $156k/yr
Responsibilities
- Develop and maintain automated test suites for Databricks jobs, Delta tables, views, data transformations, and ETL pipelines.
- Validate metric calculations, business rules, aggregations, derived values, and source-to-target data transformations.
- Perform source-to-target reconciliation and validate data completeness, accuracy, consistency, timeliness, and referential integrity.
- Automate testing for full and incremental loads, updates, deletes, retries, exception handling, and recovery scenarios.
- Create test data, SQL validation queries, reusable utilities, and reconciliation frameworks.
- Integrate automated data tests into CI/CD pipelines and improve test automation frameworks and processes.
- Perform functional, integration, regression, and end-to-end testing across large-scale data solutions.
- Analyze test failures, perform root cause analysis, document defects, and collaborate with data engineering and platform teams.
- Test Stardog and knowledge graph structures, ontologies, relationships, mappings, SPARQL queries, data lineage, and provenance.
Requirements
- Experience developing automated tests for data jobs, transformations, ETL pipelines, and large-scale data solutions is required by the responsibilities.
- Ability to write SQL validation queries and create test data, reusable utilities, and reconciliation frameworks.
- Knowledge of functional, integration, regression, and end-to-end testing practices.
- Ability to analyze test failures, conduct root cause analysis, and collaborate with technical teams.
- Preferred experience with Stardog, knowledge graph platforms, ontologies, mappings, SPARQL, data lineage, and data provenance.
Benefits
- Comprehensive benefits plan.
- Incentive eligible.
- The estimated hiring range is $88,900.00 to $155,500.00 and may vary based on geographic factors and individual circumstances.
About Vizient
Vizient provides healthcare performance improvement solutions to U.S. hospitals and health systems, combining a group purchasing organization with clinical, operational, and financial analytics and advisory services. Members access a national contract portfolio representing about $156 billion in annual purchasing volume and benchmarking data drawn from extensive provider networks. Headquartered in Irving, Texas, the privately held company serves more than two-thirds of U.S. acute care providers and acquired Kaufman Hall in 2024.