Job No: 541331
Work Type: Full-time
Location: REMOTE OPTIONS
Categories: Human Resources,Information Technology/Services
ARIZONA DEPARTMENT OF ADMINISTRATION Delivering results that matter by providing best in class support services.
Business Intelligence Analyst Intermediate
Job Location:
Enterprise Resource Division (ERP)
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: $96,000 to $109,706
Grade: 26
Open Until Business Needs Are Met (1st Review of Resumes (6/29/2026)
Job Summary:
The Arizona Department of Administration (ADOA), Enterprise Resource Division (ERP) is seeking an analytical and collaborative Business Intelligence Analyst Intermediate to join its team. In this role, you will work closely with Information Technology teams and agency or project staff to gain a comprehensive understanding of the data landscape across various databases and applications. You will play a crucial part in translating complex business requirements into actionable, user-friendly reports and analytics, utilizing and developing robust data collection processes and business intelligence capabilities specifically tailored for the ADOA ERP Department's Power BI application. Additionally, you will assist in evaluating business requirements, priorities, and feasibility assessments, while developing use cases and user acceptance testing plans. A key component of this position involves defining key performance indicators and designing, developing, and documenting critical workflows, dashboards, alerts, reports, and user guides to support data-driven decision-making across the agency.
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:
Designing, developing, and maintaining business intelligence solutions including developing data pipelines to extract, transform, and load (ETL/ELT) data from CGI Insight into Snowflake.
Provide ongoing maintenance, troubleshooting, and enhancements for the data analytics platform and reporting systems. Conduct unit testing to ensure system stability.
Crafting and executing database queries upon request for data from business units and leadership.
Create and maintain dashboards and visualizations using BI tools like Power BI or Tableau to present data clearly.
Collaborate with finance, operations, and IT teams to gather complex business requirements. Translate these needs into technical data solutions and integrate systems across the department.
Develop and update technical documentation, including data definitions, business logic, and workflows. Assist in establishing policies, standards, and procedures for the collection and analysis of data.
Provide weekend work and after-hours support for Feature Set releases, system deployments, and other critical efforts.
Knowledge, Skills & Abilities (KSAs):
Knowledge of:
Deep understanding of CGI Advantage modules (Finance, Budgeting, Procurement, HR/Payroll).
Data warehousing concepts (star/snowflake schemas, fact/dimension modeling).
Cloud data platform architecture, especially Snowflake.
SQL fundamentals and advanced query optimization techniques.
ETL/ELT processes and data pipeline design.
Financial data structures (GL, AP, AR, budgeting) common in public sector systems.
Data governance, data quality, and security best practices.
Reporting and BI concepts (KPIs, dashboards, data storytelling).
Integration methods (APIs, flat files, middleware).
Understanding of role-based access control and compliance standards (e.g., SOC 2, HIPAA if applicable).
Skills in:
Write complex, performant SQL queries in Snowflake.
Build and optimize data models within Snowflake (tables, views, materialized views).
Develop ETL/ELT pipelines using tools like Snowflake Tasks, Streams, or external tools (e.g., Informatica, Talend).
Extract and transform data from CGI Advantage into analytics-ready formats.
Create dashboards using BI tools (e.g., Tableau, Power BI).
Implement data ingestion strategies (batch and near real-time).
Performance tuning for large-scale datasets.
Debug data discrepancies between source (CGI Advantage) and Snowflake.
Automate workflows and data refresh processes.
Document data pipelines, models, and business logic clearly.
Collaborate with finance/business stakeholders to translate requirements into technical solutions.
Ability to:
Analyze complex financial and operational data and translate it into actionable insights.
Bridge the gap between technical systems (Snowflake) and business users (finance, operations).
Manage multiple data integration projects simultaneously.
Quickly learn new modules or updates within CGI Advantage.
Ensure high data accuracy and integrity across systems.
Communicate technical findings clearly to non-technical stakeholders.
Troubleshoot end-to-end data issues across ERP -> ETL -> Warehouse -> BI layers.
Work independently while also contributing to cross-functional teams.
Adapt to evolving cloud technologies and BI tools.
Think critically about performance, scalability, and cost optimization in Snowflake.
Selective Preference(s):
A Bachelor's Degree in Computer Science, Information Systems, Business Management or closely related field (Preferred).
2 years of experience in a business intelligence or data analysis role (Preferred).
MS Power BI Data Analyst certification (Preferred).
Pre-Employment Requirements:
Background and reference check, including state and federal criminal records fingerprint check.
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. (https://publicstorage.dc4.pageuppeople.com/1045/ClientPublicFile/3601803f-02e5-4b70-b325-26c8ef309c1b.pdf)
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 (https://hr.az.gov/about/resources/family-leave-expansion) . For a complete list of benefits provided by The State of Arizona, please visit our benefits page (https://benefitoptions.az.gov/jobseekers)
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 christopher.langseth@azdoa.gov for assistance.
The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.
