FP&A Senior Financial Analyst I

First Merchants Corporation; Daleville (IN); Hybrid; USD 70,000 - 95,000; Full time

Benefits offered by this job

Base Pay PLUS Bonuses

Medical, Dental and Vision Insurance

401k

Health Savings and Flexible Spending

Vacation/Sick Time

Paid Holidays

Paid Parental Leave

Tuition Reimbursement

Additional Benefits

Job summary

First Merchants is seeking an experienced FP&A Senior Financial Analyst I for a hybrid role based at our Daleville Data Center. The position focuses on financial analysis, ROI, forecasting, budgeting, and strategic planning, delivering reporting and executive summaries across business segments.

The ideal candidate has five years in finance, strong Excel and financial statement analysis, and experience with SQL and Power BI.

Qualifications

• Bachelor’s degree in finance, accounting, or a related field.
• Minimum five (5) years in finance, financial analysis, or related experience.
• Minimum five (5) years of analytical experience and attention to detail.
• Minimum of two (2) years in financial statement analysis.
• Advanced Excel with complex formulas (VLOOKUP, XLOOKUP, IF/THEN, PIVOT).

Responsibilities

• Monthly analysis of segment financial information, variances, and KPI reporting.
• Analyze large datasets using SQL and Power BI to support business partners.
• Budget run rates, one-time adjustments, and annual planning impacts.
• Collaborate to develop line-of-business and departmental budgets.
• Prepare and file SEC Section 16 and related regulatory reporting as assigned.
• Train end users on financial reporting tools and reports.

Skills

Analytical skills

Attention to detail

Financial modeling

Education

Bachelor’s degree in finance, accounting, or a related field of study

Tools

SQL

Power BI

Job description

First Merchants is seeking an experienced finance professional to join our team as an FP&A Senior Financial Analyst I. This hybrid position requires weekly in-office workdays at our Daleville Data Center location. We are looking for a candidate with strong experience in financial analysis, financial statement review, return on investment (ROI) analysis, forecasting, budgeting, and strategic financial planning. The analyst will deliver reporting, in-depth analysis, and executive summaries of financial information, including margin performance, variances, trends, and key performance indicators (KPIs) across multiple business segments. Highly qualified candidates will have previous banking experience.

Essential Duties & Responsibilities

• Perform monthly analysis of various business segment financial information including variance and trending analysis, profitability analysis, reporting and analysis of key performance indicators and writing financial summaries and communication of such to line of business and department leaders.
• Analyze large datasets to assist business partners utilizing available technology tools, including SQL and Power BI.
• Perform analysis of budget information including run rates, one-time adjustments, and impacts of initiatives to support the annual planning process.
• Collaborate with FP&A team members as well as managers and leaders across the company to support development of line of business and departmental budgets.
• Perform analysis and review to drive budget adjustments; provide reporting and change tracking to support the annual planning process.
• Fulfill requests to implement and/or enhance business segment reporting and performance metrics.
• Train end users, including senior managers, on the use of financial reporting technologies and reports available.
• Partner with Senior Financial Analyst II or Business Intelligence on the development and automation of reporting needs and requirements utilizing available reporting technologies such as Power BI and SQL.
• Prepare monthly and/or quarterly internal reports as required.
• Support system administration for budget and reporting software as assigned.
• Prepare incentive payout calculations on a monthly/quarterly basis; provide incentive plan forecasting and analysis as required.
• Prepare and file SEC Section 16 reports for directors and insiders, as well as related annual Federal Reserve reporting, as assigned, ensuring compliance with current regulatory requirements.
• Prepare supporting documentation of Section 16 ownership for annual proxy and FR Y6 as assigned.
• Comply with SOX and other controls and complete periodic attestations as required.
• Ensure department processes and procedures are updated as required.

To be successful in this position, we require the following:

• Bachelor’s degree in finance, accounting, or a related field of study
• A minimum of five (5) years of finance, financial analyst, or related experience.
• A minimum of five (5) years of experience demonstrating analytical skills and strong attention to detail.
• A minimum of two (2) years of experience performing financial statement analysis
• Advanced proficiency in Microsoft Excel demonstrated with a minimum of four (4) years of experience working with complex formulas, including functions such as VLOOKUP, XLOOKUP, IF/THEN, PIVOT Tables and Charts.

The Following Would Be a Plus

• Experience in Banking or the Financial Services industry.
• Experience in budgeting and forecasting.
• Three (3) years or more experience with data visualization or analytical tools such as Power BI or SQL.

First Merchants Offers The Following

• Base Pay PLUS Bonuses
• Medical, Dental and Vision Insurance
• 401k
• Health Savings and Flexible Spending Accounts
• Vacation/Sick Time
• Paid Holidays
• Paid Parental Leave
• Tuition Reimbursement
• Additional Benefits

A Little About Us

First Merchants is guided by a genuine philosophy of being a meaningful place to work and having a prosperous impact across all walks of life throughout the communities we serve, including consumers, businesses and other organizations. Our Vision, Mission and Team statement reflect and reinforce that authentic service philosophy.

Our Vision Is

To enhance the financial wellness of the diverse communities we serve.

Our Mission Is

To be the most responsive, knowledgeable, and high-performing financial organization for our clients, teammates, and shareholders.

Our Team

"We are a collection of dynamic colleagues with diverse experiences and perspectives who share a passion for positively impacting lives. We are genuinely committed to attracting and engaging teammates of diverse backgrounds. We believe in the power of inclusion and belonging."