Capital Planning Data Analytics Senior

Freddie Mac
McLean, Virginia
Mar 06, 2021
Mar 18, 2021
Full Time
At Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation.

Position Overview:

The Capital Planning team is seeking a confident, self-motivated and analytical thinker with strong leadership, partnership, and communication skills - with a passion for data analysis and data synthesis!

The Capital Planning Data Analytics Senior will be responsible for supporting the team in creating and visualizing data to communicate complex patterns to executives and business users. The Capital Planning Data Analytics Senior will report to the Capital Planning Analytics and Reporting Manager. Key duties include data analysis, especially as it relates to end-to-end data flow and capital variance analysis, with a goal to enhance the ability of the Capital Planning Team to tell the story about the data to key stakeholders and senior management.

Your Impact:

The Capital Planning division is responsible for the planning, forecasting, and optimization of capital. The team focuses on the oversight of all capital management, capital planning and elements related to risk appetite and capital contingency, as well as strategic and policy initiatives. The team's activities are focused on both business-as-usual and stress environments and ties closely with other areas within the Finance function including Financial Planning and Analysis and Stress Testing. Our team:
  • Collaborates with the division finance and business areas as well as division risk officers (DROs) in the implementation of the recently enacted Enterprise Capital Rule and coordinates associated regulatory submissions, including conservatorship capital reporting.
  • Drives the optimization of capital in partnership with other areas within Finance and the business areas to improve the systems and processes currently utilized to perform these activities.
  • Develops the strategies and tools to accurately measure and optimize capital capacity and ratios and related measures.

Capital Planning is a new group recently created reporting to the Chief Finance Officer and this is a great opportunity to be part of a high-profile and fast-growing team that will implement Freddie Mac's Capital Planning and Management Strategy during its build-out phase.

Your Impact:

As a member of the Capital Planning Team you will:
  • Access large data sets utilizing programming, Business Intelligence systems like Tableau and relational database systems like SQL skills to perform point-in-time as well as trending and sensitivity analysis
  • Collect, organize, analyze and disseminate significant amounts of information from internal and external sources with attention to detail
  • Construct detailed presentation decks, reports, automated programs and algorithms to detect and explain data management related issues
  • Possess in-depth knowledge on financial market, mortgage industry and fixed income products. Familiar with how loan delinquency impact profits and capital and relevant credit risk mitigation strategies
  • Experience in working with FHFA and other regulators preferred; Follow FHFA published rules and directives closely
  • Demonstrate understanding of internal business segment (stakeholders) and build capability to obtain relevant data and information efficiently for capital analysis
  • Collaborate with fellow team members and other participants within Capital Management
  • Develop and maintain reporting templates and documentation of methodologies and execution to support governance requirements

  • 5-7 years of related professional experience
  • Strong communication and strategic thinking skills to engage with senior leadership
  • Proficient in working with large-scale business data sets
  • Fluent in scripting and rapid prototyping skills including expertise in technology such as SAS, SQL, Python, R, and/or BI tools such as Hyperion and MicroStrategy
  • Experience with data visualization tools such as Tableau
  • Proficiency with the Microsoft Office suite, especially Microsoft PowerPoint and Excel
  • Experience working for Fannie Mae or Freddie Mac preferred
  • An undergraduate degree is required. MBA, Master's, CFA is preferred

Keys to Success in this Role:
  • Strong analytical, project management, and communication skills
  • Demonstrate the ability to build good relationships across the organization
  • Show flexibility in thinking as we develop new processes as multiple iterations are likely to happen before a workstream is completed
  • Ask questions and listen while learning. A good amount of the work is related to listening and gathering information from others
  • Provide resolutions to an extensive range of complicated problems. Solutions should be innovative, thorough, and practicable
  • Be independent and a thought-leader in determining and developing approach to solutions

Current Freddie Mac employees please apply through the internal career site.

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.

We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit and register with our referral code: MAC.

Time-type:Full time

Job Category:Finance

FLSA Status:Exempt

Similar jobs