PhiladelphiaRecruiter Since 2001
the smart solution for Philadelphia jobs

Analyst, Reporting II

Company: Freedom Mortgage
Location: Philadelphia
Posted on: November 22, 2021

Job Description:

Position Description:This position is fully remote!The Report Analyst is responsible for developing complex reporting with an understanding of current business processes and metrics as they relate to the mortgage industry. This includes gathering requirements, analyzing and mapping data, and complex report/database development. Candidate must possess the necessary skills to work in conjunction with end users, mid and senior level leadership, 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 and interpreting system data, and implementing analytical solutions required for effective management of loans in default. The Report Analyst reviews data to ensure accuracy, develops management dashboards, develops and maintains business review Powerpoint decks for the Default management team, 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 to the development of reporting solutionsCollect data and perform research to gain a complete understanding of the business needs in order to report on the effectiveness of the current practicesInterfaces with business units to define business requirementsAssists business units with designing and testing reports to solve business needsConstruction of Webfocus (IBI) Reporting to ensure timely and accurate distribution of data.Works well both independently and as a team to define processes, coordinate work, and manage communications across the businessDevelops SQL stored procedures, functions, views, tables and other database objects as defined by business partner requirements and Corporate Analytics leadership to support overall corporate objectivesMaintain and continuously seek to improve existing business partnershipsIdentifies and defines improvements to existing reporting data sourcesManages and maintains current report catalog including automating manual reports as well as improvements to existing reportsCreates and maintains documentation regarding reporting and associated dataFulfills ad-hoc data/reporting requests as neededAnalyze portfolio performance and maintain dashboards reflecting performance against established SLAsPerform loan data analysis to validate and communicate results. Run queries to validate the accuracy of data between multiple operating systems. Identify and solve 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 for improvements based on data analysis.Other Related Duties:Performs other related duties as assigned.Supervisory Responsibilities:This position has no supervisory responsibilities.Qualifications:To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required.Minimum two years of experience with SQL development (queries, stored procedures, functions, views, and other database objects) in a Microsoft SQL Server environment.Minimum two years of complex report development experience utilizing Microsoft Power BI, Microsoft SQL Server Reporting Services (SSRS), WebFOCUS, Tableau or similar report development softwareProficiency in Microsoft Excel, Access, Word, Outlook and PowerpointAdvanced proficiency in Microsoft ExcelReverse engineering of Microsoft Access databases experience preferredProven ability to think creatively in complex situationsExcellent written and verbal communication skillsAttention to detail with a high level of accuracyAbility to juggle and prioritize multiple projects and tasks simultaneously - Excellent organizational and time management skills.Hands on experience gathering requirements, designing and coding new reports, maintaining and enhancing existing reports, as well as designing dashboardsHighly analytical problem solver with exceptional interpersonal and communication skillsAbility to define problems, collect data, establish facts and draw valid conclusionsMust 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 plus3-5 years Default Servicing Experience preferredEducation and/or Experience:High school degreeBachelors Degree from a Four (4) year College or University, preferred.Language Skills:Ability to read, and interpret documents such as policy and procedure manuals, safety rules, operating and maintenance instructions. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.Mathematical Skills:Ability to calculate figures and amounts such as discounts, interest, commissions, and percentages.Reasoning Ability:Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.Work Complexity:Tasks are multiple and diverse with some interrelationship across processes. Work requires the direct application of a variety of procedures, policies and/or precedents.Working Conditions:The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually moderate.Work is normally performed in a typical interior work environment which does not subject the employee to any hazardous elements.Employer's Rights:This job description does not list all the duties of the job. You may be asked by your supervisors or managers to perform other duties. You will be evaluated in part based upon your performance of the tasks and functions listed in this job description. The employer has the right to revise this job description at any time. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason.#CB#LI-EK1Founded 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 D.C., 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

Keywords: Freedom Mortgage, Philadelphia , Analyst, Reporting II, Advertising , Philadelphia, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Philadelphia RSS job feeds