Mortgage Reporting Engineer and Developer

About the Role

Toll Brothers Mortgage, America's Leading Luxury Lender, seeks a Mortgage Reporting Engineer and Developer to join our Mortgage IT organization at our Corporate office in Fort Washington, Pennsylvania. This role is responsible for designing, developing, maintaining, and modernizing data and reporting solutions to support the mortgage business. The position offers an opportunity to play a key role in the transformation of our data and reporting architecture, leveraging best-in-class technologies at an enterprise scale.

Responsibilities

• Document, design, develop, and maintain a 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 understand mortgage processes, terminology, data relationships, and reporting requirements, translating them into technical solutions.
• Collaborate with application developers to understand APIs and data structures, ensuring accurate data flow from source systems to Power BI reports.
• Analyze and convert legacy Crystal Reports and their SQL logic into the new reporting architecture for Power BI.
• Serve as the Mortgage data steward/liaison to Enterprise Data Strategy, Azure Integration Services, and Database Services teams, ensuring data accuracy and coordinating ETL processes.
• Lead the full Software Development Life Cycle (SDLC), including requirements gathering, technical design, development, testing, deployment, and documentation.
• Provide production support to resolve data discrepancies.
• Contribute to the Mortgage IT roadmap by identifying strategic initiatives and researching industry best practices.

Qualifications

• 5+ years designing, developing, and implementing real-time data/reporting architectures.
• 3+ years hands-on experience with Azure data services and Fabric.
• 7+ years of extreme proficiency in T-SQL, including complex queries, stored procedures, ETL processes, and relational database design.
• 5+ years of data integration using APIs and JSON to support Power BI, with strong data validation and reconciliation skills.
• 5+ years developing complex Power BI reports, including advanced DAX, Power Query/M, and semantic model optimization.
• 2+ years using Power Platform (Power Apps, Power Automate).
• Proven experience with Crystal Reports, SSIS, and Business Objects.
• Ability to leverage AI-enabled solutions and API-driven automation.
• Onsite work at the Fort Washington, PA office is required.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or Data Analytics.
• PL-300, DP-600, DP-700, or AZ-305 Certification.
• Experience with ICE Encompass Developer Connect, Fivetran, Coalesce, Snowflake, and Azure Integration Services.
• Familiarity with JavaScript, .Net, C#, and VB.Net, including Microsoft application/webapp development.
• Experience with Mortgage Banking Operations, Secondary, or Production.

Skills

• Self-motivated with strong analytical and problem-solving skills.
• Attention to detail and data accuracy.
• Excellent verbal, written, and presentation skills.
• Ability to multitask, manage multiple projects, and adapt to shifting priorities.

Benefits

• Medical and dental insurance.
• 401(k) with company match.
• Discounted stock purchase.
• Discounts on mortgages, homes, and appliances.

Join Toll Brothers Mortgage and be part of a respected Fortune 500 company committed to innovation, diversity, and excellence.