Power BI Analyst I

Duly Health and Care; Chicago (IL); On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

Medical coverage

Mental health support

Life & disability insurance

Tuition reimbursement

401(k) match

Volunteer time off

Parental leave

Adoption/surrogacy benefit

Job summary

Duly Health and Care in Chicago is seeking a Power BI Analyst I to build and maintain dashboards, reports, and semantic models that help clinical, operational, and business leaders make better decisions.

Working alongside senior BI developers, analysts, and data engineers, you will transform trusted enterprise data into clear, accurate reporting in Power BI, with training provided and no prior Epic experience required.

Qualifications

• Understanding of data visualization principles and audience design.
• Understanding of relational DB concepts and star schema modeling.
• Strong SQL skills.
• Strong analytical, organizational, and problem-solving skills.
• Strong communication skills for all organization levels.
• Attention to detail and reporting accuracy.
• Ability to work independently and in teams.
• Curiosity to learn modern BI practices.
• Familiarity with data governance, security, or privacy helpful.

Responsibilities

• Report and dashboard development: design, build, and maintain Power BI reports and dashboards.
• Develop data models, relationships, and DAX measures; shape data with Power Query.
• Test reports for accuracy and performance before release.
• Publish and manage content in Power BI Service; manage workspaces and refreshes.
• Ensure consistent design standards and visualization best practices.
• Data modeling, governance, and support; write/validate SQL for data sourcing.
• Document data sources, metrics, and release notes; provide user support and training.
• Collaborate with stakeholders to translate requirements into reporting solutions.
• Stay current with Power BI and Microsoft Fabric features; share learnings.

Skills

SQL skills

Data visualization

Attention to detail

Communication

Analytical thinking

Teamwork

Curiosity

Data governance

Education

Bachelor’s degree in IS/DS/CS/BA

2 years related BI experience

Tools

Power BI Desktop

Power BI Service

Microsoft Fabric

Azure data platforms

Job description

Benefits

• Comprehensive medical, dental, and vision benefits that include healthcare navigation assistance.
• Access to a mental health benefit at no cost.
• Employer provided life and disability insurance.
• $5,250 Tuition Reimbursement per year.
• Immediate 401(k) match.
• 40 hours paid volunteer time off.
• A culture committed to community engagement and social impact.
• Up to 12 weeks parental leave at 100% pay and a financial benefit for adoption and surrogacy for non-physician team members once eligibility requirements are met.

Primary Purpose

The Power BI Analyst I is an early-career role within the Data & Analytics team, responsible for building and maintaining the dashboards, reports, and semantic models that help clinical, operational, and business leaders make better decisions. Working alongside senior BI developers, analysts, and data engineers, this position turns trusted enterprise data into clear, accurate, and easy-to-use reporting in Power BI. This role is a strong fit for someone with a foundation in SQL and data visualization who wants to grow into a BI career in a healthcare setting. No prior healthcare or Epic experience is required; we will train you.

Major Responsibilities

Report and dashboard development (50%) Design, build, and maintain Power BI reports and dashboards that are clear, accurate, and intuitive for stakeholders Develop data models, relationships, and DAX measures, and shape data using Power Query Test reports for accuracy, performance, and usability before release Publish and manage content in the Power BI Service, including workspaces, refresh schedules, and access Apply consistent design standards, naming conventions, and visualization best practices

Data modeling, governance, and support (30%) Build and optimize semantic models using star schema and dimensional modeling principles Write and review SQL to source, validate, and reconcile data for reporti ng Follow organizational standards for data privacy and the protection of PHI/PII, including row-level security and appropriate access controls Document reports, data sources, metric definitions, and release notes Provide user support, light training, and troubleshooting for published reports

Collaboration and continuous improvement (20%) Partner with business stakeholders, including clinical and operational leaders, to gather requirements and translate them into reporting solutions Work with data engineers, architects, and analysts to ensure reporting is built on trusted, well-structured data Learn from senior BI developers through code reviews and mentoring Stay current with Power BI and Microsoft Fabric capabilities and share learnings with the team All other duties as assigned

Minimum Education and Experience

Bachelor's degree in information systems, data science, computer science, business analytics, or a related field; or 2 years of related experience; or an equivalent combination of education and experience 0-2 years of experience in business intelligence, reporting, or data analysis (internships, co-ops, and academic or portfolio projects count)

Hands-on experience with Power BI Desktop

Experience writing SQL for data analysis or reporting

Experience with DAX and Power Query (M) beneficial

Experience with Power BI Service, Microsoft Fabric, or Azure data platforms beneficial

Microsoft PL-300 (Power BI Data Analyst) certification beneficial or willingness to obtain

Healthcare or Epic Clarity experience not required; training provided

Minimum Knowledge, Skills, and Abilities (KSA)

• Understanding of data visualization principles and how to design for the audience
• Understanding of relational database concepts and dimensional modeling (fact and dimension tables, star schema)
• Strong SQL skills
• Strong analytical, organizational, and problem-solving skills
• Strong communication skills and the ability to explain results to all levels of the organization
• Attention to detail and a commitment to report accuracy and documentation
• Ability to work both independently and in a team-oriented environment
• Curiosity and a desire to learn modern BI practices
• Familiarity with data governance, data security, or privacy concepts helpful

If you are committed to putting our patients first and helping shape the future of care, you belong at Duly.

The compensation for this role includes a base pay range of $65,000 - $85,000, with the actual pay determined by factors such as skills, experience, education, certifications, geographic location, and internal equity. Additional compensation may be available through shift differentials, bonuses, and other incentives. Base pay is only a portion of the total rewards package.

Artificial Intelligence Disclosure

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.

Let’s start with what matters. People. Purpose. Care. At Duly Health and Care, we believe healthcare works best when it’s personal, connected, and led by people who truly care. We are a physician-led medical group built on trusted relationships, teamwork, and a shared commitment to putting patients first in every decision we make. Our team members are caregivers, collaborators, problem-solvers, and leaders. Together, we show up with compassion, act with purpose, and take ownership of the care we deliver and the experience we create. Whether you’re caring directly for patients or supporting the teams who do, your role matters here, and your voice is valued. We listen with intention, work as one, and challenge ourselves to keep improving, not for recognition, but because our patients, families, and communities count on us. Innovation at Duly isn’t about chasing what’s next for its own sake. It’s about finding better ways to deliver high-quality, affordable, and accessible care, today and into the future.