Senior Data Analyst

Company: First Merchants Corporation

Locations: Acapulco, Guerrero, Mexico; Tennessee Ridge, Tennessee, United States; Texas, United States; Florida, United States; Indiana, United States; Ohio, United States; Kentucky, United States

Work arrangement: Remote possible

Employment type: Full-time

Experience: 5-10 years

Education: bachelor degree, associate degree

Posted: 2026-11-20

Responsibilities

The Senior Data Analyst will transform complex data into actionable insights to support the Consumer Line of Business using SQL, analytical modeling, and AI-enabled tools. They are responsible for developing scalable datasets, dashboards, and reports while ensuring data quality and governance across the organization.

Requirements

Candidates must have a bachelor's degree in a quantitative field or equivalent experience, along with at least five years of experience in data analytics or a related discipline. Proficiency in SQL and experience with analytical tools and modeling techniques are essential for success in this role.

Skills

  • SQL
  • Snowflake
  • Data analysis
  • Analytical modeling
  • Data visualization
  • Automation
  • Generative AI
  • Python
  • Power BI
  • Statistical techniques
  • Forecasting
  • Segmentation
  • Propensity analysis
  • Scenario analysis
  • Data quality
  • Business intelligence

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • 401k
  • Health savings account
  • Flexible spending account
  • Vacation time
  • Sick time
  • Paid holidays
  • Paid parental leave
  • Tuition reimbursement

About this role

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 applyin...

About First Merchants Corporation

Financial Services · 1,001-5,000 employees · headquartered in Muncie, IN

See all my matches — 2 min, free

More Data Analyst Jobs

75 new Data Analyst jobs were posted this week.

All Remote Data Analyst Jobs →

Get new Data Analyst jobs by email — start free

Before you apply, check your resume against ATS filters for free.