ERP Technical Analyst

Arizona State Government; Phoenix, Northern (AZ, KY); Hybrid; USD 56,000 - 93,000; Full time

Benefits offered by this job

Health and dental insurance

Retirement plan

Paid holidays

Parental leave

Job summary

The Arizona Department of Administration (ADOA) ERP Division seeks an innovative ERP Technical Analyst to lead hands-on technical execution, data integration, and automation for the State’s HRM and Financial systems. You will write custom SQL scripts, manage ETL processes, and build workflow automations, using platforms like n8n and AI tools to streamline data pipelines and workflows.

You will collaborate with business stakeholders, ensure data integrity, and support production deployments while

Qualifications

• Bachelor’s degree in CIS/CS/IT/Engineering or related field; 3–5 years hands-on SQL/ETL experience.
• Experience writing SQL queries, ETL management, data reconciliation, and data troubleshooting.
• Experience with system integration architectures, REST/SOAP APIs and webhook automation.
• Familiarity with AI productivity tools in enterprise workflows is a plus.
• Strong communication with business stakeholders and cross-functional teams.

Responsibilities

• Write complex SQL queries and maintain ETL pipelines to ensure data integrity across systems.
• Lead troubleshooting and maintenance of CGI Advantage 4.0 HRM and Financial systems; liaise with vendors.
• Architect enterprise workflow automations using n8n and develop API integrations.
• Translate operational needs into technical specs, diagrams, and test scripts.
• Support patches, schema changes, and production deployments; occasional off-hours work.

Skills

SQL

ETL

Data Integration

n8n

API Integration

PDI/Kettle

AI tools

SDLC/Agile

Education

Bachelor’s degree in CIS/CS/IT/Engineering

Tools

Pentaho Data Integration

CGI Advantage 4.0 HRM

n8n

Google Gemini

NotebookLM

Job description

ARIZONA DEPARTMENT OF ADMINISTRATION

Delivering results that matter by providing best in class support services.

ERP Technical Analyst

Job Location:

Enterprise Resource Planning (ERP) Division

This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures

Main Office Location: 100 N 15th Ave, Phoenix, AZ 85007

Posting Details:

Salary: Up to $93,000

Grade: 26

Open Until Business Needs Are Met (1st Review of Resumes 10/01/2026)

Job Summary

The Arizona Department of Administration (ADOA) Enterprise Resource Planning (ERP) Division is seeking an innovative and results-driven ERP Technical Analyst. In this role, you will lead the hands-on technical execution, data integration, and automation required to optimize and maintain the State’s core CGI Advantage 4.0 Human Resource Management (HRM) and Financial systems. Operating at the intersection of systems architecture and business operations, you will write custom SQL scripts, manage ETL processes, build workflow automations, and translate complex agency requirements into precise technical specifications. Beyond standard system maintenance, you will drive modern enterprise engineering by building automations via platforms like n8n and leveraging AI-enabled tools (Google Gemini, NotebookLM) to streamline data pipelines and application workflows.

The ideal candidate is a technical problem-solver who pairs strong database management (SQL/ETL) and integration skills with the communication ability needed to engage directly with business stakeholders.

The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the State’s Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.

Job Duties

• Database & Data Integration Management: Write complex SQL queries, perform data reconciliation, execute data troubleshooting, and maintain ETL pipelines using Pentaho Data Integration (PDI/Kettle) to ensure high data integrity and accuracy across systems.
• System Administration & Troubleshooting: Lead the technical troubleshooting, configuration, maintenance, and enhancement of CGI Advantage 4.0 HRM and Financial systems, serving as the technical liaison with vendors and infrastructure teams.
• Process Automation & API Integration: Architect and build enterprise workflow automations using n8n, develop API integrations, and implement AI productivity tools (Google Gemini, NotebookLM) to automate manual operations.
• Technical Requirement Translation & Mapping: Partner with agency business owners to conduct deep-dive process mapping, converting operational needs into functional/technical specs, workflow diagrams, and integration test scripts.
• Operations, SOPs & Deployment Support: Maintain availability to support critical patch windows, schema changes, and production code deployments (which may occasionally require off-hours work to ensure zero downtime for state agencies).

Knowledge, Skills & Abilities (KSAs)

Knowledge of:

• Relational database design, data modeling, and schema structures.
• ETL concepts, data transformation methodologies, and data warehousing principles.
• System integration architecture, REST/SOAP APIs, and webhook-driven automations.
• Workflow automation engines (e.g., n8n) and modern AI/LLM tools (Google Gemini, NotebookLM).
• Enterprise ERP architecture and business functions (HRM, Payroll, Financials).
• Software Development Life Cycle (SDLC), testing methodologies, and Agile environments.

Skills in:

• Advanced SQL querying, data validation, performance tuning, and database troubleshooting.
• Developing and managing ETL jobs using tools like Pentaho Data Integration (PDI/Kettle).
• Configuring automation scripts, workflow pipelines, and system API endpoints.
• Translating high-level business problems into technical architecture diagrams and implementation specifications.
• Writing clean technical documentation, system specs, and deployment runbooks.
• Communicating complex technical solutions to non-technical business partners.

Ability to:

• Independently debug and resolve system errors, data inconsistencies, and batch process failures.
• Evaluate emerging technical tools, APIs, and AI models for practical enterprise implementation.
• Prioritize and manage concurrent technical deliverables under tight deadlines.
• Adapt quickly to evolving database infrastructure and cloud/on-prem hybrid systems.
• Work seamlessly with cross-functional teams comprising system admins, DBAs, developers, and agency directors.

Selective Preference(s)

• Demonstrated experience writing complex SQL queries and managing relational databases.
• Hands-on experience developing ETL pipelines using Pentaho Data Integration or similar tools (Talend, SSIS, Informatica).
• Hands-on experience building low-code/no-code or code-based automations using n8n, Zapier, or custom APIs.
• Direct technical support experience with CGI Advantage 4.0 HRM and Financial systems (or comparable enterprise ERPs like Workday, SAP, Oracle).
• Familiarity with practical application of AI tools (Google Gemini, NotebookLM) in technical workflows.

Pre-Employment Requirements

• Education & Experience: Bachelor’s degree in Computer Information Systems (CIS), Computer Science, Information Technology, Engineering, or a related field; AND at least three (3) to five (5) years of hands-on technical experience with SQL querying, ETL management, or systems analysis. (Equivalent combination of technical experience and education may be considered).
• Technical Pre-requisite: Proven, hands-on experience in writing SQL queries and data analysis.
• Background Check: Background and reference check, including state and federal criminal records fingerprint check.
• Driver’s License: If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, standard Driver’s License 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).

Benefits

The Arizona Department of Administration offers a comprehensive benefits package to include:

• Sick leave
• Vacation with 10 paid holidays per year
• Paid Parental Leave‑Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program)
• Health and dental insurance
• Retirement plan
• Life insurance and long-term disability insurance
• Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance

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 program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement

• Participation in ASRS Lifetime Benefit Pension Plan after 26 weeks of employment

Contact Us

• If you have any questions please feel free to contact Christopher Langseth at [e-mail] for assistance.
• The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.