Reporting Analyst II

Rocket Companies

$67K — $100K *
Business Services
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 2+ years of experience in reporting, business intelligence, data analytics, or a related role
  • Bachelor's degree in a technology field or equivalent experience
  • Strong SQL skills for querying, analyzing, and validating large data sets
  • Experience building reports and dashboards with Power BI or similar tools
  • Knowledge of data analysis, visualization, modeling, and reporting best practices
  • Strong analytical, problem-solving, organizational, and communication skills
  • Ability to manage multiple priorities and work independently in a fast-paced environment

Responsibilities

  • Partner with business leaders and IT to develop reporting and analytical solutions
  • Develop and maintain operational and compliance reporting for stakeholders
  • Gather business requirements and translate them into reporting solutions
  • Design and maintain interactive Power BI dashboards and self-service reporting tools
  • Use SQL to extract and validate data from multiple sources
  • Monitor KPIs and identify trends, risks, and opportunities
  • Analyze business processes and recommend improvements for productivity

Benefits

  • Health and wellness support for you and your family
  • Comprehensive list of perks and health benefits
  • Encouragement of individual well-being and work-life balance
  • Supportive environment that prioritizes team members' needs
Full Job Description
This posting will be open until August 7, 2026. Applications received after this date may not be considered.

As a Reporting Analyst II, you partner with Master Servicing leadership and business stakeholders to create reporting, analytics, and business intelligence (BI) solutions that guide day-to-day operations and strategic decisions. The role is responsible for designing and maintaining reports, dashboards, and data analysis tools, and for improving data quality. It's a hands-on role that turns complex business needs into clear insights and data-driven recommendations. Success is shown through reliable reporting, actionable analysis, and process improvements that increase efficiency and compliance.

About the role

  • Partner with business leaders, operational teams, and Information Technology (IT) to develop and implement reporting and analytical solutions that support organizational objectives
  • Develop, maintain, and optimize operational, performance, compliance, and management reporting for Master Servicing stakeholders
  • Gather and document business requirements, then translate them into reporting and dashboard solutions
  • Design, develop, and maintain interactive Power BI dashboards, visualizations, and self-service reporting tools
  • Use SQL and other tools to extract, validate, and present data from multiple sources
  • Perform data validation and quality assurance testing to ensure accurate, reliable outputs
  • Monitor key performance indicators (KPIs) and identify trends, risks, and opportunities in operational data
  • Analyze business processes, identify inefficiencies, and recommend improvements that drive productivity, cost savings, and effectiveness
  • Provide analysis and actionable recommendations that support senior management decision-making
  • Participate in system enhancements, upgrades, and implementation projects, including testing, user acceptance testing (UAT), and post-implementation support
  • Create and maintain clear documentation for reports, processes, and business requirements
  • Perform additional duties and special projects as assigned


About you

Minimum qualifications

  • 2+ years of experience in reporting, business intelligence, data analytics, or a related role
  • Bachelor's degree in a technology field, or an equivalent combination of education and experience
  • Strong SQL skills for querying, analyzing, and validating large data sets
  • Experience building reports and dashboards with Power BI or similar business intelligence tools
  • Knowledge of data analysis, data visualization, data modeling, and reporting best practices
  • Strong analytical, problem-solving, organizational, and communication skills
  • Ability to manage multiple priorities and work independently in a fast-paced environment


Preferred qualifications
  • Experience in mortgage servicing, subservicing, or Master Servicing
  • Experience with VBA, Python, or other programming and automation tools
  • Experience documenting business requirements and report definitions


Onsite Requirements:

Candidates must live within a commutable distance to the Highlands Ranch, CO office for in-office responsibilities as required (currently 1 day/week).

What you'll get

Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We've got your back. Check out our full list of Benefits and Perks.

This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the company at any time.

Similar Jobs

More Jobs at Rocket Companies

More Business Services Jobs

Find similar Reporting Analyst II jobs: