Reporting Analytics Analyst III
PENNYMAC, Carrollton, TX, United States
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.
The Reporting Analytics Analyst Will
Provide analytical support to Operations employees, Operations Managers, and Senior analysts/Mgr. of the Data Management team
Design and develop new reports as needed by Operations teams and PNMAC upper management
Build and modify Special Tools, Applications, and Stored Procedures
Transfer and standardize data using Extract, Transfer, Load (ETL), and Secure File Transfer Protocol (SFTP)
Conduct User Acceptance Testing for system updates, data migrations, and database/schema changes
Utilize Business Intelligence (e.g. SQL, Tableau) software to create visual presentations and new dashboards for use by Operations managers and Senior Managers
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
Strong skills in use of SQL
Highly proficient skills with MS Office, including Excel, Word, and PowerPoint
Experience using Tableau or other BI Tools a plus
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
Compensation
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
Salary: $65,000 - $100,000
Work Model
OFFICE
#J-18808-Ljbffr
The Reporting Analytics Analyst Will
Provide analytical support to Operations employees, Operations Managers, and Senior analysts/Mgr. of the Data Management team
Design and develop new reports as needed by Operations teams and PNMAC upper management
Build and modify Special Tools, Applications, and Stored Procedures
Transfer and standardize data using Extract, Transfer, Load (ETL), and Secure File Transfer Protocol (SFTP)
Conduct User Acceptance Testing for system updates, data migrations, and database/schema changes
Utilize Business Intelligence (e.g. SQL, Tableau) software to create visual presentations and new dashboards for use by Operations managers and Senior Managers
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
Strong skills in use of SQL
Highly proficient skills with MS Office, including Excel, Word, and PowerPoint
Experience using Tableau or other BI Tools a plus
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
Compensation
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
Salary: $65,000 - $100,000
Work Model
OFFICE
#J-18808-Ljbffr