OverviewToll 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!
QualificationsDoes 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
