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

Must Reside in Arizona.

Salary: $60500 - $66000

Grade: S24

FLSA Status: Exempt

Closing Date:

Open Until Filled

This position may offer the ability to work remotely within Arizona based upon the agencys 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:
Bachelors 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 agencys 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 R.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:Drivers 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 programhere. 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
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.