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

, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Jun, 26

Salary

152000.0

Posted On

25 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Python, Power BI, Alteryx, Shell Scripting, Dimensional Modeling, Tableau, MicroStrategy, MS SQL, Oracle Database, MS Excel, PowerPoint, MS Word, Reporting Development, Data Analysis, Project Management

Industry

Financial Services

Description

At Freddie Mac, our mission of Making Home Possible is what motivates us, and it’s at the core of everything we do. Since our charter in 1970, we have made home possible for more than 90 million families across the country. Join an organization where your work contributes to a greater purpose. 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, detail, highly organized Ability to self-teach new technical skills on need-to-know basis Deep curiosity to learn about new trends and topics Detail focused, detail, highly organized Ability to self-teach new technical skills on need-to-know basis Current Freddie Mac employees please apply through the internal career site. We consider all applicants for all positions without regard to gender, race, color, religion, national origin, age, marital status, veteran status, sexual orientation, gender identity/expression, physical and mental disability, pregnancy, ethnicity, genetic information or any other protected categories under applicable federal, state or local laws. We will ensure that individuals 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. A safe and secure environment is critical to Freddie Mac’s business. This includes employee commitment to our acceptable use policy, applying a vigilance-first approach to work, supporting regulatory mandates, and using best practices to protect Freddie Mac from potential threats and risk. Employees exercise this responsibility by executing against policies and procedures and adhering to privacy & security obligations as required via training programs. CA Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. 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 www.BountyJobs.com and register with our referral code: MAC. Time-type:Full time FLSA Status:Exempt Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site. This position has an annualized market-based salary range of $108,000 - $152,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.

Responsibilities

This role involves supporting reporting development within the I&CM CFO department, focusing on executing report code writing for multiple teams supporting Investment Capital Markets and maintaining automation tracking for segment controllership functions. Responsibilities also include enhancing reporting, collaborating on changes across departments, and assisting with project management.