Mortgage Reporting Engineer and Developer

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 at work. Our 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 accuracy of mortgage systems data, overseeing ETL processes, and coordinating the retrieval of non-mortgage enterprise data from sales, accounting, HR, and CRM systems.
• Lead and drive the full Software Development Life Cycle:
  • Requirements gathering
  • Technical design
  • Development
  • Unit testing
  • System/integration testing
  • User acceptance testing
  • Deployment
  • Training Documentation
  • Provide production support to remediate data discrepancies
• Play a key role in the development of the Mortgage IT roadmap and identify strategic initiatives, pulling from experience and constant research of industry best practices and new technologies
• All other duties as assigned

This is an excellent opportunity to join one of the nation's most respected Fortune 500 companies!

Qualifications

Does this describe you?

• Self-motivated with the ability to work independently and/or as part of a team
• Strong analytical and problem-solving skills
• Attention to detail and data accuracy
• Excellent verbal, written, and presentation skills with all levels of the organization
• A student of innovation, with a long history of implementing new and improved functionality and processes
• Ability to multitask and manage multiple projects concurrently, shifting priorities as required to meet business requirements and deadlines with a diverse group of stakeholders

Do you have these qualifications?This is a hands-on position requiring strong technical skills, data engineering experience,reporting expertise, and the ability to understand complex mortgage business processes.

• Essential:
  • 5 + years designing, developing, and implementing data / reporting architectures supporting real time data
  • 3+ years hands on experience with Azure data services and Fabric
  • 7+ years with extreme proficiency in T-SQL, including complex queries, advanced functions, stored procedures, ETL processes with complex data transformations from multiple systems, and debugging, including a strong understanding of relational database design, data modeling, schemas, keys, relationships, and normalization.
  • 5+ years data integration using APIs and JSON to design and develop datasets and structures to support Power BI, with strong data validation, reconciliation, and data-quality skills, including the ability to identify and resolve data discrepancies across multiple source systems
  • 5+ years advanced developing complex enterprise Power BI reports used for operations, metrics/KPIs, exceptions, auditing, and real time dashboards, including advanced DAX, Power Query/M, semantic data model development and optimization, and Power BI service administration
  • 2+ years using Power Platform including Power Apps and Power Automate
  • Proven experience developing reports using Crystal Reports, SSIS, and Business Objects
  • Experience leveraging AI-enabled solutions, API-driven automation, and emerging technologies that support business and technology objectives.
  • Ability to work onsite at our Corporate office located in Fort Washington PA
• Preferred:
  • Bachelor’s degree in Computer Science, Information Systems, or Data Analytics
  • PL – 300 , DP – 600, DP – 700, or AZ – 305 Certification
  • Experience using ICE Encompass Developer Connect and leveraging APIs for automation
  • Experience with Fivetran, Coalesce, Snowflake, and Azure integration Services
  • Familiarity with Javascript, .Net, and C# and VB.Net with experience developing Microsoft applications / webapps
  • Experience with Mortgage Banking Operations, Secondary, or Production

We offer an excellent benefits package, including medical, dental, 401(k) with a company match, discounted stock purchase, discounts on mortgages, homes, appliances, and much more!Come see why Toll Brothers Mortgage has been attracting and retaining some of the best professionals in the industry! APPLY ONLINE TODAY!

For more Company information, visit: www.tbmortgage.com

Toll Brothers is committed to ensuring equal employment opportunity. All employment decisions, policies, and practices are in accordance with applicable federal, state, and local anti-discrimination laws. Toll Brothers will not engage in or tolerate unlawful discrimination (including any form of unlawful harassment) on account of a person's sex (including pregnancy), age, race, color, religion, national origin, ancestry, citizenship, physical or mental disability, sexual orientation, gender nonconformity, status as a transgender individual, gender identity, genetic information, marital status, family responsibility, armed services, or any other status protected by law.