Join our team as a Senior Technical Data Validation Engineer, a pivotal role supporting our Data Warehouse Modernization Program during System Integration Testing (SIT). You will be instrumental in validating migrated data pipelines, conducting source-to-target reconciliations, identifying the root causes of data discrepancies, and collaborating with development teams to expedite defect resolution.

We seek a candidate with strong proficiency in DBT, Snowflake, ETL/Data Warehouse principles, SQL-based reconciliation, and legacy Informatica workflows. The ideal person can independently analyze complex data issues and provide clear, actionable defect diagnostics.

Key responsibilities include:

- Executing end-to-end data validation across Informatica and DBT implementations, ensuring data completeness, accuracy, and adherence to business rules across all data layers. - Performing various validation types such as record counts, aggregates, reconciliations, SCD, and incremental loads. - Analyzing data discrepancies, pinpointing root causes, and providing detailed defect diagnostics to development teams. - Contributing to defect triage sessions, fostering collaboration for rapid issue resolution. - Validating data lineage and tracing data flow through source systems, DBT models, and Snowflake objects. - Translating Informatica mappings into DBT models and developing robust DBT tests. - Designing and implementing staging, core, and mart layers using DBT best practices. - Assisting with performance analysis and optimization of DBT models and Snowflake queries. - Supporting deployment validation and migration activities across environments. - Contributing to SIT strategy, test case reviews, and validation frameworks. - Documenting defects with clear root-cause analysis, business impact, and remediation recommendations. - Supporting regression testing and release validation. - Maintaining comprehensive validation documentation, reconciliation reports, and testing evidence.

Essential qualifications include:

- A minimum of 7 years of experience in Data Warehouse, ETL, Data Engineering, or Data Validation. - At least 2 years of direct experience with DBT (Core or Cloud). - Proven experience in Data Warehouse Migration/Modernization programs. - Experience supporting SIT or large-scale data validation initiatives. - A developer-level understanding of Informatica mappings, workflows, and transformations. - Hands-on experience with Snowflake and modern cloud data platforms. - Strong communication skills and the ability to interpret existing ETL logic and requirements documentation.

Must-have skills encompass advanced SQL, ETL/Data Warehouse testing, source-to-target data validation, DBT, Snowflake, data mapping, complex joins, transformation validation, various load validations (count, aggregate, SCD, incremental), defect analysis, root-cause analysis, financial reconciliation, SIT execution support, defect triage, debugging, test data analysis, reconciliation reporting, and business rule validation.

Highly desirable skills include Databricks, Azure DevOps or similar CI/CD tools, dbt test automation, Python for data validation, data validation automation frameworks/tools, and experience with large-scale ETL modernization.