Technical Business Analyst

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.

We are seeking a Technical Business Analyst who will be responsible for building and maintaining Power BI dashboards, Power Automate workflows, and Power Platform solutions that support clinical and operational teams. The role also performs data analysis to support reporting accuracy and informed decision-making.

This position will support process engineering and automation of internal tracking databases for clinical and operational staff to leverage. The Technical Business Analyst will monitor reporting usage and trends, ensure data quality, and help identify opportunities for user education and adoption improvements.

The Technical Business Analyst will use SQL, Oracle, business intelligence tools, operational reporting, and business automation to build solutions, perform root cause analysis and interpret and present data using visualization tools. Ideal candidates will have experience working in a healthcare setting, presenting results to clinical staff, supporting process automation initiatives, and effectively communicating with both business and technology leaders.

We are seeking an individual who is driven and self‑motivated with a high-level of professionalism, a passion for innovation, and a business style that is scrappy, strategic, creative, team‑oriented, hands‑on, and collaborative.

• Build and maintain Power BI dashboards and reports for clinical and operational stakeholders
• Develop Power Automate flows to streamline reporting, data collection, and manual processes
• Partner with business users to translate needs into Power Platform solutions
• Support data validation and analytics to ensure reporting accuracy
• Employ various techniques to analyze large volumes of healthcare data sets including data manipulation, extraction and data architecture to combine sources, learning and applying relevant regulations to compile and scrub data sets, reviewing reports and performance indicators to identify trends, risks, and improvement opportunities
• Prepare and present final analysis reports for stakeholders, leveraging data to tell a story that will guide decision‑making based on results and trends
• Develop and maintain reporting datasets, documentation, and data dictionaries to ensure transparency and consistency
• Automate business processes for efficiency creating macros or code for multi‑source processes, including maintenance of SharePoint‑based trackers and reporting tools used by clinical and operational teams
• Support training and adoption for shared dashboards, reports, and automated workflows
• Contribute to company efforts to create best‑in‑class programs and health‑related initiatives and ensure the scalability of solutions through documentation, playbooks, and systems
• Contribute to building a culture at Summit of delivering value at every partner interaction
• Seek out and build amazing networks within healthcare and other growth industries

• A four‑year degree or equivalent work experience
• 4+ years of experience in reporting, analytics, or business intelligence roles in a health care setting or demonstrated experience in research, statistical analyses, and process automation
• Strong understanding of relational databases and data warehouses
• Experience with SQL and Oracle desired
• Excellent analytical skills and demonstrated troubleshooting and problem‑solving skills
• Hands‑on experience with Power BI dashboard development and Power Automate workflow creation
• Experience with MS Excel and other business intelligence or data visualization tools (e.g., Tableau)
• A keen eye for finding process improvements and a passion for operational efficiencies
• Exceptional communication skills (verbal and written) with the ability to produce…