OPEN POSITIONS
Technical Business Analyst
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 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.
What You'll Do:
-
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
-
Learn and apply relevant regulations to compile and scrub data sets
-
Review 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
-
-
Prepare and present reports and dashboards that support decision-making based on trends and outcomes
-
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, this may include 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
What You'll Need:
-
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 clear concise documentation that can be easily understood by internal and external clients
-
Ability to employ critical thinking skills and work independently while also working well within a team environment
-
Skilled communicator who is comfortable, effective, and influential in meetings with senior management teams
-
Self-starter who can thrive in an unstructured and collaborative team environment
-
Ability to be onsite with partners in Indianapolis as needed
-
Ability to travel occasionally throughout the year
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.
WHAT WE OFFER
-
Competitive salary plus bonus plan
-
Medical, dental & vision Insurance with employer HSA contribution
-
Company paid STD/LTD and Life Insurance
-
Unlimited PTO plan to encourage a healthy work - life balance
-
Paid company holidays
-
401k with company contribution
-
Company funded Personal Giving Account for philanthropy at your discretion
-
Monthly technology stipend to help cover additional working expenses
-
A fun, collaborative, entrepreneurial environment with support from empathetic leaders
-
The opportunity to create, build and grow innovative solutions with world class partners
WHAT WE VALUE
WE TAKE INITIATIVE
We have a bias for action. We make decisions with imperfect information and quickly move forward. We are comfortable with discomfort. We learn, we iterate, and we progress.
WE IMPACT
We have exceptionally high standards and strive to add value through all interactions. We seek, uncover, and speak truth. We measure our success in terms of what we build for partners.
WE INNOVATE
We dream big and we lead through vision. We challenge the status quo and push boundaries. We’re optimists who ignite positive transformations.
ABOUT INDIANA MEDICAID
Medicaid is a health program that provides insurance and benefits for specific populations in the US. The Federal government establishes general guidelines for the administration of Medicaid benefits. Individual states are charged with administering Medicaid so eligibility requirements and the type and scope of services provided can vary by state.
In Indiana, there are 4 main Medicaid programs: Healthy Indiana Plan (HIP), Hoosier Healthwise (HHW), Hoosier Care Connect (HCC), and PathWays. HIP covers Indiana residents ages 19 to 64 who meet specific income levels. HHW covers children up to age 19 and pregnant women. HCC covers individuals who are aged 65 years and older, blind, or disabled and who are also not eligible for Medicare. PathWays will launch in 2024 and covers Hoosiers aged 60 and over who receive Medicaid (or Medicaid and Medicare) benefits.
The state of Indiana contracts the administration of its Medicaid programs (a term known as Managed Care) to insurance companies like Elevance Health (formerly known as Anthem), Humana, CareSource, MDwise, UnitedHealthcare, and others. These insurance companies are responsible for ensuring the care of their members and do way more than just process claims and provide a network of doctors and hospitals. These companies also ensure members have reliable transportation to appointments, have access to healthy food, educate youth on the importance of annual physicals, provide nurse case managers to members with chronic illnesses, provide member resources for stable housing, convene events and celebrations in communities, collaborate with professional sports teams to raise awareness of health issues, coordinate in-home care, deliver dental hygiene kits to churches, implement telemedicine solutions to help those living in rural areas, guide first-time-mothers through their pregnancy journey, and the list goes on!
