State of Arizona
AHCCCS Arizona Health Care Cost Containment System
Accountability, Community, Innovation, Leadership, Passion, Quality, Respect, Courage, Teamwork
The 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.
Data Warehouse Developer – Information Services Division (ISD) Job Location: 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!
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.
Work 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, Skills & Abilities (KSAs) 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
Qualifications 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.
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.
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 lifelong 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.
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 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.
#J-18808-Ljbffr
The 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.
Data Warehouse Developer – Information Services Division (ISD) Job Location: 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!
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.
Work 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, Skills & Abilities (KSAs) 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
Qualifications 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.
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.
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 lifelong 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.
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 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.
#J-18808-Ljbffr