Business Analyst -Healthcare Report Developer

Arizona Department of Administration • Phoenix, AZ

2d • Remote

About The Position

The Healthcare Report Developer partners with clinical, operational, and
administrative stakeholders to translate healthcare reporting needs into
technical specifications and actionable business intelligence solutions. This
role designs, develops, and maintains Power BI dashboards, paginated reports,
and data models using DAX and related tools to deliver accurate, timely, and
meaningful insights. The incumbent integrates and analyzes large, complex
datasets from multiple sources; performs data validation and quality checks; and
applies healthcare business knowledge (e.g., utilization, quality, access, and
financial measures) to ensure reporting aligns with program goals and regulatory
or organizational requirements. Responsibilities include creating intuitive
charts, visualizations, and interactive drilldowns that communicate trends and
performance clearly to both technical and non-technical audiences; documenting
data definitions and report logic; and supporting end users through training,
troubleshooting, and ongoing enhancements. The Healthcare Report Developer also
responds to internal and external data requests, collaborates with data
warehouse and governance partners to improve data availability and integrity,
and ensures reporting solutions follow established standards for security,
privacy, and controlled access.

Requirements

• Bachelor's degree and/or 5 years of experience in business analysis (or equivalent experience). Expertise in Power Bi (3+ years).
• Business intelligence concepts, dimensional modeling, and reporting life cycle (requirements, build, test, deploy, support)
• Power BI ecosystem, including semantic models, Power Query, Power BI Service, and paginated reporting; DAX concepts and measure design
• Relational databases and data warehouse concepts; SQL fundamentals; data quality, validation, and reconciliation methods
• Healthcare data concepts and terminology (e.g., claims/encounters, members, providers, utilization, quality measures); applicable privacy and security practices
• Developing clear, user-centered dashboards and reports with effective visual design, KPI definition, and interactivity
• Writing, testing, and optimizing DAX measures; troubleshooting filter context and performance issues
• Data analysis using SQL and Excel; creating repeatable extracts, reconciliations, and quality checks
• Gathering requirements, documenting business definitions, and managing multiple priorities to meet deadlines
• Communicating technical concepts to nontechnical audiences; providing training, support, and written documentation
• Analyze complex healthcare datasets, identify trends and drivers, and translate findings into actionable insights
• Independently plan and deliver reporting solutions from intake through release, including testing and stakeholder sign-off
• Explain measures, assumptions, and limitations clearly and consistently to support appropriate use of data
• Collaborate effectively across teams, build trust with customers, and navigate competing priorities in a deadline-driven environment
• Maintain confidentiality and apply data security controls when handling protected or sensitive information

Nice To Haves

• 10+ years Business Analyst or Business Intelligence Analyst experience
• Programmer/Developer background is a plus.
• Familiarity with mainframe applications/languages (COBOL/ as well as Cloud based User Interfaces.
• Demonstrated ability for documenting requirements, meeting records, change requests, industry standards associated with an SDLC.
• PMI certification and Lean or Six Six-sigma certification is a plus.
• Medical terminology and/or managed healthcare experience a plus.

Responsibilities

• Design, build, and maintain Power BI dashboards, reports (including paginated), and supporting semantic models to meet healthcare reporting requirements. Create effective visualizations, KPIs, and drill-through experiences; write and optimize DAX measures; and apply best practices for usability, performance, and accessibility. Validate results against source systems and business rules, ensuring outputs are accurate, timely, and fit for decision-making and compliance reporting.
• Partner with clinical, operational, finance, and IT stakeholders to elicit and document reporting needs; translate business questions into technical specifications, data definitions, and acceptance criteria. Identify required data elements, develop reusable datasets, and support data modeling for large, complex healthcare data sources. Coordinate priorities, timelines, and release plans, and communicate status, risks, and dependencies to ensure deliverables align with organizational goals.
• Analyze and interpret report outputs to identify trends, outliers, and drivers of performance (e.g., utilization, quality, access, and financial metrics). Provide clear written narratives and verbal briefings tailored to technical and non-technical audiences, including methodology, limitations, and recommended actions. Respond to ad hoc data requests, develop standardized extracts as needed, and ensure consistent interpretation of measures across teams.
• Provide end-user support for Power BI content, including troubleshooting, issue triage, and root-cause analysis of data or visualization problems. Develop job aids and deliver training (group and one-on-one) on dashboard navigation, self-service reporting, and interpretation of metrics. Gather feedback, incorporate enhancements, and promote adoption through consistent standards and responsive customer service.
• Participate in project, data governance, and stakeholder meetings to align reporting solutions with evolving healthcare requirements and priorities. Ensure reports and datasets follow security, privacy, and controlled access standards, support documentation of data lineage, definitions, and report logic. Collaborate with data warehouse, ETL, and analytics partners to improve data quality, performance, and availability, and complete other related duties as assigned.

Benefits

• 10 paid holidays per year
• Paid Vacation and Sick time off (13 and 12 days per year respectively) - start earning it your 1st day (prorated for part-time employees)
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child. Learn more about the Paid Parental Leave pilot program here.
• Other Leaves - Bereavement, civic duty, and military.
• A top-ranked retirement program with lifetime pension benefits
• A robust and affordable insurance plan, including medical, dental, life, and disability insurance
• Participation eligibility in the Public Service Loan Forgiveness Program (must meet qualifications)
• RideShare and Public Transit Subsidy
• A variety of learning and career development opportunities

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees