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

Salary: $70,871 - $141,454 

Grade: 28

Closing Date: February 2, 2026

Would you like to be part of an amazing team that helps Arizonans thrive? At the Department of Economic Security (DES) we strength individuals, families, and communities for a better quality of life. DES is looking for individuals that are committed to service, community, and teamwork. To learn more about DES please visit des.az.gov or click on the link here to view ‘Our DES’ video. Come Join the DES Team!

The Department of Economic Security, Division of Benefits and Medical Eligibility, is seeking an experienced and highly motivated individual to join our team as a Business Intelligence Analyst Senior for the Family Assistance Administration (FAA) Systems team. Under minimal supervision, performs the most complex, cross-functional/enterprise-wide tasks/solutions at an expert level. Serves as a lead to perform data analysis, data mining, design, development, testing activities, and execution of complex custom reports to achieve strategic objectives and goals, and is a Subject Matter Expert (SME) for SSIS, SSRS, SQL, Visual Basic, Tableau, etc. Lead technologist on all facets of projects/pilots (develop Work Plan, schedule, monitor, etc.) for design or enhancements to the system/reports.

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 and develop complex custom reports including coding 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.
  
• SME for SSIS, SSRS, SQL, Visual Basic, Tableau Developer, MS Access, and new technology platforms, dimensional and relational database design to manage full life-cycle development and deployment. Perform data analysis, data mining, design, development, and execution of complex custom reports ensuring consistency and applicability to achieve established strategic objectives and goals.
  
• Serves as a lead technologist on all facets of projects and/or pilots (develop Work Plan, monitor, schedule, etc.) working collaboratively with analyst on design, business requirements, make recommendations to enhance performance and usability, and ensure timely and successful completion.
  
• Write and/or provide input for requirements, tools, framework, and mechanisms for data analytics working closely with Analyst and End User ensuring successful integration between Business Intelligence environment and business requirements.
  
• Participate in planning and oversee full aspects of development, testing activities, maintenance, and deployment of custom reports using various business intelligence software tools, investigate and recommend new technology platforms, and ensure are in compliance with data stewardship and data governance activities.
  
• Analyze performance for process improvement of existing systems and standards, assist in the maintenance ensuring deliverables meet development and security standards, and research new technologies that may add value across the division. Develop and/or review test plans, monitor testing activities, ensure results are adequately tested and validated, and create system documentation.
  
• Design and deliver end-user training and/or associated materials to technical and non-technical audiences. Attend, participate in, and may lead meetings. May participate in the development of short and long-term planning for appropriate information technology infrastructure, applications, and related systems. May temporarily lead a team when necessary.
  
• Other duties as assigned, as related to the position.

Knowledge of:

• Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.
  
• Engineering workflow, IT lifecycle, and system design, performance tuning, and Business Intelligence tools.
  
• Statistical and business analysis, research, and analytical processes and methodologies.
  
• Multiple Business Intelligence software applications (SQL, Tableau, Visual Basic, SSRS, SPSS, etc.) and multidimensional and relational database design.
  
• Project management concepts, principles, and practices.
  
• English language for sentence structure, composition, content, spelling, and grammar.

Skill in:

• Multidimensional and relational data modeling and database design.
  
• Problem-solving and negotiation skills to resolve complex issues.
  
• Excellent time management and organizational skills with attention to detail.
  
• Excellent listening, verbal, and written communication skills to write and communicate complex, conceptual, and technical and non-technical concepts to a variety of audiences.
  
• Working skills and use of Business Intelligence (BI) software (SQL, SPSS, SSIS, SSRS, Tableau, Visual Basic, MS Access, etc.)
  
• Analysis, design review, troubleshooting, implementation, and integration for applications.
  
• Proficient in the manipulation of reports and analysis of enterprise data.

Ability to:

• Write requirements, diagram business processes and workflows, entity relationships, translate into technical solutions and reports, develop and execute queries and view objects, and present in a meaningful format.
  
• Work at least 40 hours per week and maintain satisfactory attendance and punctuality standards.
  
• Work independently or collaboratively and under stress/pressure interact with all levels of personnel in a professional manner.
  
• Analyze data, develop and execute queries and reports, and proficiently manipulate data.
  
• Engage in critical thinking using logic and reasoning.
  
• Adapt to changing needs and priorities quickly while contributing feedback based on rules and regulations.
  
• Multi-task and make good decisions, balancing competing deadlines and priorities.

The ideal candidate for this position will have:

• A Bachelor’s Degree from an accredited college or university in Computer Science, Information Systems, Business Management or a closely related field, and 3 years of experience in a business intelligence or data analysis role.

• Employee shall obtain and maintain a valid Level One fingerprint clearance card that meets DES requirements for a Level One card pursuant to Arizona Revised Statute 41-1969.
  
• 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.
• Successfully pass background and reference check; employment is contingent upon completion of the above-mentioned process and the Agency’s ability to reasonably accommodate any restrictions.
  
• All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

The Arizona Department of Economic Security offers a comprehensive benefits package to include:

• Affordable medical, dental, life, and short-term disability insurance plans
• Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
• 10 paid holidays per year
• Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
• Sick time accrued at 3.70 hours bi-weekly
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities
• Flexible schedules to create a work/life balance

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 pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

State employees are required to participate in the Arizona State Retirement System (ASRS), the State sponsored retirement contribution plan and the Long-Term Disability (LTD) program after a 27-week waiting period. The ASRS defined benefit plan provides for life-long income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of tax-deferred retirement investments.

On, or shortly after, your first day of work you will be provided with additional information about the available insurance plans, enrollment instructions, submission deadlines and effective dates.

For questions regarding this career opportunity, please contact Alex Rivera at 480-910-0533 or AlejandroRivera@azdes.gov. 

The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation, such as a sign language interpreter or an alternative format, by contacting 480-910-0533 or AlejandroRivera@azdes.gov. Requests should be made as early as possible to allow time to arrange the accommodation.