• 517479

• PHOENIX
• REMOTE OPTIONS

• AHCCCS

• Full-time

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.

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

Open until filled

Salary: $100,000 - $120,000 

Grade: 30

Must reside in the State of Arizona

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

This position reports through the Information Services Division (ISD) as the Data Warehouse Manager for the Data Warehouse team at AHCCCS. This role can be managed in-person at our downtown Phoenix office, remote, or as a hybrid of both. 100% of the seven person data warehouse team is currently remote.

The Data Warehouse Manager is responsible for managing the data warehouse staff, systems, financial and operational resources. This position will work with staff and customers throughout the agency to identify data needs and then define, develop, and test solutions using sound data management techniques. This person will also be asked to maintain production ETL processes to ensure the timeliness and accuracy of all data loads. This individual will 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, lead 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.
• Support and enhance existing extract, transform, and load processes. With support of the Data Governance team, create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules, data flows and transformations.

Knowledge:

• Data Warehouse concepts, practices, and procedures.
• ETL tools and processes (i.e. Informatica).
• Oracle and SQL Server database management systems.
• Strong understanding of SQL and relational and multidimensional designs. 
• IBM Cognos Framework Manager, Tableau, PowerBI 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.
• Multi-task 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.
• Manage in a Virtual Office Environment

Minimum: 

• Bachelor’s degree plus 5 or more years of related experience in related discipline (or equivalent experience).

Preferred: 

• Bachelor's 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 complete the Electronic Employment Eligibility Verification Program (E-Verify), applicable to all newly hired State employees.
* 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.) AND have an acceptable driving record for the last 39 months including no DUI, suspension, or revocations and less than 8 points on your license. If an Out of State Driver License was held within the last 39 months, a copy of your MVR (Motor Vehicle Record) is required prior to driving for State Business. Employees may be required to use their own transportation as well as maintaining valid motor vehicle insurance and current Arizona vehicle registration; however, mileage will be reimbursed.

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)
* 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

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. Arizona State Government is an AA/EOE/ADA Reasonable Accommodation Employer.