Senior Database Developer

$90,000 - $150,000/Yr

Pennymac - Agoura Hills, CA

Full-time - Mid Level

Agoura Hills, CA

1,001-5,000 employees

Real Estate

About the position

The Senior Database Developer at Pennymac is responsible for the design, development, testing, and implementation of enterprise-level data warehouse systems and solutions. This role involves gathering user requirements, understanding dynamic internal and external dependencies, and leading across the full Systems Development Lifecycle. The developer will utilize expertise in Data Warehousing architecture, data modeling, and coding to support the organization’s goals in the mortgage industry.

Responsibilities

• 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 procedures, 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

Requirements

• 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
• Programming experience with emphasis on designing complex SQL queries and business components
• Financial Services and, if possible, mortgage industry experience preferred

Benefits

• 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