A Typical Day
The Portfolio Strategy group is responsible for asset management, portfolio oversight and best execution of servicing strategies. This role requires the application of financial concepts and active monitoring of Key Performance Indicators (KPIs) as it relates to the operational performance of Pennymac’s loan portfolio. The primary function of Portfolio Strategy Analyst II is to support management on multiple areas within Portfolio Strategy with recurring reporting, ad hoc analysis, build out of new reporting and analysis to support new business lines, and handle conversions based on changing datastructures. The analyst is expected to perform analysis with an undergraduate level understanding of financial concepts.
The Portfolio Strategy Analyst will:
- Responsible for various recurring, and non-recurring reports that require data preparation and querying using MS Excel, MS SQL and Snowflake
- Execute Snowflake and MS SQL jobs on a regular basis and as required to make sure data is available for reporting and analysis
- Edit code behind existing Snowflake and MS SQL jobs as necessary to support changing needs
- Transform and enhance data, reporting and queries used by the team whenever there are changes to data structure or market/business conditions
- Create new tables and views in Snowflake as necessary to support reporting and analysis
- Apply financial concepts to improve loss mitigation strategies
- Create slides and PowerPoint presentations that capture new strategies, portfolios, risks, or opportunities as outlined by leadership
What You’ll Bring
- Bachelor's degree (Finance, Statistics, Math, Science or Engineering Majors preferred) and entry level priorwork experience
- Excellent critical thinking, problem solving (quantitative, conceptual and analytical), and mathematical skillsalong with sound judgment
- Must be a team player with strong attention to detail and able to work independently
- Proven track record at delivering timely and accurate information in a fast-paced environment
- Highly Proficient of MS Excel, Word and PowerPoint
- Proficient in querying data using MS SQL or Snowflake
- Financial Services and, if possible, mortgage industry experience preferred
- Strong business acumen and ability to interface with executive management
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$65,000 - $100,000
Work ModelOFFICE