Business Analyst - Located in Dubuque, IA

Medical Associates • Dubuque, IA

14h • Onsite

About The Position

Medical Associates Clinic & Health Plans is seeking a Business Analyst with strong Power BI expertise to provide reporting and analytics across the Health Plan and Clinic. The role transforms raw data into intuitive dashboards and reports that inform decision-making, and supports regulatory compliance through internal audits. The position offers opportunities for training and career growth.

This is a full-time position with stated hours of 8:00 a.m. to 5:00 p.m.; some flexibility in work hours may be possible. The work location is the Medical Associates Health Plans building at 1605 Associates Drive in Dubuque, Iowa.

The role requires proven Power BI and advanced Excel skills, including VLOOKUPs and pivot tables. SQL, healthcare, auditing, or insurance experience is helpful but not required. The position calls for independence, self-motivation, organization, attention to detail, strong communication, and the ability to explain data to non-technical stakeholders. One to three years of similar or related experience is stated. An education equivalent to a four-year bachelor's degree is expected; analytics, finance, or math is preferred.

The work involves extensive personal contact and may involve sensitive matters, motivating or influencing others, and fostering relationships with outside entities. Physical aspects listed include reaching, lifting, fingering, grasping, talking, hearing, vision of 20/40 or better in the best eye with or without correction, repetitive wrist, hand, or finger motions, and sedentary work involving sitting most of the time and exerting up to 10 pounds occasionally. The work environment is described as having no substantial exposure to adverse environmental conditions, such as in typical office or administrative work.

Requirements

• Proven experience with Power BI and advanced Excel functions, including VLOOKUPs and pivot tables.
• One to three years of similar or related experience.
• Education equivalent to a four-year bachelor's degree.
• Ability to work independently and self-motivate while managing multiple priorities.
• Strong communication skills, including the ability to present data clearly to non-technical stakeholders.
• Highly organized with excellent attention to detail.
• Passion for learning new tools, methodologies, and analytical approaches.
• Ability to meet the described physical demands, including sedentary work, repetitive hand and wrist motions, and vision of 20/40 or better in the best eye with or without correction.

Nice To Haves

• Healthcare experience.
• Experience with SQL, auditing, or insurance.
• A bachelor's degree in analytics, finance, or math.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports in Power BI.
• Create visualizations that communicate trends, KPIs, and performance metrics to business leaders.
• Manage Power BI datasets, data models, and relationships to support accurate reporting.
• Cleanse, validate, and transform raw data into meaningful outputs.
• Identify patterns, trends, and correlations to support strategic decision-making.
• Prepare reports, summary analyses, and presentations for executives.
• Develop and conduct internal audits for Health Plan departments.
• Validate and analyze audit results and present findings at Quarterly Compliance Meetings.
• Recommend improvements to processes, reporting, and data integrity.

Benefits

• Single or family health insurance with discounted premium rates for wellness program participation.
• 401(k) with immediate matching of 50% on the dollar up to 7% of pay, plus additional annual profit sharing.
• Flexible paid time off program providing 24 days off per year.
• Medical and dependent care flexible spending accounts.
• Life insurance.
• Long-term disability coverage.
• Short-term disability coverage.
• Dental insurance.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level