Business Analyst - Located in Dubuque, IA

Medical Associates • Dubuque, IA

9d • Onsite

About The Position

Medical Associates Clinic & Health Plans is seeking a Business Analyst with strong Power BI expertise to provide reporting and analytics for the Health Plan and Clinic. The role transforms raw data into intuitive dashboards and reports that guide decision-making, supports internal audits and regulatory compliance, and offers opportunities for training and career growth. The position is full-time, based at the Medical Associates Health Plans building at 1605 Associates Drive, with a stated schedule of 8:00 a.m. to 5:00 p.m. Some flexibility in work hours may be possible.

The successful candidate will have proven experience with Power BI and advanced Excel functions, and be able to work independently, manage multiple priorities, communicate data clearly to non-technical stakeholders, and maintain strong organization and attention to detail. Experience with SQL, healthcare, auditing, or insurance is helpful but not required. The position requires one to three years of similar or related experience and education equivalent to a four-year bachelor's degree; analytics, finance, or math is preferred.

Requirements

• Proven experience with Power BI.
• Experience with 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.
• Strong organization and attention to detail.
• A significant level of trust and diplomacy; courtesy and tact in work involving extensive personal contact, sensitive matters, and motivating or influencing others.
• Ability to foster sound relationships with outside entities.

Nice To Haves

• Healthcare experience.
• Experience with SQL, auditing, or insurance.
• Degree focus in analytics, finance, or math.
• Passion for learning new tools, methodologies, and analytical approaches.

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 at 50% on the dollar up to 7% of pay, plus additional annual profit sharing.
• Flexible paid time off program: 24 days off per year.
• Medical and dependent care flexible spending accounts.
• Life insurance.
• Long-term disability coverage.
• Short-term disability coverage.
• Dental insurance.
• Training and career growth opportunities.

What This Job Offers

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