Senior Business Systems Analyst

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 :

Responsible for data mapping and validation for business process migration. Perform source to target mapping for the ETL process to establish data flow from cross-platform systems Postgres SQL, AWS Athena, MongoDB REST API into SQL Server for new loan origination process.

Develop transformation logic by using SQL to capture data modifications before data is presented to business teams and stakeholders.

Document various parameters of mappings such as source table and field, target table and field, data formats, sample values for each system involved, primary and surrogate keys, translation logics and table relationships.

Data Analytics and Innovation to support decision making and automation. Perform data analysis tasks - sentiment analysis to analyze customer feedback survey to identify the polarity of customers and categorize the output based on polarity using Natural Language Processing (NLP) technique in Python.

Develop Python programs for Mapping Recommendation which recommends potential matching fields in target systems for the input field in source and mapping validation to automate process of validating existing source-to-target mappings by comparing them with the master mapping sheet.

Collaborate with business downstream teams Finance, Capital Market, Pricing, Risk, to capture business requirements in an Agile environment.

Create test cases based on test scenarios as an input in UI. Position will be headquartered in Moorpark, CA but is a telecommuting position, allowing for remote employment from various unanticipated worksites throughout the United States.

What You’ll Bring :

• Six (6) years of experience as an Application Developer, Software Engineer or related role. Experience must include performing data extraction, transformation, and loading;
• migrating data sources; analyzing and reporting data; designing, developing, and managing performance metrics, reports, analysis, and dashboards using Macros;

and developing custom queries, views, and reports. Position will be headquartered in Moorpark, CA but is a telecommuting position, allowing for remote employment from various unanticipated worksites throughout the United States.

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 :

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 : $144,518

$144,518

Work Model : OFFICE

OFFICE