Business Intelligence Analyst Intermediate

Your Partner For A Stronger Arizona. DES works with families, community organizations, advocates and state and federal partners to realize our collective vision: A thriving Arizona. DES serves more than 3 million Arizonans. Our Mission is to strengthen individuals, families, and communities for a better quality of life.

Division of Benefits and Medical Eligibility (DBME)
Family Assistance Administration (FAA) Systems
8620 North 22nd Avenue, Phoenix, Arizona 85021

Salary: $31.7174 - $57.9481 Hourly ($65,968 - $120,532 Annually)
Grade: 26
Closing Date:
October 18, 2026

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.

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.

Essential Duties and Responsibilities include but are not limited to:

• Design Adhoc and Standard reports in Tableau, SSIS, or other technology solutions which may require writing SQL and "Run Book" documentation to support design. Record work-related activities in an operating system and/or place documents in the appropriate drive following system processes and procedures.
• Manage life-cycle development and deployment utilizing SSIS, SQL, Tableau, Visual Basic, MS Access, dimensional and relational database design, or other business intelligence software tools. Perform data analysis, data mining, design, development, and execution of Adhoc and standard reports, ensuring consistency and applicability to achieve established strategic objectives and goals.
• Serve on projects and/or pilots (develop Work plans, monitor, schedule, etc.) to provide technical guidance working collaboratively with the Analyst on design to ensure integration between Business Intelligence and business requirements, and ensure timely and successful completion.
• Write and/or provide input for requirements, framework, and mechanisms for data analytics, working closely with Analysts and End Users and make recommendations to support automation and maintenance, ensuring successful integration between the Business Intelligence environment and business requirements.
• Participate in planning, development, testing, and delivery of solutions, and data stewardship activities. Develop and/or review test plans, monitor testing (assist with testing), ensure results are adequately tested (integration testing of technical and functional requirements and regression testing to identify anomalies) and validated, and create system documentation.
• Develop, analyze, and evaluate business needs to improve workflow processes, troubleshoot Business Intelligence tool problems and tune for performance optimization and usability.
• Design and deliver end-user presentations, training, Desk-Aids, and/or associated materials to technical and non-technical audiences. Attend and participate in meetings.
• Other duties as assigned, as related to the position.

Knowledge in:

• Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.
• Basic knowledge of engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features.
• Statistical and business analysis, research, and…