AHCCCS

Arizona Health Care Cost Containment System
Accountability Community Innovation Leadership Passion Quality Respect Courage Teamwork

The Arizona Health Care Cost Containment System (AHCCCS) Arizonas Medicaid agency is driven by its mission to deliver comprehensive costeffective 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 entrylevel positions and internship opportunities AHCCCS offers meaningful career opportunities in a competitive industry.

Come join our dynamic and dedicated team.

Address: 801 E. Jefferson Street Phoenix AZ 85034

Must reside in Arizona.

Salary: $110000 $120000

Grade: 30

Closing Date: Open Until Filled

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

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 youve 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 Youll 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. Youll also be asked to maintain production ETL processes occasionally in an oncall 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 interdivisional 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 agency.
Mentor data management techniques to developers and business users with less skill or experience while optimizing data warehouse performance. Collaborate on data management initiatives strategy and governance standards integration and quality.
Administer and manage data analytics platforms such as Cognos and Power BI to ensure optimal performance reliability and security. Collaborate with crossfunctional teams to design implement and refine data models that support reporting and decisionmaking processes. Assist in the upgrade patching and maintenance of analytics tools and systems to ensure they remain current and effective.
Proactively seek to add value to the system by staying current on data warehousing and data management industry and best practices by participating in projects learning collaboratives and trainings that involve leaders both inside and outside of the Agency.
Defines immediate and long term goals priorities and plans to ensure team goals are aligned with the goals and priorities of the organization. Identifies required resources; trains schedules and monitors resources; leads hiring process; accountable for effective use of resources and disciplinary action when required. Review and update direct staffs position descriptions as needed.
Assists in the development and support of policies procedures standards and forms.

Knowledge:
Data Warehouse concepts practices and procedures
ETL tools and processes (i.e. Informatica)
Oracle and SQLServer database management systems
Strong understanding of SQL and relational and multidimensional designs
IBM Cognos Framework Manager or equivalent BI tool
Medicaid/Medicare care programs and services
Expert technical knowledge of Agency programs operations and dependencies
PMMIS
Statistical financial and performance analysis methods and techniques

Skills:
Staff management and leadership techniques
Data Management Strategy and Governance Standards Integration and Quality
Business Requirements Analysis
Data Analysis / Data Modeling
ETL design and development
SQL query optimization
Written and verbal communication
Interpersonal Relationships
Project Management
Problem Solving
Decision making

Abilities:
Communicate with business users to determine requirements for data reports and analyses
Extract transform clean and move data and metadata so they can be loaded into a data warehouse data mart or operational data store
Design and manage the BI tools and applications environment
Multitask with quick turnaround times and under pressure
Model leadership characteristics positive attitude and personal responsibility
Develop manage and update data models including physical and logical models of the data warehouse datamart and staging area
Understanding of SQL and relational and multidimensional query designs
Interview end users to determine requirements for data reports analyses meta data training service levels data quality and performance
Work in a Virtual Office Environment

Minimum:
Bachelors degree plus 5 or more years of related experience in related discipline (or equivalent experience).

Preferred:
Bachelors degree in Computer Information Systems Computer Science or related area. 7 years of data warehousing experience related to databases and BI tools. 7 years of experience defining and developing ETL processes. Knowledge of health care operations and terminology; preferably within Medicaid. 3 years of managerial experience in Information Technology.

Successfully pass fingerprint background check prior employment verifications and reference checks; employment is contingent upon completion of the abovementioned 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 R210207.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:Drivers License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (EVerify).

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 parttime employees)
Paid Parental LeaveUp to 12 weeks per year paid leave for newborn or newlyplaced foster/adopted child. Learn more about the Paid Parental Leave pilot program here.
Other Leaves Bereavement civic duty and military.
A topranked 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 fulltime or parttime 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 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 lifelong income upon retirement.
Required participation for LongTerm Disability (LTD) and ASRS Retirement plan.
Pretaxed payroll contributions begin after a 27week waiting period (prior contributions may waive the waiting period).

Deferred Retirement Compensation Program
Voluntary participation.
Program administered through Nationwide.
Taxdeferred 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.