REQUIREMENTS

Location: Indianapolis, Indiana – this position is a hybrid position but needs to be located in central Indiana to be onsite with partners as needed. 

​

Summit Managed Solutions partners with healthcare organizations to help them solve their most complex problems. Part strategy consulting, part tech-enabled professional services, our team is a diverse mix of experienced problem solvers who work with partners to create innovative solutions with enduring value.

​​

JOB SUMMARY

We are seeking a Technical Business Analyst with strong SQL expertise and at least four (4) years of experience in healthcare data analytics. In this role, you will serve as the critical link between technical teams who build and maintain SQL queries and business stakeholders who depend on accurate, actionable reporting. Your primary responsibilities will include interpreting and validating SQL queries, documenting reporting logic, translating technical details into clear business requirements that align with organizational goals, and facilitating a change management process.

​

A major focus of this role is state and regulatory reporting, where precision, validation, and transparency are essential. You will be expected to identify data inconsistencies, perform root cause analysis, and catch SQL errors while maintaining meticulous records and ensuring that reporting assumptions, filtering criteria, and business rules are clearly documented. Your ability to communicate these technical details in a way that non-technical stakeholders can understand will be essential for success.

​

In addition, this role requires project and change management skills to coordinate reporting changes and ensure that dependencies across reports are well-tracked. Experience in healthcare—particularly Medicaid (LTSS)—is highly preferred, as it provides valuable context for understanding reporting needs. Familiarity with BI tools (e.g., Tableau, Power BI) or statistical forecasting is a plus but not required.

​

What You'll Do:

• Interpret SQL queries and ensure accuracy by validating business logic, assumptions, and filtering criteria.

• Document reporting requirements, logic, and data sources to maintain transparency and consistency.

• Support state and regulatory reporting, identifying and resolving validation issues to ensure precision.

• Perform root cause analysis on data errors or discrepancies, such as mismatched data types or duplications.

• Serve as the primary liaison between technical teams and business stakeholders, ensuring alignment on reporting needs.

• Develop processes to track dependencies across reports so that data or logic changes are quickly identified and addressed.

• Translate complex technical details into clear, actionable insights for non-technical end users, including clinical staff.

• Facilitate change management and project coordination for reporting initiatives.

• Contribute to automation and process improvements in reporting and data management.

​

What You'll Need:

• A four year degree or equivalent work experience

• 4+ years in a healthcare data analytics or business analyst role, with Medicaid/LTSS experience strongly preferred.

• 2+ years of hands-on SQL experience (required).

• Strong understanding of relational databases and data warehouses.

• Proven ability to document requirements, assumptions, and reporting logic in detail.

• Exceptional communication skills—able to present technical details in a way that non-technical stakeholders can understand.

• Ability to quickly grasp business processes and translate business needs into technical requirements.

• Ability to understand and leverage front-end systems to validate and analyze database activity, ensuring that business processes are accurately reflected in data.

• Experience with BI tools such as Tableau or Power BI (preferred, not required).

• Familiarity with statistical analysis or predictive forecasting (preferred, not required).

• Project management or change management experience.

• Strong problem-solving and troubleshooting abilities.

• Ability to work independently while thriving in a collaborative environment.

• Onsite availability in Indianapolis as needed, with occasional travel.

​

What we offer: 

We offer a competitive salary and benefits package, including unlimited PTO to encourage a healthy work-life balance, a company-funded Personal Giving Account for philanthropy at your discretion, and opportunities for professional development and growth. 

​

If you are passionate about making a positive impact in healthcare, we encourage you to apply and become part of our dedicated team.

​

EQUAL OPPORTUNITY EMPLOYER​​

​

Summit Managed Solutions is an equal opportunity employer, and we value diversity at our company. We do not just accept diverse backgrounds, we celebrate them. Our company, the work we do, and our partners benefit from the value of a diverse team. No team member's value lies alone in their diversity, and because we value diversity so highly, we reiterate that all hiring and employment decisions are made on merit, performance, competence, and business needs. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.