Data Warehouse Analyst

Job Description

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


Are you interested in working in a forward-thinking environment with highly intelligent and talented colleagues? Our Multifamily Tech Development team in Herndon, VA is currently looking for a Data Warehouse Analyst. Our data program is one of the top 10 best data programs in the DMV area. This person would be working with highly accommodating resources on ETL side. You will be responsible for working as the liaison between the business and the technology teams, so being well versed in in both technical and business jargon is critical. This is a heavily data-oriented role, assisting in building data warehouses for Fannie Mae. Prior data modernization, business intelligence, and data warehouse experience is a must. We are looking for a data-minded person who can think out of the. Ideally this candidate would have prior experience in open and adaptable organizations with a strong data background.



  • Work with the business unit or other subject matter experts to identify or refine technical requirements for application under development or being revised.
  • Document requirements for enhancements for specific application.
  • Review and/or contribute content to requirements, design, or test documentation.
  • Perform data analysis at various stages of project, in order to assure development of a quality application. Analysis can include requirements development, testing, or user acceptance.
  • Contribute to application test plan, and evaluate test results to assist development or test staff.
  • Assist project manager in task identification, resource allocations and schedule estimates for staff on assigned project in order to help keep project resourced appropriately and on track. May take lead on small projects or on segment of larger projects.
  • Provide business domain and/or technology and/or process expertise and mentoring to others on team. Prepare or contribute to briefings of application owners at pertinent stages of project.

  • 5 + years of related experience
  • Required:
    • Solid understanding of data analysis and XML
    • Understating of ETL tools and data integration challenges
    • Understanding of data modeling techniques (3NF & Dimensional)
    • Proficiency in data profiling and data integration
    • Previous experience of building and maintaining Data Warehouse and data marts
  • Desired:
    • Understanding of cloud architecture and big data
    • Understanding of Machine Learning and data visualization tools
    • Experience innovating new ways to standardize existing data processes and optimizing current workflows
    • Working in a team environment where brainstorming, innovation, and collaboration is critical while also maintaining personal responsibility for completion of assigned projects on time and of high quality
  • Education Level Required:
    Bachelor Degree or Equivalent
  • Area of Study Preferred:
    Computer Science

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.

Req ID: 57635