<table style="height: 17px; width: 100%; border-collapse: collapse; background-color: #4373BA" border="1"> <tbody> <tr style="height: 17px"> <td style="width: 100%; height: 17px"> <div class="job-header"> <h1 style="text-align: center"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 24pt;="" color:="" #ffffff"="">ARIZONA DEPARTMENT OF ADMINISTRATION</span></h1> <h2 style="text-align: center"><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><em><span style="font-size: 12pt; color: #FFFFFF">Delivering results that matter by providing best in class support services.</span></em></span></h2> </div> </td> </tr> </tbody> </table> <h3 dir="ltr" style="text-align: center"><span style="font-size: 24pt; font-family: " times="" new="" roman",="" times,="" serif"=""><strong>Business Intelligence Analyst Intermediate</strong></span></h3> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Job Location:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <h4 style="text-align: center"><span style="font-family: times new roman, times, serif"><span style="font-size: 16px">Enterprise Resource Division (ERP)<span style="font-family: " times="" new="" roman",="" times,="" serif"=""><br><br>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<br><br>Main Office Location: 100 N 15th Ave, Phoenix, AZ 85007</span></span></span></h4> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Posting Details:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <h4 style="text-align: center"><span style="font-family: times new roman, times, serif"><span style="font-size: 16px">Salary: $96,000 to $109,706 <br></span></span></h4> <h4 style="text-align: center"><span style="font-family: times new roman, times, serif"><span style="font-size: 16px">Grade: 26<br></span></span></h4> <h4 style="text-align: center"><span style="font-family: times new roman, times, serif"><span style="font-size: 16px">Open Until Business Needs Are Met (1st Review of Resumes (6/29/2026)   </span></span></h4> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Job Summary:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <p><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">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.</span></p> <p><em><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">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.</span></em></p> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Job Duties:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <ul> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Designing, developing, and maintaining business intelligence solutions including developing data pipelines to extract, transform, and load (ETL/ELT) data from CGI Insight into Snowflake.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Provide ongoing maintenance, troubleshooting, and enhancements for the data analytics platform and reporting systems. Conduct unit testing to ensure system stability.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Crafting and executing database queries upon request for data from business units and leadership.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Create and maintain dashboards and visualizations using BI tools like Power BI or Tableau to present data clearly.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">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.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">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.</span></li> <li style="text-align: left"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Provide weekend work and after-hours support for Feature Set releases, system deployments, and other critical efforts.</span></li> </ul> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Knowledge, Skills & Abilities (KSAs):</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <p><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"=""><strong>Knowledge of:</strong></span></p> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Deep understanding of CGI Advantage modules (Finance, Budgeting, Procurement, HR/Payroll).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Data warehousing concepts (star/snowflake schemas, fact/dimension modeling).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Cloud data platform architecture, especially Snowflake.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">SQL fundamentals and advanced query optimization techniques.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">ETL/ELT processes and data pipeline design.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Financial data structures (GL, AP, AR, budgeting) common in public sector systems.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Data governance, data quality, and security best practices.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Reporting and BI concepts (KPIs, dashboards, data storytelling).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Integration methods (APIs, flat files, middleware).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Understanding of role-based access control and compliance standards (e.g., SOC 2, HIPAA if applicable).</span></li> </ul> <p><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"=""><strong>Skills in:</strong></span></p> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Write complex, performant SQL queries in Snowflake.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Build and optimize data models within Snowflake (tables, views, materialized views).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Develop ETL/ELT pipelines using tools like Snowflake Tasks, Streams, or external tools (e.g., Informatica, Talend).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Extract and transform data from CGI Advantage into analytics-ready formats.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Create dashboards using BI tools (e.g., Tableau, Power BI).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Implement data ingestion strategies (batch and near real-time).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Performance tuning for large-scale datasets.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Debug data discrepancies between source (CGI Advantage) and Snowflake.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Automate workflows and data refresh processes.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Document data pipelines, models, and business logic clearly.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Collaborate with finance/business stakeholders to translate requirements into technical solutions.</span></li> </ul> <p><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"=""><strong>Ability to:</strong></span></p> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Analyze complex financial and operational data and translate it into actionable insights.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Bridge the gap between technical systems (Snowflake) and business users (finance, operations).</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Manage multiple data integration projects simultaneously.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Quickly learn new modules or updates within CGI Advantage.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Ensure high data accuracy and integrity across systems.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Communicate technical findings clearly to non-technical stakeholders.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Troubleshoot end-to-end data issues across ERP -> ETL -> Warehouse -> BI layers.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Work independently while also contributing to cross-functional teams.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Adapt to evolving cloud technologies and BI tools.</span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Think critically about performance, scalability, and cost optimization in Snowflake.</span></li> </ul> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Selective Preference(s):</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">A Bachelor’s Degree in Computer Science, Information Systems, Business Management or closely related field (Preferred).</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">2 years of experience in a business intelligence or data analysis role (Preferred).</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">MS Power BI Data Analyst certification (Preferred).</span></span></li> </ul> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Pre-Employment Requirements:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Background and reference check, including state and federal criminal records fingerprint check.</span></span></li> </ul> <p><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt"><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"=""><em><span>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: <a href="https://publicstorage.dc4.pageuppeople.com/1045/ClientPublicFile/3601803f-02e5-4b70-b325-26c8ef309c1b.pdf" target="_blank" rel="noopener noreferrer">Driver’s License Requirements.</a></span></em></span><br></span></span></p> <p><em><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).</span></span></em></p> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4; height: 17px" border="1"> <tbody> <tr style="height: 17px"> <td style="width: 100%; height: 17px"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Benefits:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <p><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">The Arizona Department of Administration offers a comprehensive benefits package to include:</span></span></p> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Sick leave</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Vacation with 10 paid holidays per year</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program)</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Health and dental insurance</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Retirement plan</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Life insurance and long-term disability insurance</span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance<br></span></span></li> </ul> <p><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt"><em><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">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.</span></em></span></span></p> <p><em><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Learn more about the Paid Parental Leave program <a title="Paid Parental Leave Pilot Program" href="https://hr.az.gov/about/resources/family-leave-expansion" target="_blank" rel="noopener noreferrer">here</a>. For a complete list of benefits provided by <span>The State of Arizona, please visit our <a href="https://benefitoptions.az.gov/jobseekers" target="_blank" rel="noopener noreferrer">benefits page</a></span></span></em></p> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Retirement</span>:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">Participation in ASRS Lifetime Benefit Pension Plan after 26 weeks of employment.</span></span></li> </ul> </div> <div class="job-divider"> <table style="width: 100%; border-collapse: collapse; background-color: #D4D4D4" border="1"> <tbody> <tr> <td style="width: 100%"><strong><span style="font-family: " times="" new="" roman",="" times,="" serif;="" font-size:="" 12pt"="">Contact Us:</span></strong></td> </tr> </tbody> </table> </div> <div class="job-content"> <ul> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">If you have any questions please feel free to contact Christopher Langseth at christopher.langseth@azdoa.gov for assistance.</span></span></span></li> <li><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-family: " times="" new="" roman",="" times,="" serif"=""><span style="font-size: 12pt">The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.</span></span></span></li> </ul> </div>