ETL Data Validation & QA Engineer

SIDMANS, INC.; Minneapolis (MN); Presencial; USD 80.000 - 120.000; Jornada completa

Descripción de la vacante

SIDMANS, INC. is seeking a data quality analyst to support requirement analysis, data validation, and ETL validation for Medicaid data sets. The role focuses on backend testing, source-to-target checks, and ensuring data accuracy across the enterprise data warehouse.

The candidate will design and execute SQL-driven tests, perform data comparisons, and create comprehensive test documentation for stakeholders, aligning with business rules and quality standards.

Formación

• Strong SQL and data validation experience.
• Experience with ETL and data warehouses.
• Ability to design test plans and implement validation checks.

Responsabilidades

• Requirement Analysis: participate in data modeling and requirements sessions to ensure testing aligns with business needs.
• Data Validation: verify source-to-target data mappings and transformations for Medicaid datasets and EDW quality.
• SQL and Scripting: write complex SQL with multi-table joins to validate ETL outputs against business rules and ensure referential integrity.
• Test Strategy and Execution: design test plans, cases, and scenarios for ETL/warehouse processes and document results for stakeholders.

Conocimientos

SQL

Relational databases

Oracle

SQL Server

PostgreSQL

GitHub usage

Herramientas

GitHub

Descripción del empleo

SIDMANS, INC. is seeking a data quality analyst to support requirement analysis, data validation, and ETL validation for Medicaid data sets. The role focuses on backend testing, source-to-target checks, and ensuring data accuracy across the enterprise data warehouse.

The candidate will design and execute SQL-driven tests, perform data comparisons, and create comprehensive test documentation for stakeholders, aligning with business rules and quality standards.