VP Data and Analytics

Pennymac • Carrollton, TX

1d • $95,000 - $155,000 • Onsite

About The Position

The Vice President Data and Analytics is the strategic and technical architect of our marketing ecosystem. Unlike traditional analytics leaders, this role requires a heavy 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."

Requirements

• SQL & Snowflake Expertise: You must be highly proficient in writing and debugging complex SQL at an enterprise scale. You have a deep understanding of Snowflake-specific features like Window Functions, CTEs, Flattening (JSON/XML), and Stored Procedure (Javascript 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.

Responsibilities

• 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 to Snowflake Dynamic Tables to 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

Benefits

• Comprehensive Medical, Dental, and Vision
• Paid Time Off Programs including vacation, holidays, illness, and parental leave
• Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations)
• Retirement benefits, life insurance, 401k match, and tuition reimbursement
• Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships

What This Job Offers

• Job Type: Full-time
• Career Level: Executive
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees