Bachelor's degree in a quantitative field or equivalent experience
Minimum of five years in data analytics or related discipline
Advanced SQL skills in Snowflake or Microsoft SQL
Experience with Python or similar analytical programming language
Familiarity with Power BI or similar visualization tools
Responsibilities
Write and optimize SQL for data extraction and analysis
Develop reusable analytical datasets and reporting solutions
Integrate data from multiple sources for consistent analytics
Implement data-quality checks for accurate outputs
Identify opportunities for automation in reporting processes
Conduct advanced analysis to uncover business trends and risks
Design and maintain dashboards and visualizations for key performance indicators
Benefits
Base pay plus bonuses
Medical, dental, and vision insurance
401k plan
Health savings and flexible spending accounts
Vacation and sick time
Paid holidays
Paid parental leave
Tuition reimbursement
Additional benefits
Full 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.