First Merchants Bank is seeking a Senior Data Analyst to join our team! This position is a highly technical, business-focused analytics professional responsible for transforming complex data into actionable insights that improve the performance of the Consumer Line of Business (LOB). This role combines advanced Microsoft SQL or Snowflake SQL development, data analysis, analytical modeling, data visualization, automation, and AI-enabled analytics to solve complex business problems and support strategic decision-making. The Senior Data Analyst develops scalable analytical datasets, reporting solutions, dashboards, and models; identifies emerging trends, opportunities, and risks; and translates analytical findings into clear business recommendations. The position also leverages generative AI and emerging analytical technologies to improve the speed, quality, consistency, and scalability of analytics while maintaining appropriate validation, data quality, governance, and human oversight. This position can be remote within our operational footprint.
As part of this role you will:
- Write, optimize, and maintain advanced SQL within Snowflake or Microsoft SQL to extract, transform, integrate, and analyze large and complex datasets.
- Develop reusable analytical datasets, transformations, business logic, and data assets that support reporting, dashboards, modeling, and strategic analysis.
- Integrate information from multiple and disparate data sources to create reliable, consistent, and scalable analytical solutions.
- Develop and implement data-quality checks and validation processes to ensure analytical outputs are accurate, reproducible, and appropriate for business use.
- Identify opportunities to simplify, standardize, and automate recurring data and reporting processes.
- Perform exploratory, diagnostic, and advanced analysis to identify business trends, performance drivers, risks, relationships, and opportunities.
- Design, develop, test, validate, document, and maintain analytical models used to support Consumer business decisions.
- Apply appropriate analytical and statistical techniques, including forecasting, segmentation, propensity analysis, scenario analysis, optimization, and other quantitative approaches.
- Lead and/or support analytical modeling for business applications such as staffing, network planning, variable compensation, goal setting, customer behavior, growth, retention, and other Consumer LOB initiatives.
- Effectively use generative AI and AI-assisted development tools to accelerate data discovery, SQL development, analytical workflows, documentation, research, quality assurance, automation, and problem-solving.
- Critically evaluate and validate AI-generated outputs before incorporating them into analytical products or business recommendations.
- Identify opportunities to apply AI, automation, and emerging analytical technologies to improve processes, reduce manual effort, enhance analytical capabilities, and improve decision-making.
- Design, develop, deploy, and maintain dashboards, business reports, and executive-ready data visualizations that provide clear insight into key performance indicators and business drivers.
- Monitor business, customer, operational, and financial data to identify meaningful changes in performance and emerging trends.
- Deliver insights and recommendations regarding potential areas of growth, optimization, efficiency, and performance improvement.
- Conduct ad hoc analysis in response to emerging business priorities and strategic questions.
- Partner across Consumer LOB departments and other areas of the organization to develop data driven strategies that improve business processes and decision-making.
- Translate ambiguous or complex business questions and stakeholder requirements into clearly defined analytical approaches, reporting deliverables, and measurable outcomes.
- Communicate analytical findings, methodologies, assumptions, risks, and recommendations clearly to technical and nontechnical audiences.
- Lead and/or participate in special projects as needed, including upgrades, integrations, new data sources, technology enhancements, and analytical initiatives.
To be successful in this position, we require the following:
- Bachelor's degree in computer science, data analytics, data science, statistics, management information systems (MIS), business analytics, economics, finance, business, or a related quantitative field OR associate degree/two (2) years of college plus two (2) years of related work/military experience OR four (4) years of related work/military experience, plus the additional required experience listed below.
- A minimum of five (5) years of experience in data analytics, business intelligence, business analysis, analytics engineering, data science, or a related analytical discipline.
The following would be a plus:
- Advanced hands-on experience with Snowflake SQL or Microsoft SQL, including complex queries, joins, common table expressions (CTEs), window functions, data transformations, data validation, large datasets, and development of reusable analytical datasets, with the ability to
rapidly become proficient within the Snowflake environment. - Experience with Python or another analytical programming language for data analysis, modeling, or automation.
- Experience with Power BI or a comparable business-intelligence and visualization platform to develop dashboards, reports, or analytical solutions and translate data into actionable business recommendations.
- Experience developing, applying, validating, or maintaining analytical models to support business decisions, including statistical analysis, forecasting, segmentation, predictive modeling, experimentation, optimization, or other advanced analytical methods.
- Practical experience applying generative AI, copilots, large language models, or AI-assisted development tools effectively and responsibly within analytical, coding, documentation, automation, or problem-solving workflows.
- Ability to translate business questions into structured analytical approaches and explain results clearly to technical and nontechnical audiences.
- Experience in banking, financial services, consumer analytics, or another highly regulated industry.
- Experience analyzing customer acquisition, engagement, retention, profitability, product performance, channel behavior, or similar consumer-business outcomes.
- Strong organizational skills with the ability to manage multiple priorities and projects concurrently.
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!
Qualifications Education Required Bachelors or better. Experience Required A minimum of five (5) years of business intelligence, business analyst or related experience, including two years of report writing experience using SQL or similar technology. Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThis 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.
Skills Required
- Bachelor's degree in computer science, data analytics, data science, statistics, management information systems, business analytics, economics, finance, business, or a related quantitative field; alternatively, an associate degree or two years of college plus two years of related work or military experience, or four years of related work or military experience.
- At least five years of experience in data analytics, business intelligence, business analysis, analytics engineering, data science, or a related analytical discipline.
- At least two years of report-writing experience using SQL or similar technology.
- Advanced hands-on experience with Snowflake SQL or Microsoft SQL, including complex queries, joins, CTEs, window functions, transformations, validation, large datasets, and reusable analytical datasets.
- Experience with Python or another analytical programming language for data analysis, modeling, or automation.
- Experience with Power BI or a comparable business-intelligence and visualization platform.
- Experience developing, applying, validating, or maintaining analytical models, including statistical analysis, forecasting, segmentation, predictive modeling, experimentation, or optimization.
- Practical experience applying generative AI, copilots, large language models, or AI-assisted development tools responsibly.
- Ability to translate business questions into structured analytical approaches and explain results to technical and nontechnical audiences.
- Experience in banking, financial services, consumer analytics, or another highly regulated industry.
- Experience analyzing customer acquisition, engagement, retention, profitability, product performance, channel behavior, or similar consumer-business outcomes.
- Strong organizational skills and ability to manage multiple priorities and projects concurrently.
First Merchants Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about First Merchants Corporation and has not been reviewed or approved by First Merchants Corporation.
-
Retirement Support — Retirement programs include a 401(k) with employer match and an employee stock purchase plan that are presented as meaningful components of total rewards. These elements are highlighted as strengths relative to other benefit components.
-
Leave & Time Off Breadth — Time-off provisions include PTO, bank holidays, bereavement, paid parental leave, and paid volunteer time. These elements can help offset concerns about base pay in some roles.
-
Parental & Family Support — Paid parental leave is explicitly offered and positioned alongside PTO and holidays to support family needs. This support contributes to a more balanced work–life setup.
First Merchants Corporation Insights
What We Do
First Merchants Corporation is the largest financial services holding company in Central Indiana, headquartered in Muncie, Indiana. The Corporation has one full-service bank charter, First Merchants Bank. The Bank also operates as First Merchants Private Wealth Advisors (as a division of First Merchants Bank). First Merchants Corporation’s common stock is traded on the NASDAQ Global Select Market System under the symbol FRME. First Merchants offers customers broad financial services throughout locations in Indiana, Ohio, Illinois and Michigan providing: • Commercial Banking (business) – checking, treasury management, card services, financing, loans, electronic banking, online and mobile banking. • Personal Banking (consumer) – checking, savings, CDs, mortgages, loans, IRAs, HSAs, online and mobile banking. • Private Wealth Advisors - trusts, investments, 401(k) plans, 403(b) plans, profit sharing plans, pension plans, cross-tested plans, cash balance plans, Flexible Spending Accounts, IRAs, SEP IRAs, and succession planning. First Merchants is committed to customers by: • Developing strong relationships. o As financial advisors – our professionals listen and provide solutions o The tenure of our professionals averages eight years, meaning you will enjoy continuity of service o We hire local professionals from the communities we serve • Customers benefit from local decision making. o Decisions are made faster o The process is streamlined, with each customer having a single point of contact. o Our financial professionals are empowered to develop tailored solutions. • The local communities we serve benefit from First Merchants’ involvement and support.








.png)