Mgr, FP&A

Pennymac • Westlake Village, CA

87d • $75,000 - $130,000

About The Position

Pennymac 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 homeownership through the complete mortgage journey. We are seeking a highly skilled and innovative FP&A Manager to join our dynamic team. This data-driven role will leverage expertise in local and cloud-based data warehousing solutions, especially Snowflake (or similar tools), to drive insightful financial analysis and build automated modeling, reporting and analysis processes supporting the FP&A function. The FP&A Manager - Data & Automation Focus will design, build, and maintain scalable Snowflake databases for FP&A, ensuring data integrity via modeling and ETL. Additionally, the role involves developing tools to assist with the analysis of large datasets to identify trends and anomalies, developing predictive models for strategic planning, and proactively automating workflows using Snowflake, scripting (Python, SQL), PowerQuery and BI tool integration. The position also requires developing automated BI dashboards and reports for KPI tracking, variance analysis, and actionable insights, as well as collaborating with partners to understand data needs and present findings clearly.

Requirements

• Bachelor's in Finance, Accounting, Economics, Data Science, or a related quantitative field (Master's preferred).
• Minimum 5-7 years progressive experience with a strong focus on data manipulation and database management with applications for financial modeling and reporting, and automation of reporting and analysis processes.
• Essential proficiency in Snowflake, including hands-on experience with data modeling, SQL, performance tuning, and leveraging its features.
• Advanced proficiency in Microsoft Excel & Google Sheets.
• Experience with Microsoft PowerQuery and scripting languages like Python or SQL for data manipulation and automation is highly desirable.
• Excellent analytical, problem-solving, and critical-thinking skills with strong attention to detail.
• Strong communication and presentation skills, capable of explaining technical concepts to diverse audiences.

Responsibilities

• Design, build, and maintain scalable Snowflake databases for FP&A, ensuring data integrity via modeling and ETL.
• Develop tools to assist with the analysis of large datasets to identify trends and anomalies, developing predictive models for strategic planning.
• Proactively automate workflows using Snowflake, scripting (Python, SQL), PowerQuery and BI tool integration.
• Develop automated BI dashboards and reports for KPI tracking, variance analysis, and actionable insights.
• Partner to understand data needs, translate them into analytical solutions, and clearly present findings.

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: Mid Level
• Education Level: Bachelor's degree