Senior Data QA Lead - EDW & Data Services

Guild Mortgage; United States; Remote; USD 83,000 - 130,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Life Insurance & AD&D

401(k) with employer match

Job summary

Guild Mortgage Company is seeking a Sr. IT QA Data Quality Analyst to lead data QA for the Enterprise Data Warehouse and Data Services, ensuring data is complete, accurate, and ready for business use.

You will design repeatable test plans, validate CDC, data masking, and source-to-target mappings, and partner with Data Engineering, BI, Product, and QA teams to drive release readiness.

Qualifications

• Bachelor's Degree in a related field or equivalent.
• Minimum five years' experience with corporate data management systems in high-compliance contexts.
• Knowledge of data quality concepts including data reconciliation, data lineage, and timeliness.
• Advanced SQL skills including joins, aggregations, CTEs, window functions, and reconciliation queries.
• Knowledge of Snowflake and cloud data warehouse concepts; experience with AWS S3 and Parquet/Avro formats.
• Experience with Informatica Data Quality and IICS; data quality checks for correctness, completeness, and validity.
• Experience validating ETL/ELT pipelines, data ingestion, transformation, and downstream reporting outputs.
• Experience validating CDC, incremental loads, and Type 2 slowly changing dimensions.
• Experience with source-to-target validation and reconciliation across systems and data platforms.
• Experience validating data masking and sensitive data handling; downstream reporting impacts.
• Ability to define QA strategy, establish entry/exit criteria, review coverage, and provide release-risk input.
• Experience mentoring QA Analysts and promoting consistent data QA practices.
• Excellent verbal and written communication skills.

Responsibilities

• Define, maintain, and improve the Data QA strategy for EDW and Data Services initiatives.
• Design, develop, and perform data quality checks across the EDW.
• Establish testing criteria for data delivery initiatives.
• Develop repeatable test plans for EDW projects including source-to-target mappings and data quality rules.
• Validate CDC processing, including inserts, updates, deletes, and historical data handling.
• Validate data masking and privacy-related transformations with stakeholders.
• Review test coverage to ensure validation of requirements and production readiness risks.
• Create BI dashboards to highlight data quality metrics and release readiness.
• Coordinate QA activities to ensure plan execution, defect triage, and regression testing.
• Provide risk assessments and evidence-based release readiness recommendations.

Skills

SQL

Data QA

QA Strategy

Leadership

Mentoring

Test Planning

Data Quality

Education

Bachelor's Degree

Tools

qTest

Jira

Power BI

Snowflake

Informatica DQ

Job description

Guild Mortgage Company is seeking a Sr. IT QA Data Quality Analyst to lead data QA for the Enterprise Data Warehouse and Data Services, ensuring data is complete, accurate, and ready for business use.

You will design repeatable test plans, validate CDC, data masking, and source-to-target mappings, and partner with Data Engineering, BI, Product, and QA teams to drive release readiness.