Sr Operational Controls SQL Developer

About the position

The Sr Operational Controls SQL Developer is a talented, detail-oriented SQL Developer. The Sr Operational Controls SQL Developer Analyst will extensively use systems knowledge and logical problem-solving to identify and automate the identification of loan exceptions and illogical conditions. They will have an extensive background in SQL coding and an extensive understanding of mortgage servicing.

Responsibilities

• 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 value-add loan exception and business controls that ensures adherence to regulatory and investor requirements, operating practices, and company policy.
• Collaborate with servicing departments to identify and understand existing business rules and exceptions, ensuring accuracy and integrity throughout the process.
• Leverage MS SQL Server data warehouse to 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.
• Conduct peer code reviews, provide guidance, suggest & implement best practices and techniques.
• Assignment of high-visibility reporting projects related to regulatory, investor, compliance, senior leadership, or internal audit.
• Work in a team environment with shared code; disciplined use of source code control (TFS) and process documentation.
• Clearly articulate and present ideas and findings to a varied audience including the operational controls staff and senior management.
• Perform related duties as assigned by management including but not limited to ad hoc reporting and cross-training.

Requirements

• Bachelor's degree in business, computer science, mathematics, or related field.
• 5+ years of experience as a data or reporting analyst in a financial setting or related technical certifications.
• 5+ years in T-SQL stored procedure programming and optimization.
• 5+ years mortgage industry experience preferred.
• Experience creating data visualization in Tableau, Power BI, or SSRS.

Nice-to-haves

• Experience with Tableau, Power Platform, Visual Studio, SharePoint, Python, R, and Visio a plus.

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
• Pet insurance
• Adoption Assistance
• Tuition reimbursement
• Employee Loan Program
• The Newrez Employee Emergency and Disaster Fund is a new program to support our team members
• 1 Volunteer Time Off (VTO) day, company-paid volunteer day where all eligible employees may participate in a volunteer event with a nonprofit of their choice
• Employee Matching Gifts Program: We will match monetary employee donations to eligible non-profit organizations, dollar-for-dollar, up to $1,000 per employee
• Newrez Grants Program: Newrez hosts a giving portal where we provide employees an abundance of resources to search for an opportunity to donate their time or monetary contributions