Business Analyst - Located in Dubuque, IA

Medical Associates Clinic; Dubuque (IA); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health Insurance

401k & Profit Sharing

Paid Time Off 24 days

Flex Spending Accounts

Life & Disability Insurance

Job summary

Medical Associates Clinic is seeking a Business Analyst with strong Power BI expertise to turn raw data into interactive dashboards and reports that guide decision-making across the Health Plan and Clinic. You will be the go-to analytics expert for reporting, data visualization, and informed business insights.

This full-time, on-site role runs 8:00–5:00 with some flexibility. The position focuses on Power BI development, data analysis, and auditing for compliance, with opportunities for training

Qualifications

• One to three years of relevant experience; healthcare experience is a plus.
• Equivalent to a 4 year/Bachelors degree in analytics, finance or math (preferred).

Responsibilities

• Power BI Development & Reporting: Design, develop, and maintain interactive dashboards and reports in Power BI. Create visualizations that clearly communicate trends, KPIs, and performance metrics to business leaders. Manage datasets, data models, and relationships in Power BI for accurate reporting.
• Data Analysis & Insights: 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.
• Auditing & Compliance: Develop and conduct internal audits for Health Plan departments. Validate and analyze results, presenting findings at Quarterly Compliance Meetings. Recommend improvements to enhance processes, reporting, and data integrity.

Skills

Power BI

Advanced Excel

SQL basics

Education

Bachelor's degree in analytics, finance or math

Tools

SQL

Job description

Medical Associates Clinic & Health Plans is seeking a Business Analyst with strong Power BI expertise to join our team! The ideal candidate will be highly skilled in building interactive dashboards and reports in Power BI, with a strong background in data visualization, advanced Excel functions (VLOOKUPS, pivot tables), and the ability to translate complex data into actionable insights. Experience with SQL, healthcare, auditing, or insurance is helpful but not required.

The Role:

You will be the go-to expert for reporting and analytics, using Power BI to transform raw data into intuitive dashboards and reports that guide decision-making across the Health Plan and Clinic. You will also ensure regulatory compliance by supporting internal audits and will have opportunities for training and career growth.

This position is full-time position working 8:00 - 5:00pm. Some flexibility in work hours may be possible. Work location - Medical Associates Health Plans building (1605 Associates Drive).

Benefits Package Includes:

• Single or Family Health Insurance with discounted premium rates for wellness program participation
• 401k with immediate matching (50% on the dollar up to 7% of pay) + additional annual Profit Sharing
• Flexible Paid Time Off Program (24 days off/year)
• Medical and Dependent Care Flex Spending Accounts
• Life insurance, Long Term Disability Coverage, Short Term Disability Coverage, Dental Insurance, etc.

Qualities:

• Proven experience with Power BI and advanced Excel functions.
• Ability to work independently and self-motivate while managing multiple priorities.
• Strong communication skills, with 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.

Based on experience and department needs, this position will be able to support and contribute to the following major duties and responsibilities:

• Power BI Development & Reporting:
  • Design, develop, and maintain interactive dashboards and reports in Power BI.
  • Create visualizations that clearly communicate trends, KPIs, and performance metrics to business leaders.
  • Manage datasets, data models, and relationships in Power BI for accurate reporting.
• Data Analysis & Insights:
  • 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.
• Auditing & Compliance:
  • Develop and conduct internal audits for Health Plan departments.
  • Validate and analyze results, presenting findings at Quarterly Compliance Meetings.
  • Recommend improvements to enhance processes, reporting, and data integrity.

Knowledge And Skills

Experience: One to three years of similar or related experience. Healthcare experience is a plus!

Education:

Equivalent to 4 year/Bachelors degree (Analytics, finance or math preferred)

Interpersonal Skills:

A significant level of trust and diplomacy is required, in addition to normal courtesy and tact. Work involves extensive personal contact with others and/or is usually of a personal or sensitive nature. Work may involve motivating or influencing others. Outside contacts become important and fostering sound relationships with other entities (companies and/or individuals) becomes necessary.