FP&A Senior Financial Analyst I

First-Merchants-Bank; Daleville (IN); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health Insurance

401k

HSA

FSA

Paid Time Off

Paid Holidays

Tuition Assistance

Additional Benefits

Job summary

First Merchants Bank is seeking a FP&A Senior Financial Analyst I to join our team in a hybrid role based in Daleville, IN. The analyst will deliver reporting, detailed analysis and executive summaries of financial information across segments, including margin, variances, trends, and KPIs.

Responsibilities include monthly variance analysis, budgeting support, and KPI reporting. You will analyze data with SQL and Power BI, collaborate with leaders on budgets, and help implement process

Qualifications

• Bachelor's degree in finance, accounting, or related field
• Five+ years of finance/financial analyst experience
• Strong analytical skills and attention to detail
• Experience with financial statement analysis
• Advanced Excel with complex formulas (VLOOKUP, XLOOKUP, etc.)

Responsibilities

• Perform monthly analysis of segment financials, variance and KPI reports
• Analyze large datasets using SQL and Power BI
• Support annual planning with run rates and budget adjustments
• Collaborate with FP&A and leaders on budgets/forecasts
• Prepare and file SEC Section 16 reports for directors/insiders as assigned
• Train end users on reporting tools and reports

Skills

Financial analysis

Variance analysis

Budgeting

Attention to detail

Communication

Education

Bachelor's degree in finance, accounting, or related field

Tools

SQL

Power BI

Excel

Job description

First Merchants Bank is seeking a FP&A Senior Financial Analyst I to join our team. This is a hybrid position with required weekly in-office days at our office in Daleville, IN. This position will deliver reporting, detailed analysis and executive summaries of financial information, including margin, variances, trends and KPIs for multiple business segments across the company; provide analysis to support development of the annual plan; identify, develop, and support implementation of process improvements.

• 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:

• Medical, Dental and Vision Insurance
• 401k
• Health Savings and Flexible Spending Accounts
• Vacation/Sick Time
• Paid Holidays
• 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.\"

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.