AHCCCS

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

Must Reside in Arizona.

Salary:  $64,000 - $74,000

Grade: 26

FLSA: 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.

A career in public service awaits you. COME JOIN OUR TEAM!

A great benefit of working for the State of Arizona is a fantastic work/life balance. State employees enjoy challenging work, popular remote work options, comprehensive health and wellness benefits, and career growth opportunities.

What You'll Do to Contribute to Agency Success:

The Information Services Division (ISD) is looking for a highly motivated individual to join our team as a Data Warehouse Developer for the Business Intelligence team within the Information Services Division at AHCCCS. The Data Warehouse developer will work with various customers throughout the agency to identify data needs and then define, develop and test new extract, transform, and load (ETL) solutions. This person will also be asked to maintain core production systems that manage the ETL processes, reporting application, and data warehouse. Occasionally this position will entail being on-call for production and technology support to ensure the timeliness and accuracy of all data loads.

The AHCCCS Data Warehousing and Business Intelligence (DW/BI) team plays a critical role in enabling data-driven decision-making that supports Arizona’s Medicaid programs and mission to deliver cost-effective, high-quality healthcare. The team manages an enterprise analytics ecosystem built on Informatica for ETL orchestration, Azure Synapse Dedicated SQL Pool for data warehousing, Cognos and Power BI for reporting and analytics, and Control-M for production workflow management.

We are currently leading a major modernization initiative to migrate to Microsoft Fabric, which unifies our data engineering, data warehousing, and analytics capabilities within a single cloud-native platform. This transformation will empower AHCCCS to deliver faster insights, scale efficiently, and leverage advanced AI and automation for smarter analytics.

Joining our team means being part of an environment that values innovation, collaboration, and continuous improvement. You’ll have the opportunity to contribute to the future of AHCCCS’ enterprise data architecture—designing, building, and optimizing modern data solutions that directly impact the agency’s ability to serve Arizonans more effectively.

Major duties and responsibilities include but are not limited to:
• Manage data extractions, transformations and load procedures including analysis of existing source systems and data sources and monitor ETL workflows. Translate functional and technical requirements into detailed architecture, design and extensible code. Provide expertise in SQL development and data analysis.
• Support and enhance existing extract, transform, and load processes. Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules, data flows and transformations.
• Actively participate in multi-divisional projects as a data lead. Interface with all areas affected by the project including end users, peers, and infrastructure teams. Provide technical and analytical guidance for enterprise data warehouse architecture and implement best practices in application report development.
• Works with stakeholders to identify analytical requirements. QA and troubleshoot data; and develop, test, and validate data sets to be utilized in various analytical reports and dashboards throughout the agency.
• Provide periodic 24/7 on call support for production issues.
• Attend meetings/seminars within and outside the Agency with regard to responsibilities and maintain an effective working relationship with those contacted in the course of work.

Knowledge:
• Data Warehouse concepts, MPP Best practices, and BI strategies/procedures
• ETL tools and processes (i.e. Informatica, ADF, Notebooks)
• Azure SQL/Synapse database management systems, warehouse & lakehouse (Databricks/Fabric) architectures
• Strong understanding of T-SQL, relational or dimensional data modeling & Power BI
• Experience working in Linux environment
• Medicaid/Medicare care programs and services

Skills:
• Business Requirements Analysis
• SQL query optimization
• ETL design and development
• Data Analysis / Data Modeling
• Written and verbal communication
• Interpersonal Relationships
• Analysis and Problem Solving
• Technical writing

Abilities:
• Design and manage the BI tools and applications environment
• Multi-task with quick turnaround times while under pressure
• Develop, manage, and update data models, including physical and logical models of the data warehouse, datamart, and staging area
• Set and meet deadlines
• Work with and understand large data sets
• QA and troubleshoot data
• Work in a remote environment

Minimum:
• Any combination of training and experience that meet the knowledge, skills, and abilities (KSAs); typical ways KSAs are obtained may include but are not limited to: relevant degree from an accredited college or university, coursework and respective work experience. Minimum of 2 years of ETL, 1 year in Power BI reporting or Tabular modeling, 2 years in SQL or Synapse experience.

Preferred:
• Bachelor's degree in Computer Information Systems, Computer Science or related area. 2+ years of data warehousing experience related to databases and BI tools. 2+ years of experience defining and developing ETL processes. 2+ years in Synapse. 2+ years in PBI/Tabular. Experience in Microsoft Fabric. Knowledge of health care operations and terminology; preferably within Medicaid.

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

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