Business Analyst - Located in Dubuque, IA
Medical Associates
Invite-only right now: save jobs, track applications, build tailored resumesAlready have an account? Log in
- Location
- Dubuque, IA
- Work style
- On-site
- Job type
- Full time
- Posted
- Oct 9
- 10 days ago
Career path
See where this role leads
Jigup maps the next three moves from a job like this one, with the titles and the skills each step asks for.
About the company
Medical Associates
Hospital & health care · 1,001 to 5,000 employees
What you'll do
- Develop and maintain Power BI dashboards, reports, and data models; analyze data and present insights to leaders.
- Conduct internal audits, report findings, and recommend improvements to processes and data integrity.
What you need
- Requires one to three years of similar or related experience and education equivalent to a four-year bachelor's degree.
- Physical requirements include sedentary work, lifting up to 10 pounds, and the listed reaching, fingering, grasping, communication, hearing, and vision abilities.
- Education: a bachelor's degree
Key skills
Power BIadvanced Excel functionsdata visualizationSQLcommunication skillsattention to detail
Keywords for your resumePro
The words this employer's screening is likely to look for.
This job lists resume keywords
The terms this posting uses, pulled out so you can mirror them in your resume. Jigup Pro members see the list on the job board.
Perks
- Health Insurance
- 401k
- Profit Sharing
- Flexible Paid Time Off
- Flex Spending Accounts
- Life insurance
- Long Term Disability Coverage
- Dental Insurance
See full description on company page, apply now
Read the full posting here
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.
Physical Aspects:
Reaching - Extending hand(s) and arm(s) in any direction.
Lifting - Raising objects from a lower to a higher position or moving objects horizontally from position-to-position. This factor is important if it occurs to a considerable degree and requires the substantial use of the upper extremities and back muscles.
Fingering - Picking, pinching, typing or otherwise working, primarily with fingers rather than with the whole hand or arm as in handling.
Grasping - Applying pressure to an object with the fingers and palm.
Talking - Expressing or exchanging ideas by means of the spoken word. Those activities in which they must convey detailed or important spoken instructions to other workers accurately, loudly or quickly.
Hearing - Perceiving the nature of sound with or without correction. Ability to receive detailed information through oral communication and to make fine discriminations in sound, such as when making fine adjustments on machined parts.
Vision - 20 / 40 or better in the best eye with or without correction.
Repetitive Motions - Substantial movements (motions) of the wrists, hands and/or fingers.
Sedentary Work - Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Environmental Conditions: None - The worker is not substantially exposed to adverse environmental conditions (such as in typical office or administrative work).
Medical Associates Clinic & Health Plans is an equal opportunity employer committed to a diverse and inclusive workforce. Applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, pregnancy, age, national origin, marital status, parental status, disability, veteran status, or other distinguishing characteristics of diversity and inclusion, or any other protected status.
Please view Equal Employment Opportunity Posters provided by OFCCP https://www.eeoc.gov/poster