Manager Financial Planning and Analysis
About The Position
PENNYMAC Pennymac is (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 homeownership through the complete mortgage journey. A Typical Day We are seeking a highly skilled and innovative Manager Financial Planning and Analysis 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 Manager Financial Planning and Analysis - Data & Automation Focus will: Snowflake Data Architecture: Design, build, and maintain scalable Snowflake databases for FP&A, ensuring data integrity via modeling and ETL. Predictive Analytics & Insights: Develop tools to assist with the analysis of large datasets to identify trends and anomalies, developing predictive models (forecasting) for strategic planning. FP&A Process Automation: Proactively automate workflows using Snowflake, scripting (Python, SQL), PowerQuery and BI tool integration. Data-Driven Reporting & Analysis: Develop automated BI dashboards and reports from for KPI tracking, variance analysis, and actionable insights. Collaborative Data Solutions & Communication: Partner to understand data needs, translate them into analytical solutions, and clearly present findings. Why You Should Join 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.
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
- Snowflake Data Architecture: Design, build, and maintain scalable Snowflake databases for FP&A, ensuring data integrity via modeling and ETL.
- Predictive Analytics & Insights: Develop tools to assist with the analysis of large datasets to identify trends and anomalies, developing predictive models (forecasting) for strategic planning.
- FP&A Process Automation: Proactively automate workflows using Snowflake, scripting (Python, SQL), PowerQuery and BI tool integration.
- Data-Driven Reporting & Analysis: Develop automated BI dashboards and reports from for KPI tracking, variance analysis, and actionable insights.
- Collaborative Data Solutions & Communication: 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Manager
Industry
Real Estate
Number of Employees
1,001-5,000 employees
