Senior IT Data Quality QA Analyst — EDW & Data Governance

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

AD&D

LTD

401(k) with employer match

Job summary

Guild Mortgage Company seeks a Sr. IT QA Data Quality Analyst to lead QA for EDW, Data Services, and data delivery initiatives. The role defines QA strategy, executes data quality checks, validates CDC, and mentors QA staff to ensure data is complete, accurate, and ready for release.

Compensation ranges from $82,506 to $130,000 annually, with local and experience-based adjustments. Collaboration with Data Engineering, BI, Product, and Vendors drives governance and continuous improvement.

Qualifications

• This role requires a Bachelor's degree or equivalent and at least five years in corporate data management.
• Strong knowledge of data quality concepts, source-to-target mapping, reconciliation, and dimensional modeling.
• Advanced SQL skills and experience validating ETL/ELT pipelines and CDC.
• Experience with Snowflake, cloud data platforms, and data quality tools like Informatica DQ.
• Ability to define QA strategy, establish criteria, and provide evidence-based release guidance.
• Excellent communication and mentoring abilities.

Responsibilities

• Define, maintain, and improve the Data QA strategy for EDW and Data Services.
• Design and execute data quality checks across EDW delivery layers and source-target mappings.
• Validate CDC processing, masking, and privacy-related transformations with stakeholders.
• Develop repeatable test plans, SQL validation, and data reconciliation across platforms.
• Create BI dashboards highlighting quality metrics, defect trends, and release readiness.
• Coordinate QA activities, review coverage, and provide go/no-go recommendations.

Skills

Quality assurance

SQL

Data testing

EDW testing

Data validation

Data governance

Mentoring

Risk assessment

Dashboard usage

Cross-functional collaboration

Education

Bachelor's Degree or equivalent

Tools

Snowflake

Informatica Data Quality

IICS

Jira

qTest

Power BI

AWS S3

Parquet/Avro

Job description

Guild Mortgage Company seeks a Sr. IT QA Data Quality Analyst to lead QA for EDW, Data Services, and data delivery initiatives. The role defines QA strategy, executes data quality checks, validates CDC, and mentors QA staff to ensure data is complete, accurate, and ready for release.

Compensation ranges from $82,506 to $130,000 annually, with local and experience-based adjustments. Collaboration with Data Engineering, BI, Product, and Vendors drives governance and continuous improvement.