Skip to main content
High angle portrait of a young woman using her laptop indoorsHigh angle portrait of a young woman using her laptop indoors

Reporting Analyst II - Remote

Apply Now
Apply Now

Description

**THIS POSITION CAN BE WORKED 100% REMOTE 

The Report Analyst is responsible for developing complex reporting with an understanding of currentbusiness processes and metrics as they relate to the mortgage industry. This includes gatheringrequirements, analyzing and mapping data, and complex report/database
development. Candidatemust possess the necessary skills to work in conjunction with end users, mid and senior levelleadership, project managers and IT professionals including database developers and administrators. The Report Analyst plays an important
role in the Default Business Controls team,working collaboratively with the Default business groups in designing reporting, analyzing andinterpreting system data, and implementing analytical solutions required for effective management ofloans in default.
The Report Analyst reviews data to ensure accuracy, develops managementdashboards, develops and maintains business review Powerpoint decks for the Default managementteam, and assists business partners in defining and implementing system enhancements.

Essential Job Functions:

  • Performs the research and information gathering necessary to define, design,create, and document business requirements and specifications as it relates tothe development of reporting solutions
  • Collect data and perform research to gain a complete understanding of thebusiness needs in order to report on the effectiveness of the current practices
  • Interfaces with business units to define business requirements
  • Assists business units with designing and testing reports to solve businessneeds
  • Construction of Webfocus (IBI) Reporting to ensure timely and accuratedistribution of data.
  • Works well both independently and as a team to define processes, coordinatework, and manage communications across the business
  • Develops SQL stored procedures, functions, views, tables and other databaseobjects as defined by business partner requirements and Corporate Analyticsleadership to support overall corporate objectives
  • Maintain and continuously seek to improve existing business partnerships
  • Identifies and defines improvements to existing reporting data sources
  • Manages and maintains current report catalog including automating manualreports as well as improvements to existing reports
  • Creates and maintains documentation regarding reporting and associated data
  • Fulfills ad-hoc data/reporting requests as needed
  • Analyze portfolio performance and maintain dashboards reflecting performanceagainst established SLAs
  • Perform loan data analysis to validate and communicate results. Run queries tovalidate the accuracy of data between multiple operating systems. Identify andsolve discrepancies including both missing data and bad data. Format,massage, and scrub data
  • as necessary to ensure accurate reporting.
  • Develop control reporting for Default teams and provide recommendation forimprovements based on data analysis.
  • Qualifications:
  • To perform this job successfully, an individual must be able to perform each essential dutysatisfactorily. The requirements listed below are representative of the knowledge, skill and/or abilityrequired.
  • Minimum two years of experience with SQL development (queries, storedprocedures, functions, views, and other database objects) in a Microsoft SQLServer environment.
  • Minimum two years of complex report development experience utilizingMicrosoft Power BI, Microsoft SQL Server Reporting Services (SSRS),WebFOCUS, Tableau or similar report development software
  • Proficiency in Microsoft Excel, Access, Word, Outlook and Powerpoint
  • Advanced proficiency in Microsoft Excel
  • Reverse engineering of Microsoft Access databases experience preferred
  • Proven ability to think creatively in complex situations
  • Excellent written and verbal communication skills
  • Attention to detail with a high level of accuracy
  • Ability to juggle and prioritize multiple projects and tasks simultaneously -Excellent organizational and time management skills.
  • Hands on experience gathering requirements, designing and coding newreports, maintaining and enhancing existing reports, as well as designingdashboards
  • Highly analytical problem solver with exceptional interpersonal andcommunication skills
  • Ability to define problems, collect data, establish facts and draw validconclusions
  • Must be flexible and comfortable in a fast changing environment where projects,priorities and timelines shift frequently.
  • Prior experience with Fiserv LoanServ system and data a plus
  • 3-5 years Default Servicing Experience preferred
#CB
#LI-EE1