Compliance Data Assurance Advisor

At Newrez, we bring big thinkers and caring doers together to make home happen. We’re a team built on heart and hustle, united by a commitment to show up for our customers, our communities, and each other. We believe that when our people thrive, homeowners thrive - and that’s why we invest in your growth, wellbeing, and ability to make an impact.

Every day, we work to exceed the expectations of our residential mortgage borrowers and business partners through superior service, simple processes, and clear communication. We do this by empowering our employees, encouraging innovative solutions and recognizing great performance.

POSITION SUMMARY:

The Compliance Data Assurance Advisor supports Compliance analytics and control testing by developing accurate SQL-based populations, performing data analysis and validation, and delivering clear results for business owners, Compliance, Exam Management, and Change Management. This role partners closely with the Analytics and Validation Manager to ensure data integrity, repeatable testing, and timely reporting that supports operational performance, risk monitoring, and remediation oversight.

DESCRIPTION:

Essential Functions, Duties, and Responsibilities

• Develop and maintain SQL queries and repeatable population logic to support validation, testing, issue management, exam responses, and operational reporting.
• Build and document population definitions (inclusion/exclusion criteria, time frames, data sources, and assumptions) to ensure results are reproducible and auditable.
• Perform data validation and quality checks on source systems, extracts, and reports, including reconciliations, reasonableness testing, and exception identification.
• Execute and support control testing and ongoing monitoring, including sample selection, test execution support, result validation, and evidence packaging.
• Analyze trends, drivers, and outliers to identify operational or compliance risk indicators and to support root cause analysis and remediation tracking.
• Produce dashboards and management reporting (e.g., Excel, Tableau/Power BI) to communicate findings, performance metrics, and control results to stakeholders.
• Partner with operations, Compliance, and Technology to investigate data issues, clarify business logic, and implement durable fixes (including query optimization and performance tuning).
• Clearly communicate analytical findings to varied audiences, including written summaries suitable for leadership updates and exam support.
• Maintain working knowledge of servicing processes and reporting to ensure analytics and validations align with business intent and policy requirements.

• Support ad hoc analytical requests related to segmentation, customer behavior, and operational performance improvement.
• Assist with User Acceptance Testing (UAT) and regression testing for Compliance‑impacting changes and tickets.
• Ability to effectively and accurately convey information to others.
• Performs related duties as assigned by management.

Qualifications and

Education Requirements:

• Bachelor’s degree in analytical or quantitative discipline, or a related STEM field, or equivalent combination of education and relevant experience.
• 2-4 years related experience as a data analyst in a financial setting.

Skills, Abilities, and Knowledge:

• Strong SQL skills, including building complex queries and optimizing performance.
• Strong analytical capability, including data quality validation, reconciliation, and exception analysis.
• Strong Excel skills (pivot tables, formulas, charts) and experience with data visualization tools (Tableau/Power BI/R/Python).
• Ability to translate business questions into testable logic and well-defined data populations.
• Clear written and verbal communication skills; able to present…