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 Manager

Information Services Division (ISD)

Job Location:

Address:  801 E. Jefferson Street, Phoenix, AZ 85034

Posting Details:

Must reside in Arizona.

Salary:  $110,000 - $120,000

Grade: 30

Closing Date: Open Until Filled 

This position is eligible for full-time remote work (including virtual office arrangement in Arizona).

Job Summary:

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.

We are searching for someone to manage a small tenured data warehouse team and who is very proficient working in Azure Synapse, Informatica, or Databricks. If you’ve been a team lead position in a similar environment and are ready to move into a management role – this opportunity could be for you! 

What You'll Do:

The position reports through the Information Services Division (ISD) as the Data Warehouse Manager of the Data Warehouse team at AHCCCS. The Data Warehouse Manager is responsible for achieving the goals and objectives of AHCCCS through managing the data warehouse human, financial, and operational resources. You will work with customers throughout the agency to identify data needs and then define, develop and test solutions using sound data management techniques. You’ll also be asked to maintain production ETL processes, occasionally in an on-call capacity, to ensure the timeliness and accuracy of all data loads. As the  Data Warehouse Manager, you will need to have a strong technical background with extensive experience in an enterprise data warehouse environment.

 

Major duties and responsibilities include but are not limited to:
• Managerial duties include, but are not limited to leading the Data Warehouse team and assigned contractors, recruitment, setting objectives, analyzing performance, making staffing and data management decisions, managing deadlines, collaborating and advising Agency leadership and staff, and reviewing work.
• 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 ETL, SQL development, and data analysis to staff.
• As an expert in AHCCCS data, actively participant in inter-divisional projects as a data lead. Work to proactively obtain and provide information that will assist decision makers in determining what data AHCCCS has and how to effectively and efficiently access the available information. Collaborate on project management initiatives.
• 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.
• Work with staff and stakeholders to identify analytical requirements. Validate the integrity and quality of the data to be used, while troubleshooting any issues; and develop, test, and validate data sets to be utilized in various analytical reports and dashboards throughout the age