Reporting Analytics Senior Analyst

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 Senior Analyst is the technical engine behind our Multi-Touch Attribution (MTA) strategy. You will be responsible for architecting the logic that maps the customer journey to enterprise performance. This role requires strong Snowflake SQL expertise—moving beyond simple querying into the development of complex stored procedures, dynamic tables, and automated data pipelines. You won't just report data; you will build the models that dictate how we invest our capital across marketing and operational channels.

The Senior Reporting Analytics Analyst provides reporting and analytical support for operations employees who execute transactions and operations managers responsible for the performance of their respective teams. As the Senior Analyst
, your responsibilities include developing and tracking key statistical information and performance metrics, preparing various reporting views, gathering requirements for new reporting, organizing and presenting data to multiple levels of management.

• Design, develop, and maintain complex Snowflake SQL code, including stored procedures (SPs), to support analytics, attribution modeling for reporting needs.
• Optimize queries and data models to support large-scale attribution and customer-level analytics.
• Manage and support Snowflake deployments, including version control, promotion across environments (dev/test/prod), and deployment validation.
• Utilize SQL and Snowflake to query various databases for responses to ad-hoc data requests.
• Research data tables to gather relevant data for new reports.
• Provide analytical support to Operations employees, Operations Managers, and Senior Managers of the Data Management team.
• Design and develop new reports as needed by Operations teams and PNMAC upper management.
• Conduct User Acceptance Testing for system updates, data migrations, and database/schema changes.
• Perform other related duties as required and assigned.
• Demonstrate behaviors which are aligned with the organization’s desired culture and values.

• Strong skills in use of SQL and Snowflake to gather data from a variety of sources.
• Highly proficient skills with MS Office, including Excel, Word, and PowerPoint.
• Financial Services and, if possible, mortgage industry experience preferred.
• Experience in meeting and presenting to Senior Management.
• Design, develop, and maintain Multi-Touch Attribution models (e.g., linear, time-decay, position-based, algorithmic) to measure the impact of customer and marketing touchpoints across channels.
• Partner with Marketing and Digital teams to translate attribution insights into actionable recommendations for channel optimization and budget allocation.
• Develop advanced analytical models to support forecasting, performance measurement, and strategic decision‑making.

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.

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…