BUSINESS INTELLIGENCE ANALYST INTERMEDIATE

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 View phone number on click.appcast.io or View email address on click.appcast.io. 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 View phone number on click.appcast.io or by email at View email address on click.appcast.io. Requests should be made as early as possible to allow time to arrange the accommodation. #J-18808-Ljbffr State of Arizona