Job Title: Data QA Analyst
Experience Level: [5+ years]
Job Summary:
We are seeking a detail-oriented and technically skilled Data QA Analyst with strong SQL expertise and domain experience in the mortgage services industry. The ideal candidate will be responsible for ensuring data integrity across systems, validating data load strategies, and collaborating with cross-functional teams to resolve data anomalies.
Key Responsibilities:
- Develop and execute SQL queries to test and validate data load strategies across multiple systems.
- Perform root cause analysis on data quality issues and recommend corrective actions.
- Conduct data comparison and validation using Data Quality tools, preferably QuerySurge.
- Collaborate with ETL developers and business stakeholders to investigate and resolve data anomalies.
- Ensure data integrity through profiling, audits, and continuous quality checks.
- Document test cases, validation results, and quality metrics.
- Maintain a strong understanding of loan data, servicing systems, and regulatory requirements in the mortgage domain.
Required Skills & Qualifications:
- Strong proficiency in SQL for data validation and analysis.
- Hands-on experience with Data Quality tools (QuerySurge preferred).
- Familiarity with ETL processes and data pipeline testing.
- Proven ability to perform root cause analysis and implement corrective actions.
- Experience in data profiling, auditing, and quality assurance practices.
- Domain expertise in the mortgage services industry, including loan data and regulatory compliance.
- Excellent communication and collaboration skills.
Preferred Qualifications:
- Experience with scripting languages like Python or Shell for automation.
- Knowledge of data governance and metadata management.
- Certifications in Data Quality, SQL, or Mortgage Compliance are a plus.