Register
Recruit Create CV
Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Asp.net Developer Jobs
Recruited by Dealer Car Search 9 months ago Address , Louisville
Powerbi Developer Jobs
Recruited by Macro Solutions 9 months ago Address , Winchester, 22602
J2Ee Developer Jobs
Recruited by Objects On Net 9 months ago Address , Fayetteville, 30214, Ga
Datastage Developer Jobs
Recruited by USM Business Systems 10 months ago Address Columbus, OH, United States
Dotnet Developer Jobs
Recruited by American Unit, Inc 10 months ago Address Mentor, OH, United States
Developer/Analyst (Njus) Jobs
Recruited by NetJets 11 months ago Address Columbus, OH, United States
Node.js Developer Jobs
Recruited by iFour Technolab 1 year ago Address , Brownsburg, In
Account Developer Jobs
Recruited by Coca-Cola Bottling Company Consolidated 1 year ago Address , Fredericksburg, 22406, Va $50,000 - $62,500 a year
Developer I Jobs
Recruited by DHL 1 year ago Address , Westerville, 43082, Oh

Sr.sql Developer Jobs

Company

Pennymac
Address , Summerlin, Nv
Employment type
Salary $79,000 - $131,500 a year
Expires 2023-07-26
Posted at 1 year ago
Job 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.
Job Overview:
As a senior SQL developer in the data-warehouse team, this role will be responsible for design, development, testing, and implementation of a set enterprise level data warehouse systems and solutions. This involves leading projects from a technical development perspective including oversight over junior SQL developers. This role requires following strict Software Development Life Cycle development and implementation guidelines. Responsibilities also include technical leadership and effective communication, conducting peer code review and suggesting remediation path, supporting business needs with ad-hoc needs requests and organizing and presenting data to multiple levels of management.
A Typical Day:
  • Deploy SSIS packages for ETL using Integration Catalog utilizing input variables for easier deployment to different environments
  • Follow strict Software Development Life Cycle development and implementation guidelines
  • Provide leadership, training, and oversight of other analysts' activities, deliverables, and performance
  • Architect ETL enhancements to increase the performance data warehouse using query manager and optimizer
  • Organize, prepare, and present data to senior management
  • Proactively research, present and make recommendations regarding new SQL features
  • Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable)
  • Demonstrate behaviors which are aligned with the organization’s desired culture and values
  • Perform other related duties as required and assigned
  • Design and develop ETLs to move data across internal servers utilizing input variables for easier deployment to different environments
  • Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors
  • Conduct peer code review on ETL, stored procedures, views, functions to identify performance problems, inadequate programming and data duplication and suggest a remediation path
  • Design and develop ETLs to move data across external SFTP utilizing input variables for easier deployment to different environments
  • Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
  • Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
  • Knowledgeable of cloud services such as Snowflake, Amazon AWS and Microsoft Azure
What You’ll Bring:
  • Financial Services and, if possible, mortgage industry experience preferred
  • Programming experience with emphasis on designing complex SQL queries and business components
  • Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
  • Ability to design, code, test, debug, package and deploy quality, scalable and well documented SQL solutions
  • 5+ years of MS SQL database and SQL Information Services knowledge and development experience
  • Proven track record at delivering timely and accurate information in a fast-paced environment
  • Strong business acumen and ability to interface with executive management
  • Experience with SSIS, Informatica or other ETL tools
  • Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and 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:
  • 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
  • Paid Time Off Programs including vacation, holidays, illness, and parental leave
  • Comprehensive Medical, Dental, and Vision

To learn more about our benefits visit: https://pennymacnews.page.link/benefits

Compensation: Individual salary may vary based on multiple factors including specific role, geographic location / market data, and skills and experience as defined below:
  • Mid-range - Experience and skills align with proficiency in the role
  • Lower in range - Building skills and experience 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: $79,000 - $131,500