SQL/Snowflake Developer II

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 SQL/Snowflake Developer will provide technical support to Project Leads and Managers, with a heavy focus on translating requirements for new or existing processes into new ETLs, stored procedures, view, tables and other database objects. As the Developer, your responsibilities will also include conducting QA testing, providing support for business partners with ad-hoc needs requests and organizing and presenting data to business partners. The SQL/Snowflake Developer will: Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors Design and develop ETLs/ELTs to move data across internal servers utilizing input variables for easier deployment to different environments (e.g., SSIS, Aiflow, Fivetran, Matillion) Design and develop ETLs/ELTs to move data across external SFTP/APIs utilizing input variables for easier deployment to different environments Apply ETL error handling and package logging that stores results into SQL/Snowflake tables for ease of troubleshooting Utilize Snowflake features (e.g., Snowpipe, Streams, Tasks) and external tools to build automated and reliable data pipelines Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable) Experience in Snowflake and knowledgeable of cloud services such as Snowflake, Amazon AWS and Microsoft Azure Follow strict Software Development Life Cycle development and implementation guidelines Participate in internal QA testing for team development processes Participate in code reviews and contribute to team knowledge sharing Stay up-to-date with the latest Snowflake features and best practices Participate in on-call rotation and monitor/troubleshoot production issues for AWS SQL server and Snowflake environments 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 3+ years of MS SQL database and SQL Information Services knowledge and development experience 3+ years of Snowflake knowledge and development experience Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions Experience with SSIS, Informatica or other Snowflake Integration ETL tools Programming experience with emphasis on designing complex SQL queries and automation using scripting languages such as python and business components Experience with version control systems (e.g., Gitlab, Github, TFS, Azure Dev Ops) and CI/CD pipelines for data solutions Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management Ability to monitor and investigate and resolve data-related issues, pipeline failures, and performance problems in a timely manner Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision Proven track record at delivering timely and accurate information in a fast-paced environment Financial Services and, if possible, mortgage industry experience preferred 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 $65,000 - $100,000 Work Model OFFICE