ERP Technical Analyst

Arizona Department of Administration • Phoenix, AZ

11d • $93,000 • Hybrid

About The Position

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.

Requirements

• Knowledge of relational database design, data modeling, and schema structures.
• Knowledge of ETL concepts, data transformation methodologies, and data warehousing principles.
• Knowledge of system integration architecture, REST/SOAP APIs, and webhook-driven automations.
• Knowledge of workflow automation engines (e.g., n8n) and modern AI/LLM tools (Google Gemini, NotebookLM).
• Knowledge of Enterprise ERP architecture and business functions (HRM, Payroll, Financials).
• Knowledge of Software Development Life Cycle (SDLC), testing methodologies, and Agile environments.
• Skills in advanced SQL querying, data validation, performance tuning, and database troubleshooting.
• Skills in developing and managing ETL jobs using tools like Pentaho Data Integration (PDI/Kettle).
• Skills in configuring automation scripts, workflow pipelines, and system API endpoints.
• Skills in translating high-level business problems into technical architecture diagrams and implementation specifications.
• Skills in writing clean technical documentation, system specs, and deployment runbooks.
• Skills in communicating complex technical solutions to non-technical business partners.
• Ability to independently debug and resolve system errors, data inconsistencies, and batch process failures.
• Ability to evaluate emerging technical tools, APIs, and AI models for practical enterprise implementation.
• Ability to prioritize and manage concurrent technical deliverables under tight deadlines.
• Ability to adapt quickly to evolving database infrastructure and cloud/on-prem hybrid systems.
• Ability to work seamlessly with cross-functional teams comprising system admins, DBAs, developers, and agency directors.
• Proven, hands-on experience in writing SQL queries and data analysis.
• 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).

Nice To Haves

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

Responsibilities

• 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.
• 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.
• Architect and build enterprise workflow automations using n8n, develop API integrations, and implement AI productivity tools (Google Gemini, NotebookLM) to automate manual operations.
• Partner with agency business owners to conduct deep-dive process mapping, converting operational needs into functional/technical specs, workflow diagrams, and integration test scripts.
• 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).

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level