Power BI Analyst I

Duly Health and Care • Downers Grove, IL

2d • $65,000 - $85,000

About The Position

The Power BI Analyst I is an early-career role within the Data & Analytics team, responsible for building and maintaining 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. The role is suited to someone with a foundation in SQL and data visualization who wants to grow into a BI career in a healthcare setting. Prior healthcare or Epic experience is not required; training is provided.

Requirements

• 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.
• Understanding of data visualization principles and how to design for the audience.
• Understanding of relational database concepts and dimensional modeling, including fact and dimension tables and star schema.
• Strong SQL skills.
• Strong analytical, organizational, and problem-solving skills.
• Strong communication skills and ability to explain results to all levels of the organization.
• Attention to detail and commitment to report accuracy and documentation.
• Ability to work independently and in a team-oriented environment.
• Curiosity and desire to learn modern BI practices.

Nice To Haves

• Experience with DAX and Power Query (M).
• Experience with Power BI Service, Microsoft Fabric, or Azure data platforms.
• Microsoft PL-300 (Power BI Data Analyst) certification or willingness to obtain it.
• Familiarity with data governance, data security, or privacy concepts.
• Healthcare or Epic Clarity experience is not required; training is provided.

Responsibilities

• Design, build, and maintain clear, accurate, and intuitive Power BI reports and dashboards.
• 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 Power BI Service, including workspaces, refresh schedules, and access.
• Apply consistent design standards, naming conventions, and visualization best practices.
• Build and optimize semantic models using star schema and dimensional modeling principles.
• Write and review SQL to source, validate, and reconcile data for reporting.
• Follow organizational standards for data privacy and 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.
• 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.
• Perform other duties as assigned.

Benefits

• Comprehensive medical, dental, and vision benefits, including 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 of paid volunteer time off.
• Culture committed to community engagement and social impact.
• Up to 12 weeks of parental leave at 100% pay and a financial benefit for adoption and surrogacy for non-physician team members once eligibility requirements are met.

What This Job Offers

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