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.
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."
Apply today to begin your career with us!