Financial Reporting Senior

Freddie Mac
McLean, VA
May 11, 2017
Jun 21, 2017
Full Time
Position Overview
The Manager of Project Accounting within Freddie Mac’s Information Technology Chief Financial Officer’s (IT CFO) organization is seeking a Financial Analysis Senior. In this newly created role, the chosen candidate will be responsible for defining, developing and deploying new reports to support dissemination of granular, actionable, project and Day 2 cost (e.g. the ongoing cost to support IT hardware and software) data to Finance, IT, and the Lines of Business (LOBs). Activities led by the Financial Analysis Senior will often be time sensitive, highly visible within the Freddie Mac organization and will require collaboration within the Finance organization and with IT and LOB partners.

Responsibilities include:

* Define and develop the portfolio of standard and ad-hoc reports for IT and LOB projects as well as Day 2 costs which are the ongoing costs to support hardware and software
* Document current state and future state of reporting along with associated process flows, data flows, data dictionaries, and data models
* Identify opportunities to leverage alternative functional and technical solutions to bridge reporting gaps and improve overall process efficiency with a focus on automation, dash boarding, and web accessible reports with drill down capabilities
* Assist the Manager in developing a strategy and roadmap to transition manual reporting in Excel to web-accessible reports available either on a schedule or on demand
* Responsible for developing and supporting custom SQL, ETL scripts, and/or EUCs to facilitate IT and LOB reporting needs
* Gather non-technical functional requirements from Stakeholders in Finance, IT and the LOBs and translate into technical reporting deliverables; process will include requirements documentation, analysis, iterative design and development, testing, implementation and continuous improvement activities
* Deliver project, day 2 cost forecasts, and ad-hoc reports on a monthly, quarterly, yearly, and as-needed basis for project managers, Finance and IT management consumption

Basic Requirements
* 5-7 years of related professional work experience
* 3+ years in financial analysis, data analysis, data visualization, data science, or data mining
* Bachelor’s Degree in a finance (Accounting, Finance, Economics, Business Administration) or technology discipline (Engineering, Computer Science, Management Information Systems, Data Analytics, or Data Science)
* Strong financial aptitude and robust analytical skills including experience with financial modeling, forecasting, cost benefit analysis, budgeting, project management, and/or program portfolio management
* Strong understanding of accounting concepts that include capitalization, depreciation, amortization, and useful life, accruals, and/or reversing entries
* Strong understanding of the structure of the general ledger and familiarity with cost centers, accounts, debits, credits, and financial reports
* Intellectually curious; seeks out opportunities to expand professional knowledge and network; funnels found knowledge into continuous process improvement activity
* Proven track record of navigating across organizational boundaries to successfully influence others and build trust-based relationships; maintains poise and professionalism during challenging conversations
* Strong skills in MS Access, MS Excel, pivot tables, VBA, and/or programming logic (such as ‘if’ statements, loops, boolean functions, vlookups, etc.)
* Strong skills in writing SQL using advanced logic or formulas including case statements, sub queries, and/or step queries

Preferred Skills
* Master’s degree in Computer Science/Engineering, Finance, or Data Analytics/Data Science
* Holds a Certified Data Management Professional (CDMP) certification
* Experience with reporting for budget-to-actuals, pro-forma, day 2 costs, IT Finance, and/or forecasting
* Experience writing custom ETL using T-SQL, PL/SQL, Python, VBA, or other scripting languages
* Experience with Microstrategy, Hyperion Smartview, PeopleSoft Project Costing (PCS), SQL Server, ParAccel, Python, VBA, and/or forecasting
* Personality type who thrives in a team oriented, start-up type environment; can easily shift focus between high priority tasks as required
* Strong written and oral communication skills including experience with messaging or presentation skills for executive audiences using PowerPoint and data visualization software such as Tableau

Closing Statement
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