AHCCCS

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

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

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 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 cross-functional teams to design, implement, and refine data models that support reporting and decision-making 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 staff's 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
• 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
• Work 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 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.