Data Analytics Professional

Freddie Mac
McLean, VA
Aug 21, 2019
Sep 04, 2019
Full Time
This Multifamily Advanced Insights and Reporting (MF AIR) Professional position is in the Finance Division at Freddie Mac. This role will support MF CFO as well as the Multifamily line of business in building reporting solutions to help manage the business. The successful candidate will possess strong analytical and follow-up skills. This position requires that the candidate interacts and works effectively with internal customers as well as with all levels of management within and across departments. The position also requires the ability to manage and prioritize multiple reporting tasks simultaneously. The position will report to an MF AIR Manager for Finance.

Your Work Falls into Three Primary Categories:

Data Mining

  • Extract, combine and validate structured and unstructured data from various sources, such as RDBMS (Oracle, SQL Server, DB2), flat files, SAS data sets, XML, MS Office files
  • Apply quantitative methods to investigate and answer business questions related the Multifamily line of business
  • Apply statistical and custom and machine learning methods to uncover meaningful patterns and insights in data
  • Develop and maintain reproducible code for business analytics in SAS and Python

Developing Business Reports
  • Develop effective adhoc reports that compile data from various sources and overlay applicable analytics to meet a specific business need
  • Develop interactive and regularly updated data visualizations using Tableau to consistently meet fluid and evolving business needs

Data Quality and Availability
  • Proactively monitor and facilitate the update and correction of critical data elements that feed reporting processes
  • Work in tandem with data quality and data program teams to ensure high quality data is readily available to Multifamily business partners


  • Bachelor's degree
  • 2-4 years related experience
  • Proficient with relational databases and with reporting tools such as SAS, Excel, Tableau, Python, PowerPivot, MS Query and MS Access.
  • Job requires experience using MS Office applications including MS Excel and MS PowerPoint.

Keys to Success in this Role
  • Ability to thrive in a fast-paced team environment. We're a big happy family in MF AIR!
  • A curious mindset that fuels the growth of personal and technical skillsets.
  • Excellent verbal and written communication skills. Ability to understand and explain complex business concepts and reporting requirements.

Top 3 Personal Competencies to Possesses
  • Partnership: Build trust and strong partnerships through my own and my team's actions
  • Drive for Execution: Be accountable for strong individual and team performance
  • Growth and Development: Know or learn what is needed to deliver results and successfully compete

Preferred Skills

Preferred Skills
  • Excellent written and verbal communication skills
  • Highly organized, team player, detail oriented, with strong problem-solving abilities
  • Proficiency in translating business requirements into technical specifications
  • Experience using SAS or Python
  • Working knowledge of SQL
  • Basic understanding of UNIX
  • Familiar with Multifamily data and systems
  • Knowledge of secondary mortgage market and Freddie Mac's business
  • Foundational understanding of Business Intelligence (BI) reporting tools such as Tableau
  • Ability to think critically and logically

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you'll do important work for the housing finance system and make a difference in the lives of others. Freddie Mac is an equal opportunity and top diversity employer. EOE, M/F/D/V.

Similar jobs