Mortgage Reporting Engineer and Developer

Location: Fort Washington

Overview

Join an award-winning company!

Who are we?

Since 1967, Toll Brothers has been building luxury homes and communities in the best locations in the U.S. Today, we’re a Fortune 500 company operating in over 60 markets. We’re the country’s premier luxury builder with the widest range of product offerings and price points in the industry, serving first-time, move-up, active-adult, and second-home buyers.

From the homes we build to the talent we recruit, we know that to be the best, we have to work with the best. Toll Brothers is a place where diverse perspectives and experiences are welcomed and where employees of all backgrounds are treated with fairness, dignity and respect. We believe every employee should feel safe to be their true and authentic self  employees are our family, and we strive to uphold the values that our founders instilled in us, creating an exceptional place to work that is inclusive to all.

Toll Brothers Mortgage, America's Leading Luxury Lender, seeks a Mortgage Reporting Engineer and Developer for our team at our Corporate office located in Fort Washington, Pennsylvania.

What is the opportunity?

We are seeking an experienced Mortgage Reporting Engineer and Developer to join our Mortgage IT organization. This position will be responsible for designing, developing, maintaining, and modernizing the data and reporting solutions supporting the mortgage business.

Our Mortgage IT organization operates as a technology partner embedded within the Toll Brothers Mortgage business unit and is responsible for mortgage-specific applications, vendor integrations, reporting, data solutions, and the full Software Development Life Cycle (SDLC) for these systems. We partner with Enterprise IT and as well as Enterprise Data Strategy and Development. These critical partners respectively provide
1) enterprise Azure infrastructure, networking, information security, hardware, and database administration services and
2) ETL and data warehousing.

Both the Toll Mortgage Business Unit and Toll Brothers Enterprise are undergoing significant modernization of its data and reporting architecture. This is an opportunity to play a key role in this transformation, having an impact on the infrastructure design and reporting output using best of class technologies at an Enterprise scale, but also directly responsible for output of all Mortgage reporting needs.

Primary Responsibilities Document, design, develop, and maintain a new and modernized Toll Brothers Mortgage reporting infrastructure, data warehouse, ETL functions and reports for operations, metrics/KPIs, auditing, and real time dashboards.

Work closely with Mortgage Operations, Underwriting, Closing, Post-Closing, Loan Production, and Compliance to develop a strong understanding of the Toll Mortgage processes, terminology, mortgage lifecycle data relationships, and reporting requirements, translating these reporting requirements into technical data and reporting solutions.

Work with application developers to understand APIs and application data structures to extract, transform and load the required data flow from source systems through the data infrastructure to ultimately produce Power BI reports that fulfill business requirements.

Analyze the organization's existing portfolio of Crystal Reports and identify their underlying SQL, data sources, business rules, calculations, and dependencies. Convert legacy Crystal Reports and their associated SQL logic into the new reporting architecture for presenting in Power BI.Serve as the Mortgage data steward/liaison to the following enterprise teams
1) Data Strategy and Development
2) Azure Integration Services and
3) Database services. The liaison will serve as the SME, ensuring the inclusion and…