Financial Analysis and Reporting, Senior (SQL/Python/Power BI) Job at Freddie Mac, McLean, VA

YXV1YU1vVm52RXUxcW5QT3B2aHBBOXpIRHc9PQ==
  • Freddie Mac
  • McLean, VA

Job Description

Position Overview

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.

Our Impact

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.

Your Impact

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

Qualifications

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)

Mortgage Industry or Financial Services experience preferred

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

Keys to Success in this Role

Intellectual agility and interpersonal flexibility

Willingness to learn new concepts and tools

Ability to work across silos and with minimal instruction

Deep curiosity to learn about new trends and topics

Detail focused, highly organized

Ability to self-teach new technical skills on need-to-know basis

Job Tags

Shift work

Similar Jobs

Rise at Seven Ltd

Data Journalist Job at Rise at Seven Ltd

 ...most likely have a minimum of four years' experience in PR agency side, with some experience in digital and traditional PR as well as a good understanding of SEO and social media platform operations. RESPONSIBILITIES ACCOUNT & CAMPAIGN MANAGEMENT Onboarding... 

Red Rock Staffing

SEO Technical Specialist Job at Red Rock Staffing

 ...Responsibilities SEO team leadership, training, hiring, and daily management - Gain thorough understanding of clients' website...  ...goals - Create and implement onsite and offsite SEO strategies - Technical SEO experience on areas such as crawling/indexing, sitemaps, robots... 

ProKatchers

Medical Receptionist Job at ProKatchers

 ...Job Title : Medical Receptionist Location : Dallas, TX 75246 Duration : 6+ months contract (Possible extension ) Education : High school Diploma Shift Details : M-F 8X5/Business hrs. Job Description: The Admin Assistant supports individuals, large teams or department... 

Legacy Navigation

Case Manager Job at Legacy Navigation

 ...Job Description Job Description CASE MANAGER (REMOTE) Legacy Navigation | Full-Time | Work From Home This position is only open to residents within 60 minutes of Boise Idaho. Every day, we guide families through the hardest chapters of their lives. Were... 

Grayson Carter and Son Contracting

Quarry Operator I Job at Grayson Carter and Son Contracting

 ...Job Description Job Description Position Title: Quarry Operator I Department: Quarry Operations Location: Baileyton, AL Essential Job Functions: Assist in the extraction and processing of materials from the quarry. Operate basic quarry equipment...