Healthcare Report Developer

AHCCCS

Arizona Health Care Cost Containment System (AHCCCS), Arizona’s Medicaid agency, is driven by its mission to deliver comprehensive, cost-effective health care to Arizonans in need. AHCCCS is a nationally acclaimed model among Medicaid programs and a recipient of multiple awards for excellence in workplace effectiveness and flexibility. AHCCCS employees are passionate about their work, committed to high performance, and dedicated to serving the citizens of Arizona. Among government agencies, AHCCCS is recognized for high employee engagement and satisfaction, supportive leadership, and flexible work environments, including remote work opportunities. With career paths for seasoned professionals in a variety of fields, entry-level positions, and internship opportunities, AHCCCS offers meaningful career opportunities in a competitive industry. Come join our dynamic and dedicated team. Accountability Community Innovation Leadership Passion Quality Respect Courage Teamwork Healthcare Report Developer Information Services Division (ISD) Job Location: 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. Job Summary 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 (such as 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, Skills & Abilities (KSAs) 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 Qualifications 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 and 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 Sigma certification is a plus Medical terminology and/or managed healthcare experience a plus Pre-Employment Requirements 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. 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). 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 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 Retirement 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. Contact Us Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by emailing View email address on click.appcast.io. 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. #J-18808-Ljbffr Arizona State Government