"Alerted.org

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 homeownership through the complete mortgage journey.

A Typical Day

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 of key statistical information and performance metrics, preparing various reporting views, gathering requirements for new reporting, organizing and presenting data to multiple levels of management.

The Senior Reporting Analytics Analyst will :

+ Design, develop, and optimize Snowflake SQL scripts, stored procedures, and views to support business reporting needs.

+ Build and manage Snowflake Tasks for data orchestration and automation.

+ Utilize SQL 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 analysts/Mgr of the Data Management team

+ Design and develop new reports as needed by Operations teams and PNMAC upper management

+ Transfer and standardize data using Extract, Transfer, Load (ETL), and Secure File Transfer Protocol (SFTP)

+ 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

What You’ll Bring

+ Experience with Snowflake development and Strong proficiency in Snowflake SQL, including complex joins, CTEs, window functions, and dynamic SQL.

+ Excellent skills in use of SQL 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

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.

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 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

To learn more about our benefits visit: https://pennymacnews.page.link/benefits

For residents with state required benefit information, additional information can be found at: https://www.pennymac.com/additional-benefits-information

Compensation: Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below:

+ Lower in range - Building skills and experience in the role

+ Mid-range - Experience and skills align with proficiency in the role

+ Higher in range - Experience and skills add value above typical requirements of the role

Some roles may be eligible for performance-based compensation and/or stock-based incentives awarded to employees based on company and individual performance.

Salary

$68,000 - $115,000

Work Model

OFFICE