Senior Database Developer
PennyMac, Westlake Village, CA, United States
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
Senior Database Developer
will be responsible for
design, development, testing, and implementation
of a set enterprise level
data warehouse systems
and solutions. As the
Database Developer , you will talk to users in
gathering requirements
and understand various internal/external dependencies that are very dynamic in nature and also require leadership across the full Systems Development Lifecycle as well as
expertise
in
Data Warehousing architecture data modeling and coding.
The
Senior Database Developer
will:
Design, develop and maintain relational and dimensional databases supporting the data warehouse and data marts Create entity relationship diagrams, data dictionaries and mapping documents Utilize
advanced transact-SQL , including
stored proc edures,
ETL
and
OLAP
tools to implement solutions Support implemented solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues Perform code inspections and re-factor code to meet standards Participate in data model reviews, walkthroughs, application and module performance analysis 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
2+ years in scripting languages such as
Perl, Python, Powershell
or programming languages such as
C# or Java Experience in developing
OLAP
cubes and data visualization technologies Ability to perform routine
DBA tasks
including setting up access policy,
data migrations ,
ETL operations , troubleshooting, and performance optimization Ability to scope out requirements, work with business side as well as tech side, etc Programming experience with emphasis on
designing complex SQL queries and business components Preferred:
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: https://pennymacnews.page.link/benefits
For residents with state required benefit information, additional information can be found at: https://www.pennymac.com/additional-benefits-information
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
$90,000 - $150,000 Work Model
OFFICE
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
Senior Database Developer
will be responsible for
design, development, testing, and implementation
of a set enterprise level
data warehouse systems
and solutions. As the
Database Developer , you will talk to users in
gathering requirements
and understand various internal/external dependencies that are very dynamic in nature and also require leadership across the full Systems Development Lifecycle as well as
expertise
in
Data Warehousing architecture data modeling and coding.
The
Senior Database Developer
will:
Design, develop and maintain relational and dimensional databases supporting the data warehouse and data marts Create entity relationship diagrams, data dictionaries and mapping documents Utilize
advanced transact-SQL , including
stored proc edures,
ETL
and
OLAP
tools to implement solutions Support implemented solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues Perform code inspections and re-factor code to meet standards Participate in data model reviews, walkthroughs, application and module performance analysis 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
2+ years in scripting languages such as
Perl, Python, Powershell
or programming languages such as
C# or Java Experience in developing
OLAP
cubes and data visualization technologies Ability to perform routine
DBA tasks
including setting up access policy,
data migrations ,
ETL operations , troubleshooting, and performance optimization Ability to scope out requirements, work with business side as well as tech side, etc Programming experience with emphasis on
designing complex SQL queries and business components Preferred:
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: https://pennymacnews.page.link/benefits
For residents with state required benefit information, additional information can be found at: https://www.pennymac.com/additional-benefits-information
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
$90,000 - $150,000 Work Model
OFFICE