Senior IT QA Data Quality Analyst

Job not on LinkedIn

🔥 0 minutes ago

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

• The Sr. IT QA Data Quality Analyst plays an important role in the organization by leading quality assurance activities for Enterprise Data Warehouse (EDW), Data Services, and related data delivery initiatives. • This role is responsible for defining and maintaining Data QA strategy, repeatable test approaches, EDW quality governance practices, and release readiness standards to ensure data delivered to stakeholders is complete, accurate, timely, traceable, and fit for business use. • The role documents, executes, and oversees data quality checks across data assets throughout EDW delivery layers, including validation of data repositories against external source systems, source-to-target mappings, transformation rules, Change Data Capture (CDC), dimensional models, data masking, downstream reporting impacts, and data quality metrics. • The Sr. IT QA Data Quality Analyst partners cross-functionally with Data Engineering, DataOps, BI Engineering, Product, Business Analysts, UAT teams, vendors, end users, and Project Management to bring a QA perspective to planning, execution, defect resolution, release readiness, and continuous improvement. • This position also mentors QA Analysts, reviews test coverage and evidence, establishes reusable QA standards, identifies opportunities to automate repeatable data comparisons and regression checks, and provides evidence-based risk assessments and go/no-go recommendations for data releases.

🎯 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, including source-to-target mapping, data 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, including the ability to create simple and complex validation queries. • Knowledge of AWS S3 and data file formats such as Parquet, Avro, and other structured or semi-structured formats. • Knowledge of Informatica Data Quality and IICS; experience creating data quality checks for correctness, completeness, consistency, validity, uniqueness, and other data quality dimensions. • Experience validating ETL/ELT pipelines, data ingestion, data transformation, data movement, data warehouse layers, dimensional models, and downstream reporting outputs. • Experience validating Change Data Capture (CDC), incremental loads, inserts, updates, deletes, historical data processing, and Type 2 slowly changing dimension behavior. • Experience performing source-to-target validation and reconciliation across operational source systems, enterprise data warehouses, cloud data platforms, and reporting or analytics products. • Experience validating data masking, sensitive data handling, privacy-related rules, and downstream reporting impacts. • Basic knowledge of statistical techniques such as Shewhart method, trend analysis, and other methods used to assess data quality patterns. • Experience with automating testing, SQL-based validation, data comparison, and regression testing for code releases. • Experience with test data management across multiple workstreams and working with DBAs or data platform teams on test data strategy. • Experience with effective defect management, defect analysis, root cause investigation, requirements traceability, and audit-ready evidence. • Experience using Jira and qTest, or equivalent tools, for test planning, test execution, defect tracking, traceability, and evidence management. • Experience implementing data quality metrics, dashboards, release readiness reporting, and evidencing for audit. • Ability to define QA strategy, establish entry and exit criteria, review test coverage, assess release risk, and provide evidence-based recommendations. • Ability to mentor other QA Analysts and promote consistent data QA practices across projects and workstreams. • Excellent verbal and written communication skills required. • Ability to think critically, including the ability to evaluate facts and data to draw conclusions, determine the downstream impact of decisions, and assess associated risks. • Ability to create clear, concise, and detail-oriented test plans, test cases, test evidence, defect documentation, and release readiness summaries. • Ability to solve technical problems and think abstractly. • 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.

🏖️ Benefits

• medical • dental • vision • life insurance • AD&D • LTD • 401(k) with employer match