Capital Markets CFO - Financial Planning and Analysis - Senior Associate Details

Capital Markets CFO - Financial Planning and Analysis - Senior Associate

Fannie Mae - Washington, DC

Employment Type : Full-Time

: At Fannie Mae, futures are made. The inspiring work we do makes an affordable home a reality and a difference in the lives of Americans. Every day offers compelling opportunities to impact the future of the housing industry while being part of an inclusive team thriving in an energizing, flexible environment. Here, you will help lead our industry forward and make your career.
As a Senior Associate - Financial Analyst, you will examine financial asset, real asset, inventory of assets or class of assets. Determine cash flow, costs, profit margins, future cash flows, and alternatives based on varying assumptions and projected market or economic conditions. Use financial analytical tools to make projections of prospective financial performance. May use advanced or proprietary analytical tools pertinent to very specific class of assets or more complex economic operating conditions.
Job Description: As a valued colleague on our team, you will contribute to collecting, analyzing, and interpreting financial or operational information which could include trend analysis and identification of gaps and opportunities. In this role, you will value assets by assessing current conditions with direction from senior leadership and the support of your team, and recommend debt structures by analyzing refinancing options.
THE IMPACT YOU WILL MAKEIn this role you will have the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:* Analyze financial data for prospective purchase, asset allocation, fee generation or other cash flow, using typically industry/company standard analytical tools or measures.

• Contribute analyses to report being prepared for business unit management to aid in making financial, client, acquisition, or other business decision.
• Confer with business unit management and staff to acquire operating or financial data for analysis. Using this data, conduct standard or ad hoc analyses to satisfy variety of management objectives.
• Participate in or lead month end analyses to summarize, reconcile, and report financial data from transactions, fee payments, accruals, or other cash flows, to identify or track trends. Consolidate work done by other analysts into final report.
• Assess data retrieved from archive or data warehouse for data integrity for analytical purposes; sort, partition or segment data for further analysis by self or others.
• Develop queries to obtain financial data requested by users in the business unit. Coordinate development of data files, testing and validation in the acceptance phase, and migration of data requirements to production phase of the application life-cycle.
• May conduct specific analyses of financial or operating data to satisfy certain regulatory requirements or to establish required internal controls over business processes.

Qualifications: THE EXPERIENCE YOU BRING TO THE TEAM
Education Level (Required)* Bachelor Degree or Equivalent
Education Level (Preferred)* Master or Other Advanced Degree
Areas of Study (Preferred)* Business or Finance
Experience (Primary)* 4-6 years of related experience
Skills (Primary)* Experience in developing data solutions in SQL (creating Stored Procedures, Tables, and table valued functions).

• Experience in developing reporting solutions from scratch in a BI reporting tool such as Tableau, Power BI, SSRS, or any other tool.
• Experience in taking in a reporting task from scratch throughout the entire developing cycle (Problem identification, data collection, data cleaning, data structuring and manipulating, report layout developing).
• Good understanding of data modeling, data warehousing, and normal forms.
• Experience in solving data problems and in exploring data by using python or another programming language like R.

Additional Information: The future is what you make it to be. Discover compelling opportunities at careers.fanniemae.com.
Fannie Mae is an Equal Opportunity Employer, which means we are committed to fostering a diverse and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, religion, national origin, gender, gender identity, sexual orientation, personal appearance, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation in the application process, email us at careers_mailbox@fanniemae.com.