SQL/Snowflake Developer II

Pennymac-posted 4 months ago

$65,000 - $100,000/Yr

Full-time

Fort Worth, TX

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

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.

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)
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

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

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

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

Snowflake Developer Resume Examples

•

Snowflake Developer Cover Letter Examples

SQL/Snowflake Developer II

Job Search Resources

Tools

Career Hubs

Guides

Company