Pennymac is looking for a SQL/Snowflake Developer to provide technical support for new and existing processes, focusing on translating requirements into database objects and ETLs, and ensuring data quality and accessibility for business partners.
Requirements
- 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 monitor and investigate and resolve data-related issues, pipeline failures, and performance problems in a timely manner
Responsibilities
- 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.
- Conducting QA testing, providing support for business partners with ad-hoc needs requests and organizing and presenting data to business partners.
- 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
Other
- Demonstrate behaviors which are aligned with the organization’s desired culture and values
- Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management
- 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
