BUSINESS INTELLIGENCE ANALYST INTERMEDIATE

State of Arizona; Phoenix (AZ); Remote; USD 66,000 - 121,000; Full time

Job summary

The Arizona Department of Economic Security is seeking a Business Intelligence Analyst Interm ediate to design reports, analyze data, and deliver BI solutions. The role involves collaborating with Analysts and end users to ensure BI aligns with business requirements and performance goals.

Remote work within Arizona may be available; candidates should be comfortable with 40-hour weeks, reporting, and data governance.

Qualifications

• Experience in designing Adhoc and standard BI reports using Tableau, SQL, SSIS.
• Familiarity with data analysis, data mining, and report deployment to meet business objectives.
• Ability to work on projects, develop work plans, and provide technical guidance.

Responsibilities

• Design Adhoc and Standard reports in Tableau, SSIS, or other BI tools.
• Manage life-cycle development and deployment using SSIS, SQL, Tableau, and related tools.
• Collaborate on projects to align BI with business requirements and timelines.
• Write requirements and framework for data analytics and automation.
• Plan, test, and deliver solutions with data stewardship and documentation.
• Develop and optimize workflows to improve BI performance.

Skills

SLA awareness

Engineering workflow knowledge

Data analysis

BI concepts

Project management concepts

English proficiency

Education

Bachelor's Degree in Computer Science/Information Systems or related field

Tools

SSIS

SQL

Tableau

Visual Basic

MS Access

SSRS

SPSS

Job description

DEPARTMENT OF ECONOMIC SECURITY

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.

BUSINESS INTELLIGENCE ANALYST INTERMEDIATE

Job Location

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

Posting Details

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

Job Summary

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.

Job Duties

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, Skills & Abilities (KSAs)

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 analytical processes and methodologies.
• Multiple Business Intelligence software applications (SSIS, SQL, Tableau, Visual Basic, SSRS, SPSS, MS Access, etc.) and multidimensional and relational database design.
• Project management concepts, principles, and practices.
• English language for sentence structure, composition, content, spelling, and grammar.

Skilled in:

• Dimensional and Relational database design.
• Analysis, design review, troubleshooting, implementation, and integration for applications.
• Problem-solving and negotiation skills to resolve complex issues.
• Good time management and organizational skills with attention to detail.
• Effective listening, oral and written communication skills to write and communicate technical and non-technical concepts to a variety of audiences.
• Use of Business Intelligence (BI software (SQL, SSIS, Tableau, Visual Basic, and MS Access)

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 while engaging in critical thinking using logic and reasoning.
• Interact with all levels of personnel in a professional manner.
• Analyze data, develop and execute queries and reports, and proficiently manipulate data.
• Adapt to changing needs and priorities quickly while contributing feedback based on rules and regulations.
• Multitask and make good decisions, balancing competing deadlines and priorities.

Selective Preference(s)

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 closely related field and 2 years of experience in a business intelligence or data analysis role.

Pre-Employment Requirements

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

Benefits

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
• Paid vacation and sick time
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child.
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities

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

Retirement

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.

Contact Us

For questions regarding this career opportunity, please contact Alex Rivera at 480-910-0533 or [e-mail].

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 Alex Rivera at 480-910-0533 or by email at [e-mail]. Requests should be made as early as possible to allow time to arrange the accommodation.