Senior IT QA Data Quality Analyst

🕒 August 10

🇺🇸 United States – Remote

💵 $82.5k - $130k / year

⏰ Full Time

🟠 Senior

🔧 QA Engineer (Quality Assurance)

👻 Ghost score 1%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Guild Mortgage

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1960

🏗️ Construction

💸 Finance

🏠 Real Estate

Construction • Finance • Real Estate

Guild Mortgage is a U. S. -based mortgage lender and loan servicer that provides a wide range of home financing products and services to consumers and business partners. The company offers purchase and refinance mortgages, including conventional, FHA, VA, USDA, jumbo, renovation, construction, reverse mortgages, HELOCs, and specialty programs and down-payment assistance. Guild Mortgage operates nationwide through local branches and loan officers, supports borrowers with servicing and online account management, and partners with builders, real estate agents, title agents, and correspondents.

📋 Description

• Define, maintain, and improve the Data QA strategy for EDW and Data Services initiatives • Design, document, and perform data quality checks across Enterprise Data Warehouse delivery layers • Establish testing entry, exit, suspension, and completion criteria • Develop repeatable test plans covering mappings, business rules, transformations, referential integrity, duplicates, nulls, completeness, and accuracy • Validate CDC processing, incremental loads, historical processing, and source-to-target reconciliation • Validate data masking, sensitive data handling, and privacy-related transformation rules • Review test coverage and production-readiness risks • Calculate and track data quality results with Data Engineers and BI Engineers • Write SQL and reports to evaluate data content for quality assurance • Create Power BI dashboards for data quality metrics, defect trends, testing progress, and release readiness • Analyze incoming data feeds, data content trends, metadata gaps, reference data, standardization, business rules, and quality controls • Create alert mechanisms for system and data quality issues, data receipt, completeness, and schedule variances • Liaise with Product, Development, Data Engineering, DataOps, BI Engineering, UAT teams, business stakeholders, and vendors • Maintain requirement traceability matrices • Coordinate test planning, execution, defect triage, retesting, regression testing, and release readiness • Provide risk assessments and evidence-based go/no-go recommendations • Mentor QA Analysts and review test plans, SQL queries, evidence, defects, and validation approaches • Develop reusable Data QA standards, templates, and best practices • Automate repeatable SQL validation, reconciliation, data comparison, regression testing, and quality reporting • Support defect analysis and root-cause investigation • Perform regression testing for code releases, pipeline changes, EDW enhancements, and reporting changes • Maintain test execution, defect tracking, traceability, and evidence in qTest, Jira, or equivalent tools • Perform other duties as assigned

🎯 Requirements

• Bachelor's Degree directly related to the position or equivalent, preferred • Minimum five years' experience with corporate data management systems in high-compliance contexts • Knowledge of data quality concepts, source-to-target mapping, reconciliation, snowflake/star schema, dimensional modeling, slowly changing dimensions, referential integrity, completeness, correctness, consistency, validity, uniqueness, and timeliness • Advanced SQL skills, including joins, aggregations, common table expressions, window functions, exception queries, reconciliation queries, duplicate analysis, null analysis, key validation, and transformation validation • Knowledge of Snowflake and cloud-based data warehouse or data platform concepts • Knowledge of AWS S3 and Parquet, Avro, and other structured or semi-structured data formats • Knowledge of Informatica Data Quality and IICS • Experience validating ETL/ELT pipelines, ingestion, transformation, movement, warehouse layers, dimensional models, and downstream reporting • Experience validating CDC, incremental loads, inserts, updates, deletes, historical processing, and Type 2 slowly changing dimensions • Experience with source-to-target validation and reconciliation across operational systems, EDWs, cloud platforms, and reporting or analytics products • Experience validating data masking, sensitive data handling, privacy rules, and reporting impacts • Basic knowledge of statistical techniques such as the Shewhart method and trend analysis • Experience automating testing, SQL validation, data comparison, and regression testing • Experience with test data management and test data strategy • Experience with defect management, root-cause investigation, requirements traceability, and audit-ready evidence • Experience using Jira and qTest or equivalent tools • Experience implementing data quality metrics, dashboards, release readiness reporting, and audit evidence • Ability to define QA strategy, establish entry and exit criteria, review test coverage, assess release risk, and provide evidence-based recommendations • Ability to mentor QA Analysts and promote consistent data QA practices • Excellent verbal and written communication skills required • Critical-thinking, technical problem-solving, abstract-thinking, organization, and detail-orientation abilities • Ability to create clear, concise, detailed test plans, test cases, test evidence, defect documentation, and release readiness summaries • Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required • Commitment to company values • Ability to learn tasks, remember processes, maintain focus, work independently, make timely decisions, adapt to workplace stressors, and follow established protocols • Ability to work Monday–Friday during the business week

🏖️ Benefits

• Medical insurance • Dental insurance • Vision insurance • Life insurance • AD&D insurance • LTD insurance • 401(k) with employer match • Remote work arrangement • Pleasant work environment • Competitive compensation