PowerBI Data Analyst Intern - Kansas City, MO (Summer 2026)

Myers and Stauffer LC is a certified public accounting and health and human services consulting firm, specializing in audit, accounting, data management and consulting services to government-sponsored health care programs (primarily state Medicaid agencies, and the federal Center for Medicare & Medicaid Services). We have 45+ years of experience assisting our government clients with complex health care reimbursement and provider compliance issues, operate 21 offices and have over 900 associates nationwide.

At Myers and Stauffer, you will have a career that is rewarding while also supporting our state and federal government health and human serviceclients that focus on those in need. We are committed to providing our employees with professional growth and development opportunities, a diverse, dynamic, challenging work environment, and a strong and visionary leadership team.Our firm takes pride in the welcoming and collaborative culture we have throughout our offices. We are always willing to discuss potential flexibility that an employee may need to better suit their work-life wellbeing.

What We Offer:

• Health, Dental, and Vision insurance along with other competitive employee benefits for eligible associates
• Vacation time, sick time, and paid holidays
• Paid Parental Leave and available support resources
• 401K with company matching for eligible employees
• Tuition reimbursement, referral bonuses, paid volunteer community service time, mentor program, and a variety of other employee programs and perks
• A combination of technical and leadership development training at each career milestone
• Up to six counseling sessions per year for eligible employees through our Employee Assistance Program

We understand that changing or learning a new industry can discourage strong candidates from applying. Please do not hesitate to apply, as you may be the right fit for this position or another position we have open.

Position Overview:
The PowerBI Data Analyst Intern will work collaboratively with members of Myers and Stauffer's Managed Care team todevelop analytical dashboards using Microsoft PowerBI,analyze and calculate rates, and design ad hoc analyses for various clients. The intern should have a strong interest in analyzing and leveraging datasets to assess fiscal impacts, inform business decisions, and guide client recommendations.

Essential Functions and Primary Duties:

• Perform all aspects of a project or task and apply knowledge gained to future projects
• Possess and apply a solid understanding of the work environment; be punctual and present
• Respond to all inquiries and requests
• Strive to attain goals established by direct supervisors
• Positive attitude toward self, other professionals, clients, and Myers and Stauffer
• Ability to gain computer proficiency relative to administrative programs, spreadsheets, word processing, dashboards, and internet research
• Professional in appearance and manner
• Additional responsibilities as assigned

Preferred Qualifications:

• Minimum cumulative GPA of 3.25
• Active participation in student organizations and work experience in related field
• Proficient use of applicable software programs, including Microsoft Office suite,SQL Server Management Studio, and PowerBI
• Interest in health care data analysis
• Strong analytical and problem-solving skills
• Strong verbal and written communication skills
• Well organized with a high degree of accuracy and attention to detail
• Effectively able to multi-task with planning and efficiency
• Must be able to manage multiple deadlines and prioritize assignments
• Must be able to work in a team environment

Minimum Qualifications:

• Intern must be working toward a bachelor's or master's degree in a related field