Team Lead IS Data Systems (On-site)

Newrez; Tempe (AZ); On-site; USD 100,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) Retirement plan with employer–匹

Paid Maternity Leave/Parental Bonding/

Job summary

Newrez is seeking a Team Lead IS Data Systems to oversee daily and monthly reporting, remittance, and reconciliation for investor portfolios. The role involves collaborating with business partners, mentoring staff, and ensuring accuracy and timely delivery of reports.

You will work on-site to review files, develop plans with analysts, and train staff on processes. A strong background in Excel, T-SQL, and SSIS is essential to success in this position.

Qualifications

• Expert MS Excel experience required.
• Visual Basic for Applications experience preferred.
• Strong math skills.
• Strong analytical skills, particularly regarding assessing internal control weaknesses.
• Strong communication skills to interact with Senior Management.

Responsibilities

• Ensure monthly reports are run and delivered on time.
• Lead and mentor junior team members and review work for accuracy.
• Develop project plans with business analysts and document data requirements.
• Provide technical support for investor reporting processes and remittance.
• Resolve coding and formatting issues in reports and analytics.
• Assist with policies and procedures for process owners and controls.
• Balance accounts and perform standard financial calculations and data validation.
• Conduct root cause analysis on data issues and drive improvement initiatives.

Skills

MS Excel

VBA

Math skills

Analytical skills

Communication skills

Education

Bachelor's Degree in Accounting, Finance, or IT

Tools

T-SQL

SQL Server Integration Services

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.

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 Team Lead IS Data Systems is responsible for daily and monthly activities that provide technical support and development for the reporting, remittance and reconciliation functions of our Fannie Mae, Freddie Mac, Ginnie Mae, or Private investor portfolios. The Team Lead IS Data Systems is responsible for technical support and report development for the setup, reporting, and remitting on new investors. This includes working with business partners to review files/automations to ensure the result is as expected. Additionally, the individual will work directly with the investor reporting business analysts to train the staff to understand the processes they are completing, create plans to achieve the desired result and complete any required documentation. Candidates must have strong communication skills and the ability to research and complete timely resolution to exceptions, including collaboration with internal business partners.

Principal Duties

• Ensure monthly reports are run and delivered to our business partners in an accurate and timely manner.
• Work with less senior staff to ensure they maintain and follow procedures and controls within the monthly process.
• Work with less senior staff and business partners to complete project requirements documents, including details on data inputs and outputs, formatting, desired file type, etc.
• Work with the assigned business analyst to develop a project plan, ensuring all requirements are understood and the plan accounts for all requirements.
• Complete first review of completed code, to ensure requirements met before presenting to the business.
• Work with business partners to resolve any coding issues, including formatting issues with reports.
• Provide technical expertise as required for the creation/update of the process owner’s policies and procedures.
• Work with business partners to ensure the final product fulfills the project requirements.
• Confirm projects are being completed timely and accurately.
• Calculate interest and percentages; balance accounts; add, subtract, multiply and divide in all units of measure, using whole numbers, common fractions, and decimals; locate routine mathematical errors; compute rate, ratio, and percent, including the drafting and interpretation of bar graphs.
• Completes root cause analysis and resolves data issues.
• Proposes solutions for future process enhancements.
• Provide guidance and oversight to less senior team members.
• Assist manager in the determination of best practices.
• Creates assignments and tracks internal and external audits to completion.
• Heavy use of Microsoft Excel and T-SQL for data analysis and reporting.
• Handle ad-hoc reporting or research as directed by management.
• Performs related duties as assigned by management.

Education And Experience Requirements

• Bachelor's Degree preferably in Accounting, Finance, or Information Technology.
• 6+ years of Investor Reporting experience required.
• 6+ years data systems experience.
• 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.

Knowledge, Skill, And Ability Requirements

• Expert MS Excel experience required.
• Visual Basic for Applications experience preferred.
• T-SQL or other database reporting experience required.
• SQL Server Integration Services experience required.
• Servicing Director knowledge a plus.
• Strong math skills.
• Knowledge of basic accounting principles and practices.
• Strong analytical skills, particularly regarding assessing the probability and impact of an internal control weakness.
• Proven ability to build strong relationships with stakeholders, learn quickly, be flexible and think strategically.
• Strong communication skills to interact with Senior Management and other business units.
• Working understanding of operational risks and related controls.
• Strong organizational and time management skills necessary.
• Ability to manage multiple tasks and shift priorities as appropriate to meet reporting deadlines and maintain reporting accuracy and analysis abilities with strong attention to detail.
• Self-motivated with strong attention to detail and excellent organization skills.
• Ability to research and execute alternative methods of achieving a desired result when roadblocks are encountered.

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

We offer benefits, programs, and perks that support you in every aspect of your life.

• 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 & Certifications 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