Senior IT QA Data Quality Analyst

🕒 vor 2 Tagen

Jetzt Bewerben

Ähnliche Remote-Jobs finden

E-Mail-Benachrichtigung für neue Jobs einrichten

📊 Überprüfen Sie Ihre Lebenslauf-Bewertung für diese Stelle

Verbessern Sie Ihre Chancen auf ein Vorstellungsgespräch, indem Sie Ihre Lebenslauf-Bewertung vor der Bewerbung überprüfen.

Lebenslauf hochladen

Guild Mortgage

WebsiteLinkedInAlle Stellen

1001 - 5000 Mitarbeiter

Gegründet 1960

🏗️ Bauwesen

💸 Finanzen

🏠 Immobilien

Construction • Finance • Real Estate

Guild Mortgage ist ein in den USA ansässiger Hypothekengeber und Darlehensabwickler, der Verbrauchern und Geschäftspartnern eine breite Palette von Wohnfinanzierungsprodukten und -dienstleistungen bietet. Das Unternehmen offeriert Kauf- und Refinanzierungshypotheken, darunter konventionelle, FHA-, VA-, USDA-, Jumbo-, Renovierungs-, Bau-, Umkehrhypotheken, HELOCs sowie Spezialprogramme und Unterstützung bei der Anzahlung. Guild Mortgage ist landesweit durch lokale Niederlassungen und Kreditberater tätig, unterstützt Kreditnehmer mit Serviceleistungen und Online-Kontoverwaltung und arbeitet mit Bauträgern, Immobilienmaklern, Notariatsangestellten und Korrespondenten zusammen.

Beschreibung

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

🎯 Anforderungen

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

🏖️ Vorteile

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