Guild Mortgage Company, closing loans and opening doors since 1960. As a mortgage banking firm we are dedicated to serving the home owner/buyer. Our goal is to provide affordable home financing for our customers, utilizing the best terms available while providing a level of professionalism and service unsurpassed in the lending industry.
Position Summary
The IT QA Data Quality Analyst plays an important role in the organization by performing quality assurance activities for Enterprise Data Warehouse (EDW), Data Services, and related data delivery initiatives. The role develops and executes repeatable data validation approaches to help ensure data delivered to stakeholders is complete, accurate, timely, traceable, and fit for business use.
The analyst documents and performs data quality checks across data assets and delivery layers, including validation of source-to-target mappings, transformation rules, Change Data Capture (CDC), dimensional models, data masking, downstream reporting impacts, and data quality metrics. The role works cross-functionally with Data Engineering, DataOps, BI Engineering, Product, Business Analysts, UAT teams, vendors, end users, and Project Management to support test planning, execution, defect resolution, release readiness, and continuous improvement.
This is an individual-contributor role. The analyst maintains test evidence, identifies opportunities to automate repeatable validation and regression checks, communicates data quality risks, and supports evidence-based release decisions under established QA standards and direction.
Compensation
This role is an exempt position with a targeted salary range of $82,506.00 - $118,344.94.
Compensation at Guild is influenced by a wide array of factors including but not limited to local and federal minimum wage requirements, education, level of experience, and applicant’s geographical location.
Essential Functions
- Execute and continuously improve repeatable Data QA approaches for EDW and Data Services initiatives using established risk-based testing, validation standards, quality gates, and release readiness expectations.
- Design, develop, document, and perform data quality checks throughout the Enterprise Data Warehouse.
- Apply established testing entry, exit, suspension, and completion criteria to assigned data delivery initiatives.
- Develop and execute test plans that validate source-to-target mappings, business rules, transformation logic, referential integrity, duplicates, null handling, key relationships, data completeness, and data accuracy.
- Validate CDC processing, including inserts, updates, deletes, incremental loads, historical data processing, and reconciliation between source and target systems.
- Validate data masking, sensitive data handling, and privacy-related transformation rules with appropriate technical and business stakeholders.
- Perform source-to-target reconciliation and data validation across operational systems, Microsoft/Azure data platforms, EDW layers, cloud storage, pipelines, and downstream reporting or analytics products.
- Write SQL and other quality-assurance reports to evaluate and analyze data content at platform levels; this does not include business report development.
- Work with Data Engineers and BI Engineers to model, calculate, and track data quality results.
- Create or maintain BI dashboards that show data quality measures, population metrics, defect trends, testing progress, and release readiness indicators.
- Analyze incoming data feeds for completeness, content, timeliness, accuracy, and alignment with data expectations; identify trends across time and other dimensions.
- Identify gaps in metadata, reference data, standardization, business rules, and data quality controls.
- Create alert mechanisms for system issues, data quality issues, data receipt, completeness, and expected schedule variances.
- Partner with Product, Development, Data Engineering, DataOps, BI Engineering, UAT, business stakeholders, and vendors to support certification of data.
- Create and maintain requirements traceability that connects requirements, source and target data, test cases, execution results, defects, and test evidence.
- Support defect analysis and root cause investigation with clear data evidence, reproduction steps, impacted records, business-rule context, and downstream-impact assessment.
- Perform regression testing for code releases, data pipeline changes, EDW enhancements, reporting changes, and other production-impacting data changes.
- Identify and implement opportunities to automate repeatable SQL validation, source-to-target reconciliation, data comparison, regression testing, and quality reporting.
- Maintain test execution, defect tracking, traceability, and evidence in approved test management and work tracking tools such as qTest, Jira, or equivalent systems.
- Communicate test status, data quality findings, unresolved risks, and supporting evidence to help project stakeholders make release decisions.
- Perform other duties as assigned.
Qualifications
- Bachelors Degree directly related to the position or equivalent, preferred.
- Minimum two years experience with Corporate data management systems in high-compliance contexts required. Experience in Data QA, Data Warehouse QA, ETL/ELT testing, BI testing, or data quality validation preferred.
- No direct supervisory experience required.
- No certifications or licenses required.
- Knowledge of data quality concepts, including source-to-target mapping, data reconciliation, snowflake/star schema, dimensional modeling, slowly changing dimensions, referential integrity, completeness, correctness, consistency, validity, uniqueness, and timeliness.
- Strong SQL skills, including joins, aggregations, common table expressions, window functions, exception and reconciliation queries, duplicate and null analysis, key validation, and transformation validation.
- Knowledge of Microsoft and Azure data platforms preferred, including Azure SQL, Azure Data Lake Storage, Azure Data Factory or Synapse pipelines, Microsoft Fabric, Power BI, and Microsoft Purview where applicable; knowledge of Snowflake and cloud-based data warehouse concepts is also preferred.
- Experience with cloud data platforms and storage technologies, including Azure Data Lake Storage and Microsoft data services preferred; AWS S3 or similar object storage experience is a plus. Knowledge of Parquet, Avro, and other structured or semi-structured data formats.
- Knowledge of Informatica Data Quality and IICS, including data quality checks for correctness, completeness, consistency, validity, and uniqueness.
- Experience validating ETL/ELT pipelines, data ingestion, transformation, movement, warehouse layers, dimensional models, and downstream reporting outputs.
- Experience validating CDC, incremental loads, inserts, updates, deletes, historical processing, and Type 2 slowly changing dimension behavior.
- Experience performing source-to-target validation and reconciliation across source systems, enterprise data warehouses, cloud data platforms, and analytics products.
- Experience validating data masking, sensitive data handling, privacy-related rules, and downstream reporting impacts.
- Basic knowledge of statistical techniques such as the Shewhart method, trend analysis, and other methods used to assess data quality patterns.
- Experience with automated testing, SQL-based validation, data comparison, regression testing, and test data management across multiple workstreams.
- Experience with defect management, defect analysis, root cause investigation, requirements traceability, and audit-ready evidence.
- Experience using Jira and qTest, or equivalent tools, for test planning, execution, defect tracking, traceability, and evidence management.
- Experience implementing data quality metrics, dashboards, release readiness reporting, and audit evidence.
- Excellent verbal and written communication skills; ability to communicate technical findings and risks clearly.
- Ability to think critically, evaluate facts and data, draw conclusions, determine downstream impact, assess risk, solve technical problems, and think abstractly.
- Ability to create clear, concise, and detail-oriented test plans, test cases, test evidence, defect documentation, and release readiness summaries.
- Excellent verbal and written communication skills required.
- Highly organized and detail-oriented; ability to work in a fast-paced, metrics-driven environment required.
- Proficiency in Microsoft Office Suite, Word, Excel, Wiki, collaborative cloud-based programs, and third-party software applications required.
- Commitment to company values.
- Customer Service - Proactive attention to each person
- Integrity - Do and say what's right
- Respect - Treat others with dignity
- Collaboration - Listen and work together
- Learning - Seek knowledge and strive for improvement
- Excellence – Deliver the unexpected
Requirements
- Ability to accurately interpret sounds and associated meanings at a volume consistent with interpersonal conversation.
- Regularly required to accurately perceive, distinguish and interpret information received visually and through audio; e.g., words, numbers and other data broadcasted aloud/viewed on a screen, as well as print and other media.
- Office environment – moderate noise, no substantial exposure to adverse environmental conditions.
- Travel: 5%
- Work is primarily performed during the business week, Monday - Friday
Guild offers a pleasant work environment, competitive compensation and excellent benefits package; including medical, dental, vision, life insurance, AD&D, LTD and 401(k) with employer match.
Guild Mortgage Company is an Equal Opportunity Employer.
REQ#: ITQAD018494