ERP Technical Analyst

State of Arizona; Phoenix (AZ); Remoto; USD 84.000 - 102.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health insurance

Paid parental leave

Vacation with holidays

Retirement plan

Descrizione del lavoro

The Arizona Department of Administration seeks an innovative ERP Technical Analyst to lead hands-on technical execution, data integration, and automation for CGI Advantage HRM and Financial systems. You will write SQL, manage ETL, and build automations with n8n, while leveraging AI tools to streamline pipelines.

Ideal candidates will pair strong database/ETL skills with the ability to engage stakeholders and translate requirements into precise specs.

Competenze

• Bachelor’s degree in CIS/CS/IT or related field with 3–5 years of hands-on SQL/ETL experience.
• Experience with CGI Advantage 4.0 HRM/Financial systems or similar ERPs.
• Proven ability to translate business needs into technical specs and tests.

Mansioni

• Write complex SQL queries and maintain ETL pipelines for data integrity.
• Lead troubleshooting and maintenance of CGI Advantage 4.0 HRM/Financial systems.
• Design enterprise workflow automations using n8n and API integrations.
• Translate business requirements into technical designs, diagrams, and tests.
• Support patches, schema changes, and production deployments with minimal downtime.

Conoscenze

SQL

ETL

API integrations

n8n

AI tools

HRM/ERP knowledge

SDLC/Agile

Data integration

Formazione

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

Strumenti

CGI Advantage 4.0 HRM/Financial

Pentaho Data Integration

Google Gemini NotebookLM

REST/SOAP APIs

Descrizione del lavoro

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.

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

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.