VP of Data & Analytics - Snowflake Mortgage Analytics

PENNYMAC

Pennymac (NYSE: PFSI) is a specialty financial services firm with a comprehensive mortgage platform and integrated business focused on the production and servicing of U.S. mortgage loans and the management of investments related to the U.S. mortgage market.

At Pennymac, our people are the foundation of our success and at the heart of our dynamic work culture. Together, we work towards a unified goal of helping millions of Americans achieve aspirations of home ownership through the complete mortgage journey.

The Vice President Data and Analytics is the strategic and technical architect of our marketing ecosystem. Unlike traditional analytics leaders, this role requires aheavy technical foundation in Snowflake and SQL. You will lead a high-performing team of Senior Analysts personally overseeing the design of complex data pipelines, stored procedures, and attribution logic that serves as the company’s revenue "Source of Truth."

The Vice President Data and Analytics will oversee the development, distribution and utilization of data and metrics to predict, improve and measure the success of fundamental risks to the mortgage servicing operation. As the VP Analytics,Unlike traditional analytics leaders, this role requires aheavy technical foundation in Snowflake and SQL. You will lead a high-performing team of Senior Analysts and Engineers, personally overseeing the design of complex data pipelines, stored procedures, and attribution logic that serves as the company’s revenue "Source of Truth."

The VP Data and Analytics will:

• Reviewing and approving complex Snowflake and SQL logic and Stored Procedure frameworks to ensure scalability and query efficiency.

• Deep-diving into SQL code with your Senior Analysts to solve performance bottlenecks .

• Evaluating the transition from legacy Stored Procedures toSnowflake Dynamic Tablesto improve data freshness and reduce cost.

• Evaluate, recommend and implement strategies for developing and utilizing data and metrics to predict, improve and measure the success of fundamental risks to the mortgage servicing operation

• Provide oversight of Data Mart, which is responsible for the storage and transformation of enterprise information
• Perform other related duties as required and assigned
• Demonstrate behaviors which are aligned with the organization’s desired culture and values

• SQL & Snowflake Expertise:You must be highly proficient inwriting and debugging complex SQLat an enterprise scale. You have a deep understanding of Snowflake-specific features likeWindow Functions, CTEs, Flattening (JSON/XML), and Stored Procedure (Java script or SQL) development.

• Own the mathematical and technical design of our Multi-Touch Attribution (MTA), ensuring the code correctly reflects complex customer touchpoints across digital and offline channels.

• 5+ Years of Data Leadership:A track record of leading technical teams where you have personally designed or overseen the construction of large-scale data warehouses.

• Mortgage or Financial Services Experience:Ability to navigate the data complexities of the financial sector, including long sales cycles and regulatory data handling.

As one of the top mortgage lenders in the country, Pennymac has helped over 4 million lifetime homeowners achieve and sustain their aspirations of home. Our vision is to be the most trusted partner for home. Together, 4,000 Pennymac team members across the country are guided by our core values: to be Accountable, Reliable and Ethical in all that we do.

Pennymac is committed to conducting a business that makes positive contributions and promotes long-term sustainable growth and to fostering an equitable and inclusive environment, where all employees and customers feel valued, respected and supported.

Benefits That Bring It Home: Whether you're looking for flexible benefits for today, setting up short-term goals for tomorrow, or planning for long-term success and retirement, Pennymac's benefits have you covered. Some key benefits include:

• Comprehensive Medical, Dental, and Vision
• Paid Time Off Programs including vacation, holidays, illness, and parental leave
• Wellness…