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 a