Address: 150 N. 18th Ave Phoenix AZ 85007

Must Reside in Arizona.

Salary: $64000 - $74000

Grade: 26

FLSA Status Exempt

Closing Date: Open Until Filled

This position may offer the ability to work remotely within Arizona based upon the agencys business needs and continual meeting of expected performance measures.

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.

What Youll 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 Arizonas 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. Youll have the opportunity to contribute to the future of AHCCCS enterprise data architecturedesigning building and optimizing modern data solutions that directly impact the agencys 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.
Works 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:
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

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:
Bachelors 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.

Successfully pass fingerprint background check prior employment verifications and reference checks; employment is contingent upon completion of the above-mentioned 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 R.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 (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 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 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
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.