Finance Data Modeler jobs in United States
cer-icon
Apply on Employer Site
company-logo

PENNYMAC · 1 day ago

Finance Data Modeler

Pennymac is a specialty financial services firm focused on the production and servicing of U.S. mortgage loans. The Finance Data Modeler is responsible for managing data structures and developing data models to support the Finance Division's reporting needs while ensuring data integrity and efficiency in reporting processes.

BankingFinanceFinancial ServicesLendingMortgage
check
H1B Sponsor Likelynote

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

Qualification

Database optimizationSQL programmingData modelingSnowflakeSOX complianceExcel proficiencyFinancial services experienceCommunication skillsTeam playerProblem solving

Required

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

Preferred

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

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
We value the hard work and dedication of our employees. In addition to a competitive salary, positions may offer bonus opportunities.

Company

PENNYMAC

company-logo
Pennymac is a home loan lending company that offers financial services.

H1B Sponsorship

PENNYMAC has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (48)
2024 (42)
2023 (33)
2022 (44)
2021 (65)
2020 (34)

Funding

Current Stage
Public Company
Total Funding
$2.33B
2025-12-11Post Ipo Debt· $75M
2025-08-07Post Ipo Debt· $650M
2024-05-20Post Ipo Debt· $850M

Leadership Team

leader-logo
Stanford L. Kurland
Founder, Chairman, and Chief Executive Officer
linkedin
leader-logo
Amar Nadig
Senior Vice President of Enterprise Data
linkedin
Company data provided by crunchbase