Reporting Analytics Analyst III

About the position

The Business Analyst III - Reporting & Analytics provides reporting and analytical support for operations employees who execute transactions and operations managers responsible for the performance of their respective teams. As the Reporting & Analytics Analyst, you will develop and track key statistical information and performance metrics, prepare various reporting views, gather requirements for new reporting, organize and present data to multiple levels of management.

Responsibilities

• 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
• Build and modify Special Tools, Applications, and Stored Procedures
• 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
• Utilize Business Intelligence (e.g. SQL, Snowflake, Tableau) software to create visual presentations and new dashboards for use by Operations managers and Senior Managers
• Perform other related duties as required and assigned

Requirements

• Strong skills in use of SQL and Snowflake
• Highly proficient skills with MS Office, including Excel, Word, and PowerPoint
• Experience using Tableau or other BI Tools a plus
• Financial Services and, if possible, mortgage industry experience preferred

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