Reporting Analyst II

Job Description

THE COMPANY


Fannie Mae provides reliable, large-scale access to affordable mortgage credit in communities across our nation. We are the leading source of funding for housing in America, which means more people can buy or rent a home. We are focused on sustaining the housing recovery, improving our company, and leading change to make housing better.
Join our diverse, high-performing team and make a difference as we work together to enable access to a good home.
For more information about Fannie Mae, visit 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.
  • 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




EDUCATION


Bachelor's degree or equivalent


MINIMUM EXPERIENCE


2-4 years

SPECIALIZED KNOWLEDGE & SKILLS


  • Proficient in SAS, Tableau, R, and Python; Strong SQL proficiency
  • Proficient in working with large amounts of data from a wide variety of data sources and be able to accurately join the disparate data sources together to build meaningful analytics
  • Experience with residential property data, including Automated Valuation Models, UAD, MISMO standards
  • Understanding of the business side of Collateral Risk and real property valuations, and working knowledge of the mortgage lending process
  • Comfortable performing statistical analysis
  • Ability to produce data visualizations and decks for presentation to management and external parties
  • Ability to QC other analyst’s work, both by reviewing the code to look for errors, as well as reviewing the output and running their own data checks to confirm that the output is correct
  • Building, documenting tables, code and assumptions for future reference
  • JIRA, Confluence and Alteryx understanding is a plus
EMPLOYMENT


As a condition of employment with Fannie Mae, any successful job applicant will be required to successfully complete a background investigation.
Fannie Mae is an Equal Opportunity Employer.
#LI-MH1



Req ID: 58133