Business Intelligence Analyst Intermediate

Arizona Department of Administration•Phoenix, AZ

13h•Hybrid

About The Position

The Department of Economic Security (DES), Division of Benefits and Medical Eligibility, is hiring a Business Intelligence Analyst Intermediate for the Family Assistance Administration Systems team. Under minimal supervision, this position performs complex data analysis, data mining, design, development, testing, and execution of ad hoc and standard reports to support division objectives. The analyst contributes to projects and pilots by developing or providing input on requirements, advising on technical design and enhancements, and preparing work plans and schedules to support timely completion. The role manages the development and deployment lifecycle using business intelligence and database tools, and works with analysts and end users to ensure solutions integrate technical and business requirements. It also supports data stewardship, testing, documentation, process improvement, troubleshooting, performance tuning, and training for technical and non-technical audiences. The position is based in Phoenix, Arizona, and may offer remote work within Arizona depending on business needs and continued performance. Remote work is a management option and may be ended at the agency’s discretion. Employees must work at least 40 hours per week and meet attendance and punctuality standards.

Requirements

Knowledge of service level agreements; laws, rules, security policies, privacy, and data confidentiality management.
Basic knowledge of engineering workflow, IT lifecycle and system design, performance tuning, and business intelligence tools and features.
Knowledge of statistical and business analysis, research, and analytical processes and methodologies.
Knowledge of business intelligence applications such as SSIS, SQL, Tableau, Visual Basic, SSRS, SPSS, and MS Access, and of multidimensional and relational database design.
Knowledge of project management concepts, principles, and practices.
Knowledge of English sentence structure, composition, content, spelling, and grammar.
Skill in dimensional and relational database design.
Skill in analysis, design review, troubleshooting, implementation, and application integration.
Problem-solving and negotiation skills to resolve complex issues.
Time management, organization, attention to detail, and effective listening, oral communication, and written communication skills.
Ability to communicate technical and non-technical concepts to varied audiences.
Ability to write requirements, diagram business processes and workflows and entity relationships, translate them into technical solutions and reports, develop and execute queries and view objects, and present results meaningfully.
Ability to work at least 40 hours per week and maintain satisfactory attendance and punctuality.
Ability to work independently or collaboratively under stress or pressure, using critical thinking, logic, and reasoning.
Ability to interact professionally with personnel at all levels.
Ability to analyze and manipulate data and develop and execute queries and reports proficiently.
Ability to adapt quickly to changing needs and priorities, contribute feedback based on rules and regulations, multitask, and balance competing deadlines and priorities.
Obtain and maintain a valid Level One fingerprint clearance card meeting DES requirements.
Successfully pass background and reference checks; employment is contingent on completion of the process and the agency’s ability to reasonably accommodate restrictions.
Successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).
If driving or vehicle use is an essential job function, meet the stated driver’s license requirements.

Nice To Haves

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

Responsibilities

Design ad hoc and standard reports using Tableau, SSIS, or other technology solutions; write SQL and Run Book documentation as needed.
Record work-related activities in an operating system and store documents in the appropriate drive according to established processes and procedures.
Manage the development and deployment lifecycle using SSIS, SQL, Tableau, Visual Basic, MS Access, dimensional and relational database design, or other business intelligence tools.
Perform data analysis, data mining, report design and development, and execution of ad hoc and standard reports to support strategic objectives.
Serve on projects and pilots; develop work plans, schedules, and monitoring processes, and provide technical guidance to ensure alignment between business intelligence solutions and business requirements.
Write or contribute to requirements, frameworks, and mechanisms for data analytics, working with analysts and end users and recommending automation and maintenance approaches.
Participate in solution planning, development, testing, delivery, and data stewardship activities.
Develop or review test plans, assist with and monitor testing, validate integration and regression test results, identify anomalies, and create system documentation.
Analyze business needs to improve workflow processes; troubleshoot business intelligence tools and optimize performance and usability.
Design and deliver presentations, training, desk aids, and related materials for technical and non-technical audiences.
Attend and participate in meetings.
Perform other duties related to the position as assigned.

Benefits

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 of up to 12 weeks per year for a newborn or newly placed foster or adopted child.
Deferred compensation plan.
Wellness plans.
Tuition reimbursement.
Stipend opportunities.
Infant at Work Program.
Rideshare and public transit subsidy.
Career advancement and employee development opportunities.