Power BI)

Freddie Mac•McLean, VA

About The Position

In this role, you will play an integral part supporting the reporting development across I&CM CFO department. As a member of the Financial Reporting and Governance team, you will be responsible for the execution of report code writing for multiple teams that support Investment Capital Markets as we communicate across divisions. As a member of the ICM CFO Segment Controller, we are charged with the constant upkeep of automation and tracking all future changes. You will also be tasked with the reporting enhancement, collaborating across departments to communicate changes, and project management assistance. The I&CM CFO department is responsible for financial accounting and reporting, portfolio risk and profitability analysis, pricing and valuation activities, and financial planning & analysis for Freddie Mac’s Capital Markets segment. The candidate will perform critical review of changes supporting the financial models and systems creating the financial results.

Requirements

Typically has a minimum of 3 years of related experience (BI and Analytics)
Strong written and verbal communication skills
Strong knowledge of SQL, Alteryx, and Relational Database Concepts (Python, Shell Scripting, Dimensional Modeling are preferred)
Strong hands on experience on MS SQL and Oracle database.
Experience working with Business Intelligence Tools (Tableau, MicroStrategy, Power BI)
Demonstrated experience as a person who is highly detailed-oriented, with excellent verbal, written, and interpersonal skills
Strong independent problem-solving capabilities
Demonstrated proficiency in MS Excel, PowerPoint, and MS Word

Nice To Haves

Mortgage Industry or Financial Services experience preferred
Python, Shell Scripting, Dimensional Modeling are preferred

Responsibilities

Work with Internal teams to identify new business requirements and enhancements need in support analytical applications used to assess within the Investments and Capital Markets division, understood and implemented correctly.
Develop automated, code-based, frameworks to consume large Market Risk Datasets and incorporate them into existing tools to augment our analytical capabilities
Manage multiple, often shifting, priorities with minimal direction all while meeting the appropriate deadlines
Design and drive the implementation of new tools across the team
Help identify the appropriate testing and change management protocols needed mitigate risk of constant changes requirements and priorities
Contribute throughout the Analytical lifecycle – from inception of new ideas, to coding, testing, and all the way to Dashboard Development, or synthesizing findings in standard reporting forums for senior management
Identify and manage gaps in existing data/processes and recommend solutions.
Ensure business process flows and requirements are in alignment with upstream/downstream data sources
Prepare presentations delivered to senior management and the Board of Directors
See opportunities for enhancing and improving our process and data infrastructure