IT QA Data Quality Analyst

Position Summary

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

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
• 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