Analytics and Data Solutions Lead

At Dr. Tavel Family Eyecare, we have been caring for Hoosiers for more than 85 years, serving over 100,000 patients each year. We are a $50M business with more than 300 employees, and while we are rooted in patient care, we are also unusually forward-leaning when it comes to technology. We even have software engineers on staff and have spun off a tech company. This role is the data and analytics department. You will own the data stack end to end, shaping how data is gathered, structured, and used across the company. You will not be on an island. IT and engineering will support you where needed, but the vision and direction are yours to drive in consultation with the senior leadership team, who will also be your primary customers. If you are energized by untangling complex data, spotting patterns, building dashboards, and surfacing insights that leaders act on, this is the role for you. You will report directly to the GM, who writes SQL daily, and you will have the freedom to make your mark on a business where data truly matters. What You’ll Be Doing • Build robust datasets primarily using Microsoft SQL, writing advanced queries (views, stored procedures, functions, CTEs, windowing, query tuning) that become the backbone of reporting and analysis • Design and publish dashboards in Power BI that drive decisions at every level of the company, from frontline operations to the executive team • Use your dashboards and data models not just to present numbers, but to actively explore, analyze, and surface insights that matter • Handle data prep and integration between systems. Today that is often SSIS, Python, or Javascript, but we are open to better tools if you find them • Support occasional operational reporting in SSRS, with help available from a SQL contractor if this is not your core strength • Partner directly with senior leaders across the company to understand their challenges and deliver data-driven answers that change how they run the business • Identify opportunities for new tools, automation, and integrations that expand what our data can do, whether that is experimenting with ClickHouse, learning from what we are doing in Snowflake, or bringing in something entirely new • Field ad-hoc requests and turn them quickly into thoughtful, accurate analysis Who Should Apply • You are insatiably curious. You love learning for its own sake and your curiosity knows no bounds. Whether it is a technical problem, a business process, or simply how the world works, you dive in and chase understanding • You are a creative problem solver. You refuse to get stuck. You expand the solution set, think outside the box, and always find a way forward • You are an excellent communicator. You are comfortable with anyone, from senior leadership to frontline staff. You know you can learn from anyone, and you connect with people in a way that builds trust and understanding • You are strong in SQL (DDL, DML, joins, window functions, CTEs, stored procedures, temp tables) and take pride in building efficient datasets that hold up to scrutiny • You are comfortable in Power BI, including data modeling and DAX, and you care just as much about performance and accuracy as you do about clear, usable dashboards • You have experience integrating data across systems (SSIS, APIs, Python, Javascript) and you are always looking for better, more reliable ways to do it • You balance technical mastery with business understanding, treating data as a source of insight and action, not just numbers • You enjoy owning the full stack of BI work: exploration, cleansing, integration, modeling, reporting, dashboards, and surfacing insights • You want your work to matter, to be recognized, and to raise the game for the whole team Who Should NOT Apply • You are looking for a stepping-stone role and personnel management responsibility instead of an opportunity to own and deliver as an individual contributor • You wither under questioning or see debate as confrontation • You make leaps in logic and fail to chase down edge cases, causing your work to collapse under scrutiny • You are strong in tech but weak in business (or vice versa) and are unwilling to bridge the gap • You see data as numbers on a page instead of a tool to tell stories and drive change • You avoid digging into messy or hard-to-get data • You avoid learning how the business functions and fail to become an expert user of the core systems that generate the data you are analyzing Apply tot his job Apply To this Job