Logo for First Merchants Corporation

Senior Data Analyst

Role overview

Summary

This role focuses on transforming complex data into actionable insights to enhance the performance of the Consumer Line of Business at First Merchants Bank. You will leverage advanced SQL, data analysis, and emerging technologies to support strategic decision-making and improve business processes.

Qualifications

  • 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.
  • A minimum of five (5) years of experience in data analytics, business intelligence, business analysis, analytics engineering, data science, or a related analytical discipline.
  • Preferred: 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.
  • Preferred: Experience with Python or another analytical programming language for data analysis, modeling, or automation.
  • Preferred: 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.

Responsibilities

  • 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.
  • Identify opportunities to simplify, standardize, and automate recurring data and reporting processes.
  • Design, develop, deploy, and maintain dashboards, business reports, and executive-ready data visualizations that provide clear insight into key performance indicators and business drivers.

Key facts

Hard skills

Key skills for this role

Other skills

  • Forecasting
  • Communication
  • Problem Solving
  • Organizational Skills

About the company

First Merchants Corporation logo

First Merchants Corporation

  • Banking
  • Large
  • 1,001–5,000
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 solutionso The tenure of our professionals averages eight years, meaning you will enjoy continuity of serviceo We hire local professionals from the communities we serve• Customers benefit from local decision making.o Decisions are made fastero 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.Member FDIC, Equal Housing Lender. Investment Management solutions provided by First Merchants Private Wealth Advisors may not be FDIC insured, are not deposits of First Merchants Bank and may lose value. First Merchants and the shield logo are registered service marks of First Merchants Corporation.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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!

Related jobs

See all Data Analyst jobs

Other jobs at First Merchants Corporation