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.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Junior Application Developer (Onpeak) (Remote)
Recruited by onPeak 9 months ago
Address Las Vegas, NV, United States
Pl/Sql & Java Developer / 100% Remote
Recruited by Motion Recruitment 10 months ago
Address Las Vegas, NV, United States
Python Developer Jobs
Recruited by Mindpal 10 months ago
Address Henderson, NV, United States
Sql Developer-Mortgage Jobs
Company | PENNYMAC |
Address | Summerlin South, NV, United States |
Employment type | FULL_TIME |
Salary | |
Category | Financial Services |
Expires | 2023-05-25 |
Posted at | 1 year ago |
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.
- Strong business acumen and ability to interface with executive management
- Ability to collaborate with other developers, business analysts, project managers, business users, vendors, and management
- Organize, prepare, and present data to senior management
- Architect ETL enhancements to increase the performance data warehouse using query manager and optimizer
- Apply ETL error handling and package logging that stores results into SQL tables for ease of troubleshooting
- Optimize query performance tuning by reading executing plans, maintaining indexes, database refactoring (making code more efficient and maintainable)
- Conduct peer code review on ETL, stored procedures, views, functions to identify performance problems, inadequate programming and data duplication and suggest a remediation path
- Provide leadership, training, and oversight of other analysts' activities, deliverables, and performance
- Knowledgeable of cloud services such as Snowflake, Amazon AWS and Microsoft Azure
- Financial Services and, if possible, mortgage industry experience preferred
- Design and develop ETLs to move data across internal servers utilizing input variables for easier deployment to different environments
- Demonstrate behaviors which are aligned with the organization’s desired culture and values
- Programming experience with emphasis on designing complex SQL queries and business components
- Follow strict Software Development Life Cycle development and implementation guidelines
- Facilitate data retrieval and manipulation through implementation of views, stored procedures, triggers and cursors
- Proven track record at delivering timely and accurate information in a fast-paced environment
- 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
- Perform other related duties as required and assigned
- Design and develop ETLs to move data across external SFTP utilizing input variables for easier deployment to different environments
- Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing tables objects
- Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
- Experience with SSIS, Informatica or other ETL tools
- Deploy SSIS packages for ETL using Integration Catalog utilizing input variables for easier deployment to different environments
- Proactively research, present and make recommendations regarding new SQL features
- Paid Time Off Programs including vacation, holidays, illness, and parental leave
- Retirement benefits, life insurance, 401k match, and tuition reimbursement
- Wellness Programs, Employee Recognition Programs, and onsite gyms and cafe style dining (select locations)
- Comprehensive Medical, Dental, and Vision
- Philanthropy Programs including matching gifts, volunteer grants, charitable grants and corporate sponsorships
- 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
-
Systems Analyst - Excel, Xml, Sql, Scripting
By CyberCoders At Salt Lake City, UT, United States 8 months ago
-
(Senior) Finance & Shared Services Manager
By Catholics For Choice At Washington, DC, United States 8 months ago
-
Paralegal - Probate Administration
By CyberCoders At Miami, FL, United States 8 months ago
-
Account Executive - Automotive Software
By ECW Search At United States 8 months ago
-
Construction Project Coordinator Jobs
By CyberCoders At River Falls, WI, United States 8 months ago