This job has expired, please see additional jobs below
Reporting Analyst
Fannie Mae
Washington, DC, United States
Job Details - this job has expired, please see similar jobs below
THE COMPANY
Are you interested in helping solve today's most critical housing challenges? In simplest terms, Fannie Mae serves the people who house America. We work at the heart of housing by providing reliable, affordable mortgage financing in all markets at all times, buying loans that banks and other lenders originate, so they can fund new loans. This gives more people the opportunity to buy, refinance, or rent homes and apartments. Creating these opportunities is what drives the people who work at Fannie Mae.
For more information about Fannie Mae, visit http://www.fanniemae.com/progress
JOB INFORMATION
Under general direction, Reporting Analyst II will be responsible for executing reporting strategy for portfolio data collected from applications and related processes within the department.
KEY JOB FUNCTIONS
• Process and Data Requirements Analysis and Testing Perform analysis and support continuous improvement of portfolio management and governance processes, with a particular focus on data and reporting. Design business data communications and reporting requirements as an integral part of all projects. Execute reporting quality assurance testing for applicable reporting requirements within all projects
• Data Extraction and Analysis Utilize available applications/tools to query portfolio data and extract data as needed for reporting analysis/development or for customer delivery. Analyze data for both reporting development as well as trend identification, event impact analysis, process measurement/improvement, and observation/summarization for senior management attention. Conduct research and analysis and examine risk elements of portfolio or public data to present trends, assess risk, and provide mitigation recommendations to management .
• Report Design, Stakeholder Management, and Report Delivery Utilize available applications/tools to design report drafts/mock-ups for iterative stakeholder review. Prepare reporting deliverables. Utilize available applications/tools to develop adhoc/automated reporting for all levels of the organization. Support communications, training, and end user support efforts with reporting awareness and usage guidance. Prepare reporting to all applicable levels of the organization
Qualifications
EDUCATION
• Bachelor's Degree or equivalent required
MINIMUM EXPERIENCE
• 2+ years of related experience
SPECIALIZED KNOWLEDGE & SKILLS
• Bachelor's degree is required
• Minimum 6 years of relevant working experience is required
• Must understand basic loan accounting principles exhibit ability to review General Ledger entries to validate accuracy and completeness. Ability to provide monthly General Ledger reporting, including all cash and non-cash transactions.
• Must be able to understand loan servicing and demonstrate experience performing bank reconciliations, evaluating servicer reports, and understand internal systems.
• Effective communicator while interfacing with various internal and external stakeholders, investor reporting SMEs, servicing management, SCaR, accounting/finance, treasury/cash management, and sub-servicers, other groups as needed.
• Utilize available applications and databases to obtain and extract portfolio data for reporting analysis, bank reconciliations, cash/general ledger reconciliations. Evaluate and analyze data for potential data errors, trends, or observations. Conduct further research where needed.
• Experience with Toad, SAS or SQL preferred
EMPLOYMENT
As a condition of employment with Fannie Mae, any successful job applicant will be required to pass a pre-employment drug screen and to successfully complete a background investigation, which may also include a credit check for positions in some areas of our business.
Fannie Mae is an Equal Opportunity Employer.