Job Summary:
Pennymac is a specialty financial services firm focused on the production and servicing of U.S. mortgage loans. The Portfolio Strategy Analyst II supports management with reporting and analysis related to the operational performance of the loan portfolio, utilizing financial concepts and data management tools.
Responsibilities:
โข 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
Qualifications:
Required:
โข Bachelor's degree (Finance, Statistics, Math, Science or Engineering Majors preferred) and entry level prior work experience
โข Excellent critical thinking, problem solving (quantitative, conceptual and analytical), and mathematical skills along 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
โข Strong business acumen and ability to interface with executive management
Preferred:
โข Financial Services and, if possible, mortgage industry experience
Company:
Pennymac is a home loan lending company that offers financial services. Founded in 2008, the company is headquartered in Westlake Village, USA, with a team of 1001-5000 employees. The company is currently Late Stage.