Data Quality Analyst

Summary

Join our Mortgage Business Intelligence & Analytics team as a Data Quality Analyst and play a vital role in ensuring the accuracy and reliability of our data. You will oversee the data lifecycle, from ingestion to reporting, partnering with the data engineering team to validate new data sources and maintain data quality. Responsibilities include testing and validating data, monitoring exceptions, creating and maintaining documentation, making report updates, and providing team support. This fully remote position offers flexibility and the opportunity to work from various office locations. We are seeking a candidate with 2-5 years of data-focused experience, strong SQL and Power BI skills, and a proven ability to resolve data issues. Mortgage experience is preferred.

Requirements

• 2-5 years’ experience in a data focused role
• Core understanding of data pipeline including ingestion, transformation, modeling, and preparation
• Strong understanding of data validation procedures including system parity, checksum, row-level, object-level, and incremental change validations
• Experience with documenting and maintaining validation logs
• Report development and data visualization experience
• Ability to independently trace and resolve issues through research and data mining
• Intermediate to Advanced proficiency with MS SQL Server including: Standard data mining
• Advanced querying/window methods
• Create/read views and stored procedures
• Joins across multivariate datasets including multiple keys
• Data normalization
• Basic to Intermediate proficiency with Power BI including Power Query
• Semantic Models
• DAX
• Report design and layout
• VCS such as Git or TFS
• Strong written and verbal communication skills
• Critical thinking

Responsibilities

• Test and validate new data sourced by the data engineering team including 1:1 validation against production systems
• Ongoing validation of primary and derived tables
• Periodic review of reports to ensure parity across reporting
• Assist with peer reviews of team’s work
• Ongoing monitoring of exceptions, including engagement with business partners to resolve data discrepancies
• Collection and curation of data points from business partners
• Execution of regulatory data preparation processes
• Documented validation of datasets against system of record
• Update and maintain data lineage and definitions of our primary data models
• Create metadata for existing and new reports
• Make minor changes and updates to existing reports as needed
• Submit pull requests for changes to views used for reporting
• Continuous enhancement of semantic models including efficiency audits
• Provide backfill support for ongoing team work
• Assist on specific projects as needed

Preferred Qualifications

• Mortgage experience
• Working knowledge of Microsoft Fabric

Benefits

This opportunity is fully remote with the option to work from our offices in San Diego, CA, Irvine, CA, or Omaha, NE for those who prefer an office environment