Compliance Data Assurance Advisor

Newrez LLC

. Develop and maintain SQL queries and repeatable population logic for validation, testing, issue management, exam responses, and operational reporting .

Posted 9/22/2026full-timeUnited StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates strong SQL skills for developing complex queries and performing data validation, alongside proficiency in data visualization tools like Tableau and Power BI. Capable of translating business requirements into actionable data insights while effectively communicating findings to leadership.

Highest-signal resume keywords

Strong SQL SkillsData Validation and Quality ChecksData Visualization with Tableau and Power BIAnalytical Capability in Financial SettingsClear Written and Verbal 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 ValidationData AnalysisExcelData VisualizationReconciliationException AnalysisUAT TestingRegression TestingOperational Reporting

Soft Skills

Detail-OrientedEffective CommunicationAbility to Manage Multiple PrioritiesFlexibilityTeam Collaboration

Tools & Technologies

ExcelTableauPower BIRPythonOkta VerifyMicrosoft Authenticator

Industry Keywords

Financial SettingOperational Risk IndicatorsComplianceData Issues InvestigationCustomer Behavior 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 population definitions, including inclusion/exclusion criteria, timeframes, data sources, and assumptions
Perform data validation and quality checks on source systems, extracts, and reports
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 support root cause analysis and remediation tracking
Produce dashboards and management reporting using tools such as Excel, Tableau, and Power BI
Partner with Operations, Compliance, and Technology to investigate data issues, clarify business logic, and implement durable fixes
Communicate analytical findings through written summaries for leadership updates and exam support
Maintain working 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 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
Strong SQL skills, including building complex queries and optimizing performance
Strong analytical capability, including data quality validation, reconciliation, and exception analysis
Strong Excel skills, including pivot tables, formulas, and charts
Experience with data visualization tools such as 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; able to present findings to operations and senior leadership
Detail-oriented with the ability to manage multiple priorities and deadlines in a fast-paced environment
Must work on-site at the assigned office location
Regular and punctual attendance
Flexibility to work occasional adjusted schedules, overtime, and evening and/or weekend hours
Ability to work in a noisy cubicle-hub environment
Ability to perform sedentary work and constant repetitive computer motions
Ability to communicate effectively verbally in English
Must have a smartphone meeting Company security standards and be 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)