Compliance Data Assurance Advisor

Newrez LLC

Compliance Data Assurance Advisor validating SQL populations, controls, and reporting for Newrez, a residential mortgage lender and servicer. Supporting risk monitoring, remediation, and exam responses.

Posted 8/10/2026full-timeCoppell • South Carolina, Texas • 🇺🇸 United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong SQL skills for complex query development and performance optimization, alongside proficiency in data validation, reconciliation, and analytical reporting using tools like Excel, Tableau, and Power BI. Capable of translating business questions into actionable data insights while maintaining clear communication and attention to detail.

Highest-signal resume keywords

SQL Query DevelopmentData Quality ValidationExcel ProficiencyTableau ReportingAnalytical Communication

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ValidationReconciliationExcelTableauPower BIRPythonComplex Query DevelopmentPerformance Optimization

Soft Skills

Clear CommunicationDetail-OrientedAbility to Manage PrioritiesFlexibilityVerbal Communication

Tools & Technologies

ExcelTableauPower BIRPythonOkta VerifyMicrosoft Authenticator

Industry Keywords

Data AnalystFinancial SettingComplianceOperational ReportingRoot Cause Analysis

Tech Stack

Tools & technologies

PythonSQLTableau

About the role

Key responsibilities & impact

Develop and maintain SQL queries and repeatable population logic for validation, testing, issue management, exam responses, and operational reporting
Build and document reproducible, auditable population definitions
Perform data validation and quality checks, including reconciliations, reasonableness testing, and exception identification
Execute and support control testing and ongoing monitoring
Analyze trends, drivers, and outliers to identify compliance risk indicators and support root cause analysis and remediation tracking
Produce dashboards and management reporting using Excel, Tableau, or Power BI
Partner with operations, Compliance, and Technology to investigate data issues and implement durable fixes
Communicate analytical findings through written summaries for leadership updates and exam support
Maintain knowledge of servicing processes and reporting
Support ad hoc analysis related to segmentation, customer behavior, and operational performance improvement
Assist with UAT and regression testing for Compliance-impacting changes and tickets
Perform related duties as assigned by management

Requirements

What you’ll need

Bachelor’s degree in an analytical or quantitative discipline, related STEM field, or equivalent combination of education and relevant experience
2–4 years of related experience as a data analyst in a financial setting
Strong SQL skills, including complex query development and performance optimization
Strong analytical capability in data quality validation, reconciliation, and exception analysis
Strong Excel skills, including pivot tables, formulas, and charts
Experience with Tableau, Power BI, R, or Python
Ability to translate business questions into testable logic and well-defined data populations
Clear written and verbal communication skills
Detail-oriented ability to manage multiple priorities and deadlines
Regular and punctual attendance
Flexibility to work occasional adjusted schedules, overtime, evenings, or weekends
Ability to work on-site at the assigned office location
Ability to communicate effectively verbally in English
Smartphone meeting company security standards and able to install apps such as Okta Verify and Microsoft Authenticator

Benefits

Comp & perks

Medical, dental, and vision insurance
Health Savings Account with employer contribution
401(k) Retirement plan with employer match
Paid Maternity Leave/Parental Bonding Leave/Caregiver Leave
Adoption Assistance
Tuition & Certification reimbursement
Employee Mortgage Loan Program
Newrez Employee Emergency and Disaster Fund
1 company-paid Volunteer Time Off day
Matching Gifts Program - dollar-for-dollar up to $1,000
Access to grants, nonprofit resources, and volunteer opportunities
Employee Resource Groups (ERG)