Operational Controls SQL Developer (On-site)

NewRez LLC; Tempe (AZ); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) Retirement plan with employer-m

Paid Maternity Leave/Parental Bonding

Job summary

Newrez LLC seeks an Operational Controls SQL Developer to advance data integrity and performance management. You will build and maintain dashboards, automate loan exception detection, and deliver executive reporting using SQL Server and Tableau. Collaboration with servicing and leadership is essential.

The role emphasizes on-site work, strong communication, and adherence to regulatory requirements while driving data-driven decisions across teams.

Qualifications

• Bachelor's degree in business, computer science, mathematics, or related field.
• 2-4 years’ experience as a data or reporting analyst in a financial setting or related technical certifications.
• 2-4 years in T-SQL stored procedure programming and optimization.
• 2-4 years in Tableau dashboards & data visualization, or Associate-level Tableau Certification.
• Mortgage industry experience preferred.
• Experience with Tableau, Power Platform, Visual Studio, SharePoint, Python, R, and Visio a plus.

Responsibilities

• Define what the problem is, where it exists, and how it can be fixed.
• Interpret business requirements and understand potential obstacles with rule implementations.
• Create high-visibility loan exception and reporting dashboards.
• Source data from MS SQL Server data warehouse and ensure data integrity.
• Adhere to coding standards and optimize stored procedures.
• Present findings clearly to stakeholders, including senior management.

Skills

T-SQL

Tableau

Power Platform

Excel

Education

Bachelor's degree in business, computer science, mathematics, or related field

Tools

Visual Studio

SharePoint

Python

R

Visio

Job description

Who We Are 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. Primary Function The Operational Controls SQL Developer is a talented, detail-oriented SQL Developer that contributes to the Data Integrity Management (DIMS) and Operational Controls Performance Management teams. The Operational Controls SQL Developer will extensively use systems knowledge and logical problem-solving to identify and automate the identification of loan exceptions and illogical conditions and create, manage, and maintain insightful department-level dashboards and executive reporting, with a strong focus on KPI tracking and performance monitoring. The individual will leverage creative thinking, optimal communication, analytic and project management skills. They have a background in SQL coding, a track record of developing high-visibility reporting, an eagerness to contribute to the overall organizational success with data-driven insight, and a moderate understanding of mortgage servicing.

Principal Duties

• Define what the problem is, where it exists, and how it can be fixed.
• Exhibit strong communication and listening skills, focused on interpretation of business requirements, and understanding potential obstacles with rule or control implementation.
• Excel in a team-oriented, collaborative environment while contributing to the creation, design, and implementation of high-visibility value-add, loan exception, and business reporting and controls that ensures adherence to regulatory and investor requirements, operating practices, and company policy.
• Collaborate with servicing departments to identify and understand existing business timelines, rules, and exceptions, ensuring accuracy and integrity throughout the process.
• Create insightful dashboards using Tableau to assist leadership teams with business decision making, employee performance evaluation, KPIs/OKRs, and loan level exception & control reporting.
• Leverage MS SQL Server data warehouse to source required and create trustworthy code logic used to identify loan exceptions and control flag populations.
• Adhere to and recommend improvements to project coding standards, in-line QC, and stored procedure optimization.
• Work in a team environment with shared code; disciplined use of source code control (TFS) and process documentation.
• Assignment of high-visibility reporting projects related to regulatory, investor, compliance, senior leadership, or internal audit.
• Be able to clearly articulate and present ideas and findings to a varied audience including the operational controls staff and senior management.
• Performs related duties as assigned by management including but not limited to ad hoc reporting and cross-training.
• *These essential functions are fundamental to the role, and must be performed on-site, as they cannot physically be performed remotely. In addition, the Company has determined that an in-person presence is important to critical components of our work, including oversight, training, collaboration, and productivity. Items not marked (*) as essential on-site, may still require partial on-site work to perform the role satisfactorily.

Education and Experience Requirements

• Bachelor's degree in business, computer science, mathematics, or related field.
• 2-4 years’ experience as a data or reporting analyst in a financial setting or related technical certifications.
• 2-4 years in T-SQL stored procedure programming and optimization.
• 2-4 years in Tableau dashboards & data visualization, or Associate-level Tableau Certification.
• Mortgage industry experience preferred.
• Experience with Tableau, Power Platform, Visual Studio, SharePoint, Python, R, and Visio a plus.

Knowledge, Skill, and Ability Requirements

• Proficiency of DQL, DML, and DDL T-SQL commands.
• Proficient in Excel reporting & analysis (must know formulas, pivots, lookups, Power Query).
• Strong attention to detail and an ability to multi-task, responds well to pressure and deadlines, and works well individually and in a collaborative environment.
• Strong business communication skills with an ability to work well in a collaborative environment.
• Fast and willing learner – able to assimilate new ideas and thrive in a fast-paced environment with a thirst for upskilling.
• Natural entrepreneurial interest is a plus.

While this description is intended to be an accurate reflection of the position’s requirements, it in no way implies/states that these are the only job responsibilities. Management reserves the right to modify, add or remove duties and request other duties, as necessary. By applying to this position candidate acknowledges that this is not a remote role and is required to be on-site. Additional Information: While this description is intended to be an accurate reflection of the position’s requirements, it in no way implies/states that these are the only job responsibilities. Management reserves the right to modify, add or remove duties and request other duties, as necessary. All employees are required to have smart phones that meet Company security standards with the ability to install apps such as Microsoft Authenticator. Employment will be contingent on this requirement.

Why Newrez

We’re a great place to work because we invest in what matters: your career, your community, your wellbeing, and your future. Our total rewards package is designed to support your whole self.

Company Benefits:

• 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
• The Newrez Employee Emergency and Disaster Fund is a program to support our team members experiencing hardships

Newrez NOW:

Through Newrez NOW, our Corporate Social Responsibility program, you’ll have opportunities to give back, lead, and make a difference.

• 1 company-paid Volunteer Time Off day (with over 40,000 volunteer hours contributed since our inception)
• Matching Gifts Program - dollar-for-dollar up to $1,000
• Access to grants, nonprofit resources, and volunteer opportunities
• More than $6,000,000 donated since 2020
• 1 in 5 employees participates in at least one Employee Resource Group (ERG)

Equal Employment Opportunity

We’re proud to be an equal opportunity employer- and celebrate our employees' differences, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, and Veteran status. Different makes us better.

CA Privacy Policy CA Notice at Collection

The right company in the right industry. In both good economic times and bad, people need homes - and mortgages to buy them. We help these people every day buy homes or refinance their current mortgage loans. In addition to offering an in-demand product, there are two things you should know about us: We value and reward entrepreneurial spirit, and we are growing. Few lenders are as innovative, as financially solid, as well managed and on track to become America’s leading lender as the Newrez Family of Companies. We deliver products and services that turn prospects into delighted customers —providing abundant opportunity for the great people who work here. These competitive advantages set us apart, and they’re why you can grow with us for the long term.