Reporting Analyst II - Remote

Freedom Mortgage
Washington, DC
Jan 16, 2022
Jan 18, 2022
Full Time
Position DescriptionTHIS 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/databasedevelopment. 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 importantrole 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 #CBFounded in Mount Laurel, NJ in 1990, Freedom Mortgage has since grown into one of the largest and fastest-growing privately owned full-service residential lenders in the USA. Licensed in all 50 states, Washington DC, Puerto Rico and the Virgin Islands, Freedom Mortgage has over 5000 employees nationwide, proudly servicing $225.6 billion, and is still growing.Our mission is to foster homeownership in America. Freedom is a leader in VA mortgage lending and is one of the mortgage industry's largest philanthropic supporters of the USO and military families through its Team Freedom Cares philanthropic arm.Locations include suburban Philadelphia and Fishers, IN, two regions where we were named Top Workplaces. We also have large operating centers countrywide, including these desirable markets Beaverton , OR; Boca Raton, FL; Columbia, MD; Jacksonville, FL; Melville, NY; Plano, TX; San Dimas, CA; Tempe, AZ; Troy, MI and Woodbridge, VA.If you seek a sense of community, top training, opportunity for advancement, a comprehensive benefits package and reward and recognition program, look no further.Freedom Mortgage Corporation is an Equal Opportunity Employer committed to workforce diversity. Qualified applicants will receive consideration without regard to age, race, color, religion, gender, sexual orientation, national origin, or their status as a protected veteran or an individual with disabilities. Local applicants encouraged to apply. Employment contingent upon successful completion of background investigation. Smoke-free workplace. Drug-free work environment. Excellent benefits package including medical, dental, vision and 401(k). All resumes are held in confidence. Only candidates whose profiles closely match requirements will be contacted during this search. LENDER NMLS ID 2767Equal Opportunity Employer- Minorities/Females/Disabled/Veterans