Report Developer II

Position:  Report Developer II

Location: Remote OK - If living within 31 miles of Tustin, CA or Austin, TX will need to be able to work a hybrid schedule. 

Salary: $85K - $100K/yr d.o.e.

Position Summary:  

The Servicing MIS group is seeking Report Developer II to build reports and solutions for multiple business users across servicing. The Servicing MIS group is responsible for reports, ETL, and automation for all of mortgage servicing at NAF including default, foreclosure, performing servicing and more. Responsibilities and desired skills include but not limited to the following:

1. Build and innovate automation solutions, reports, ETL pipelines, and more using Microsoft T-SQL, SSRS, SSIS, PowerBI, MoveIt, VBS, PowerShell, and other scripting languages.
2. Develop and maintain Stored Procedures, Functions, Views, Synonyms, and Triggers
3. Excellent understanding of T-SQL programming, for example good knowledge about Merge, BCP, Openrowset etc.
4. Following standards to create a user friendly and consistent appearance.
5. Maintaining code in Azure DevOps code repository
6. Cultivate an understanding of business processes, systems, and various data sources to become more effective and efficient with report development.
7. Work with business users and\or business analysts to understand and develop report requirements.
8. Review processes and procedures and recommend improvements to management and other departments within the company to increase productivity and quality.
9. Daily work with backlog of production support tickets, coordinate all systems enhancements as well as research and test new features of the Loan Servicing platform.
10. Ability to create Drilldown, Linked, Parameterized, Snapshot SSRS reports.
11. Design, develop and maintain SSIS Packages to support ETL Processes.
12. Participate in code reviews, debug, or enhance existing code and troubleshoot for issues.
13. Assist with report and table sun-setting and cleanup including bringing legacy reports and tables up to standard.
14. Adhering to guidelines and standards
15. Participate in weekly On-Call rotation.
16. Able to multi-task and adapt to shifting priorities across multiple business users.

1. 3+ years’ experience developing reports using SQL and creating reports in SSRS, Excel, or PowerBI
2. 2+ years demonstrated experience in the mortgage servicing industry including early default, foreclosure, bankruptcy, loss mitigation, escrow, loan boarding, etc.

1. Experience with Azure including DevOps, Data Factory, SQL or other cloud-based data warehouse.
2. Experience in designing, developing, and testing ETL processes using SSIS.
3. Experience with scripting languages such as PowerShell, VB script, python.
4. Experience with Fivetran and Snowflake is a plus.
5. Perform SQL query tuning and performance optimization on complex inefficient queries.

8. Strong prioritization and organizational skills, including the ability to maintain several concurrent activities while managing user expectations.
9. Able to work independently and effectively in a fast-paced environment without daily oversight.
10. Excellent verbal and written communication skills

Desired Education/Experience: The ideal candidate should be a highly successful mortgage servicing professional with at least 3 years of experience in the Mortgage Technology or Servicing Sector. The candidate should bring the following:

1. Bachelor's Degree in Business, Computer Science, or related fields or comparable experience and training
2. 3+ years SQL, SQL Server Agent Jobs, SSRS, ETL, stored procedures, triggers, table creation, etc.
3. 2+ years Mortgage Experience
4. Remote candidates should have 2+ years remote experience collaborating with teams across multiple time zones

Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S.

Other Duties: This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned to meet the needs of the organization.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction.

[EOE/M/F/D/V. Drug-free workplace.]

#LI-KZ1

#LI-REMOTE