Bachelor's degree in finance, accounting, or related field
5+ years of finance or financial analyst experience, or 3+ years as an FP&A Analyst in a financial institution
5+ years demonstrating analytical skills and attention to detail
2+ years performing financial statement analysis
Advanced proficiency in Microsoft Excel with experience in complex formulas.
Responsibilities
Perform monthly analysis of financial information, including variance and profitability analysis
Analyze large datasets using SQL and Power BI to assist business partners
Support the annual planning process through budget analysis and adjustments
Collaborate with FP&A team and departmental leaders on budget development
Enhance business segment reporting and performance metrics as requested
Train senior managers on financial reporting technologies
Prepare SEC Section 16 reports and ensure compliance with regulatory requirements.
Benefits
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
Full Job Description
First Merchants Bank is seeking a FP&A Senior Financial Analyst I to join our team. 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 OR a minimum of three (3) years of experience as an FP&A Analyst at a financial institution.
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.
