Reporting Analytics Senior Analyst (On-Site)

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 The Senior Analyst acts as a technical analytics leader, designing, developing, and delivering data-driven solutions that support enterprise reporting, performance measurement, and strategic decision-making. This role partners closely with business stakeholders, data engineering teams, and leadership to translate complex business requirements into scalable, high-quality analytical solutions that drive actionable insights and operational efficiency. This role requires deep, hands-on expertise in Snowflake SQL development, including complex query optimization, stored procedure development, and deployment across environments. The Senior Business Analyst also develops and maintains SSIS packages for data ingestion and transformation while ensuring data quality, reliability, and scalability of analytical solutions. As a Senior Analyst, you will be the architect of our data's "Source of Truth." You are responsible for the end-to-end journey of data: from ingestion (internal and external sources) to the creation of standardized "Hubs" layers. This is a high-impact, hands-on role where you will ensure our data is normalized, performant, and always available. You don't just analyze data; you build the robust systems that make analysis possible. The Senior Analyst will: Data Architecture & Modeling: Design and implement the "Hub" layer to standardize and normalize disparate data sources into a unified schema. Data Normalization: Identify and resolve data quality issues at the source, ensuring consistent naming conventions and logic across the Hub layer. Performance Tuning: Optimize SQL queries and data structures within Snowflake/SQL Server to handle high-volume processing with minimal latency. Pipeline Management: Develop and maintain robust ETL/ELT processes to ingest data from internal databases and external third-party APIs. Reliability & Uptime: Take ownership of data availability. Monitor pipeline health and implement automated checks to ensure 100% uptime for downstream consumers. Cross-Functional Liaison: Work with stakeholders to understand business logic and translate it into scalable data models. Experience: 3+ Years in a highly technical data role (Analytics Engineer, Data Engineer, or Technical BA). SQL Mastery: Advanced SQL skills are non-negotiable (Window functions, complex joins, DDL/DML, and performance optimization). Data Modeling: Practical experience with normalization, Star Schema, or Data Vault (Hubs/Satellites) methodologies. Tools: Deep experience with Snowflake ETL tools (e.g., SSIS) a plus. Resilience: A "DevOps" mindset toward data-prioritizing uptime, error handling, and alerting. Source Integration: Experience handling JSON/XML from external APIs and converting it into structured relational tables. On-site requirement (Not remote or hybrid) What You'll Bring Excellent skills in use of SQL to gather data from a variety of sources Highly proficient skills with MS Office, including Excel, Word, and PowerPoint Financial Services and, if possible, mortgage industry experience preferred Experience in meeting and presenting to Senior Management 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: For residents with state required benefit information, additional information can be found at: 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