Financial Planning & Analysis Analyst

The Cape Cod Five Cents Savings Bank; Hyannis (MA); On-site; USD 85,000 - 120,000; Full time

Job summary

The Cape Cod Five Cents Savings Bank is seeking an FP&A Analyst to support financial planning, forecasting, reporting, and performance analytics across the holding company and subsidiary banks. This role informs senior leadership on results and strategic initiatives to drive data-driven decisions.

The role emphasizes budgeting, financial modeling, data integrity, and executive reporting using BI tools such as Power BI and Tableau, with collaboration across finance and analytics teams.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics or related field.
• 2+ years FP&A or banking finance experience preferred.

Responsibilities

• Support development of annual budgets and multi-year financial plans for the holding company and subsidiaries.
• Build and maintain financial models including balance sheets, income statements, and capital planning models.
• Coordinate data submissions and assumptions from business units and bank subsidiaries.
• Analyze consolidated and bank-level financial results including NIM, loan/deposit trends and costs.
• Prepare monthly and quarterly variance analyses versus budget, prior year, and forecast.
• Track KPIs such as ROA/ROE, efficiency ratio, liquidity ratios, and loan growth.

Skills

Financial modeling

Excel proficiency

BI tools

Analytical thinking

Communication skills

Attention to detail

Banking knowledge

Education

Bachelor's degree in Finance, Accounting, Economics

Tools

Power BI

Tableau

Job description

Salary Grade:17

Summary

The FP&A Analyst supports financial planning, forecasting, reporting, and performance analysis across a multi-bank holding company. This role helps senior leadership understand financial results, evaluate strategic initiatives, and drive data-informed decision-making.

Essential Job Functions & Responsibilities:

Financial Planning & Forecasting

1. Support development of annual budgets and multi-year financial plans for the holding company and each subsidiary bank.
2. Build and maintain financial models, including balance sheets, income statements, and capital planning models.
3. Coordinate data submissions and assumptions from business units and bank subsidiaries.

Financial Performance Analysis

1. Analyze consolidated and bank-level financial results, including NIM, loan and deposit trends, credit quality metrics, non-interest income, and operating expenses.
2. Prepare monthly and quarterly variance analyses versus budget, prior year, and forecast.
3. Identify trends, risks, and opportunities that affect profitability, efficiency, and capital levels.
4. Track and report key performance indicators (KPIs) such as ROA/ROE, efficiency ratio, capital ratios, liquidity ratios, and loan growth.
5. Ad-hoc reporting and analysis based on requests from management across the Bank (i.e. customer trends, unexpected deposit activity, fluctuations in banking activity, etc.)

Management Reporting

1. Prepare monthly management level financial reports for ALCO, Executive Committee, the Board of Directors, and various Board Committees
2. Prepare ad hoc executive dashboards and presentations for internal reporting
3. Consolidate financials from multiple bank charters into clearly aligned management reports.
4. Provide insights and recommendations to guide financial and operational decision-making.

Profitability Measurement and Business Analytics

1. Assist the Director of Financial Planning & Analysis and Financial Planning & Analysis Manager in establishing, coordinating, and maintaining a Bank profitability measurement solution and for performing business analytics.
2. Assist in the assessment of profitability measurement for Mutual Bancorp subsidiary banks to include:
   1. Funds Transfer Pricing (FTP).
   2. Organizational profitability measurement of branches and profit and cost centers.
   3. Product profitability
   4. Customer profitability.
3. Provide analysis and review of current product line profitability for management assessment.
4. Assist in responding to ad hoc requests from Senior Management for business analyses

Data & Systems

1. Maintain and enhance FP&A tools, reporting mechanisms, and financial databases.
2. Work with Data & Analytics teams to improve data integrity, reporting accuracy, and automation.
3. Support implementation or optimization of corporate planning software.

QUALIFICATIONS

EDUCATION & CERTIFICATIONS

• Bachelor's degree in Finance, Accounting, Economics, or related field.

EXPERIENCE

• 2+ of experience in FP&A, corporate finance, banking finance, or related field.

KNOWLEDGE, SKILLS & ABILITIES

• Strong financial modeling and analytical skills.
• Proficiency with Excel; experience with BI tools (Power BI, Tableau) preferred.
• Knowledge of banking financial statements, regulatory ratios, and bank performance drivers strongly preferred.
• Excellent communication skills-ability to distill complex information for executives.
• Strong attention to detail, organization, and cross-functional collaboration.
• Analytical thinking and problem solving
• Business and financial acumen specific to banking
• Ability to manage multiple deadlines
• Intellectual curiosity and proactive mindset
• High integrity and commitment to accuracy

COMPETENCIES

• Must have cyber security awareness to protect the digital environment, the Bank, and customers.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.