AHCCCS

Address:  150 N. 18th Ave. Phoenix, AZ 85007

Must Reside in Arizona.

Salary: $60,500 - $66,000

Grade: S24

FLSA Status: Exempt

Closing Date: 

Open Until Filled

This position may offer the ability to work remotely, within Arizona, based upon the agency’s business needs and continual meeting of expected performance measures.

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.

Major duties and responsibilities include but are not limited to:
• 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.

Knowledge:
• 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

Skills:
• 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

Abilities:
• 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

Minimum:
• Bachelor's degree and/or 5 years of experience in business analysis (or equivalent experience). Expertise in Power Bi (3+ years).

Preferred:

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

• Successfully pass fingerprint background check, prior employment verifications and reference checks; employment is contingent upon completion of the above-mentioned process and the agency’s ability to reasonably accommodate any restrictions.
• Travel may be required for State business. Employees who drive on state business must complete any required driver training (see Arizona Administrative Code R2-10-207.12.)

• Candidates who might be selected for interview may be required to complete a data analysis exercise.

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver’s License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Among the many benefits of a career with the State of Arizona, there are:
• 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

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Lifetime Pension Benefit Program
• Administered through the Arizona State Retirement System (ASRS)
• Defined benefit plan that provides for life-long income upon retirement.
• Required participation for Long-Term Disability (LTD) and ASRS Retirement plan.
• Pre-taxed payroll contributions begin after a 27-week waiting period (prior contributions may waive the waiting period).

Deferred Retirement Compensation Program
• Voluntary participation.
• Program administered through Nationwide.
• Tax-deferred retirement investments through payroll deductions.

Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by emailing careers@azahcccs.gov.
Requests should be made as early as possible to allow time to arrange the accommodation. The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.