Reporting Analyst

Paramount Residential Mortgage Group • Corona, CA

2d • $31 - $36

About The Position

We are seeking a detail-oriented and analytical professional to join our team. The ideal candidate will have strong analytical skills, advanced Excel proficiency, and preferably experience in the mortgage industry. This role involves analyzing mortgage-related data, creating reports, and supporting operational and business decision-making through data insights.

Requirements

• 2+ years of experience in data analysis, reporting, or a related analytical role
• Experience working with large datasets in Microsoft Excel
• Demonstrated experience using advanced Excel functions such as Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, and IF formulas
• Experience creating reports, dashboards, and data summaries to support business decisions
• Ability to analyze data, identify trends, and provide actionable insights
• Strong analytical and problem-solving skills
• Proficiency in Microsoft Excel, including advanced functions such as: VLOOKUP / XLOOKUP, Pivot Tables, INDEX & MATCH, IF statements Data validation and conditional formatting
• Excellent attention to detail and organizational skills
• Strong written and verbal communication skills
• College Degree or equivalent work experience
• Maintains high level of confidentiality.
• Develops and maintains system to organize and easily retrieve information obtained in execution of job duties.
• Communicates well verbally and in writing with co-workers and customers

Nice To Haves

• Mortgage industry experience preferred, including familiarity with loan origination, servicing, or mortgage operations

Responsibilities

• Analyze mortgage data to identify trends, discrepancies, and opportunities for improvement
• Develop and maintain Excel-based reports, dashboards, and data models
• Use advanced Excel functions to organize, analyze, and present data
• Support mortgage operations teams with data analysis and reporting needs
• Ensure data accuracy and maintain documentation of processes and reports
• Collaborate with internal teams to improve workflows and reporting efficiency

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level