Reporting Analytics Senior Analyst
About The Position
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. Job Overview The Senior Business Analyst serves as a technical analytics leader responsible for designing, developing, and deploying data-driven solutions that support enterprise reporting, performance measurement, and strategic decision-making. Working closely with stakeholders, engineering teams, and leadership, this role translates business requirements into robust technical implementations that drive actionable insights and operational efficiency. A Typical Day Senior Business Analyst The Senior Business Analyst is responsible for delivering advanced business analysis and data modeling to support key statistical insights and business performance metrics. In this role, you will actively participate in strategic departmental discussions and provide data-driven insights that inform management decisions and drive overall business strategy. This role requires deep hands-on expertise in Snowflake SQL development, including complex query optimization, stored procedure (SP) development, and deployment across environments. The Senior Business Analyst develops and maintains SSIS packages for data ingestion and transformation, performs advanced data analysis and modeling, and ensures data quality, reliability, and scalability of analytical solutions
Requirements
- Strong experience with complex data analysis, modeling, and reporting.
- Proficiency in Snowflake SQL development and SSIS packages.
- Ability to translate complex data into clear, actionable business insights.
- Proven leadership and cross-functional collaboration skills.
- 5+ years of relevant work experience
- Excellent skills in use of SQL to gather data from a variety of sources
- Proficiency in Snowflake SQL development and SSIS packages.
- Highly proficient skills with MS Office, including Excel, Word, and PowerPoint
- Experience in meeting and presenting to Senior Management
- Bachelor's degree or equivalent work experience
- Excellent critical thinking, problem solving, mathematical skills and sound judgment
Nice To Haves
- Financial Services and, if possible, mortgage industry experience preferred
- Financial Services and, if possible, mortgage industry experience preferred
Responsibilities
- Respond to ad-hoc data requests by querying data sources and creating reporting views.
- Organize, analyze, and present data-driven insights and analytical findings to management.
- Develop and perform complex analytical models to support business decision-making.
- Design, develop, and maintain Snowflake SQL code, including stored procedures (SPs), to support analytics and reporting needs.
- Manage and support Snowflake deployments, including version control, promotion across environments (dev/test/prod), and deployment validation.
- Collaborate with internal and external business partners to deliver enterprise-level initiatives and projects.
- Lead and mentor a team supporting strategic departmental and divisional projects.
- Ensure analytical deliverables align with organizational goals, culture, and values.
- Perform other related duties as assigned
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
Mid Level
Number of Employees
5,001-10,000 employees
