Data Product Analyst II at Pennymac

Cary, North Carolina, United States -

Full Time

Start Date

Immediate

Expiry Date

29 Jun, 26

Salary

0.0

Posted On

31 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Analysis, Data Visualization, Marketing Data, Sales Data, Jira, Confluence, Data Engineering, AI Tools, Snowflake, Data Pipelines, Functional Testing, User Stories, Data Integrity, Scrum, Data Orchestration

Industry

Financial Services

Description

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 As a Product Analyst II on our Data Products team, you aren't just managing tickets, you’re the bridge between complex data architecture and actionable business value. You will sit at the intersection of Marketing and Sales data, leveraging modern AI tools and Snowflake to build products that drive revenue. We move fast, use Cursor to accelerate our workflows, and expect you to be as comfortable in a SQL console as you are in a stakeholder meeting. The Product Analyst II will: Own the translation of Marketing and Sales business questions into technical data requirements and user stories. Collaborate with engineers to optimize data pipelines running in Snowflake, ensuring data integrity and performance for end-user products. Perform "Pre-Discovery" by querying datasets directly to validate business assumptions before they hit the dev backlog. Actively drive Scrum ceremonies, ensuring user stories have clear technical acceptance criteria and a solid "Definition of Done." Interface with Marketing and Sales leadership to turn vague requests into structured data roadmaps. Conduct functional testing on data outputs to ensure logic matches business rules before UAT. 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 Strong SQL skills are non-negotiable. You should be comfortable navigating schemas and understanding data relationships. Familiarity with Cursor or similar AI-assisted development environments. You should know how to use LLMs to work smarter and faster. Experience working with Marketing (e.g., attribution, lead gen) or Sales (e.g., CRM, pipeline) data. Advanced proficiency in Jira and Confluence; experience structuring complex epics for data engineering teams. 3+ years of experience in an analytical role, preferably within a Data Product or FinTech environment. Experience with dbt or data orchestration tools. Background in Financial Services or Mortgage. Ability to build quick visualizations to "prove" a concept before full-scale development. 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

Responsibilities

The Product Analyst II will translate Marketing and Sales business questions into technical data requirements and collaborate with engineers to optimize data pipelines. They will also conduct functional testing on data outputs to ensure alignment with business rules.