Finance Data Modeler

Pennymac • Westlake Village, CA

6d • $75,000 - $130,000 • Onsite

About The Position

PENNYMAC Pennymac is (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 Finance Data Modeler is responsible for providing operational services to the Finance Division through the management of data structures, views, and statistical calculations. Develops data models to meet the Finance Division's reporting needs by staying informed on how data is used for Financial Reporting, Compliance, FP&A, and Treasury Reporting, while working to maintain data integrity by eliminating redundancy. The Finance Data Modeler will: Optimizes the data integrations into Snowflake from upstream systems, internally development applications, and Finance 3rd party applications to produce efficiency in report computing Creates and maintains data structures, statistical calculations and various other reporting requirements in Snowflake Maintains existing reporting views to stay in sync with upstream changes Supports data governance initiatives as it relates to SOX reviews and documentation Understanding of, and ability to comprehend, datasets with an eye toward their usage for different reporting requirements Partners with Applications Development team to find strategic solutions to recurring problems with database performance Implement data partitioning and database tuning to enable data warehouse scalability Work as part of a team and provides on-going support as required for financial close procedures Work on strategic projects, as needed Supports in trouble shooting, performance issues and setting up new databases Setup and maintain documentation and standards Perform other related duties as required and assigned Demonstrate behaviors which are aligned with the organization's desired culture and values

Requirements

• Bachelor's degree in Information System, preferred
• Experience with database optimization and performance tuning
• Programming experience with emphasis on designing complex SQL queries and business components
• Experience in the physical and logical design of database architecture and exposure to building dimensional data models
• Exposed to SOX audit
• Excellent written and verbal communication ability
• Must be highly proficient in Excel and Word
• Must be a team player with strong attention to detail and able to work independently
• Proven track record at delivering timely and accurate information in a fast-paced environment
• Excellent critical thinking, problem solving, mathematical skills and sound judgment

Nice To Haves

• Financial Services and, if possible, mortgage industry experience preferred
• Strong business acumen and ability to interface with executive management

Responsibilities

• Optimizes the data integrations into Snowflake from upstream systems, internally development applications, and Finance 3rd party applications to produce efficiency in report computing
• Creates and maintains data structures, statistical calculations and various other reporting requirements in Snowflake
• Maintains existing reporting views to stay in sync with upstream changes
• Supports data governance initiatives as it relates to SOX reviews and documentation
• Understanding of, and ability to comprehend, datasets with an eye toward their usage for different reporting requirements
• Partners with Applications Development team to find strategic solutions to recurring problems with database performance
• Implement data partitioning and database tuning to enable data warehouse scalability
• Work as part of a team and provides on-going support as required for financial close procedures
• Work on strategic projects, as needed
• Supports in trouble shooting, performance issues and setting up new databases
• Setup and maintain documentation and standards
• Perform other related duties as required and assigned
• Demonstrate behaviors which are aligned with the organization's desired culture and values

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees