Power BI Analyst I

About the Role

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. This position turns trusted enterprise data into clear, accurate, and easy-to-use reporting in Power BI. No prior healthcare or Epic experience is required; training will be provided.

Key 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 reporting.
• 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 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.

Requirements & Tech Stack

• Hands-on experience with Power BI Desktop.
• Experience writing SQL for data analysis or reporting.
• Experience with DAX and Power Query (M) is beneficial.
• Experience with Power BI Service, Microsoft Fabric, or Azure data platforms is beneficial.
• Microsoft PL-300 (Power BI Data Analyst) certification is beneficial or willingness to obtain.

Qualifications

• 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).
• 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 is helpful.