BUSINESS INTELLIGENCE ANALYST INTERMEDIATE

Arizona Department of Administration • Phoenix, AZ

2d • $32 - $58

About The Position

The Department of Economic Security’s Division of Benefits and Medical Eligibility is hiring a Business Intelligence Analyst Intermediate for the Family Assistance Administration Systems team. Under minimal supervision, the analyst performs complex work supporting the division through data analysis and mining, design, development, testing, and execution of ad hoc and standard reports. The position contributes to strategic objectives and serves on projects and pilots, providing input on requirements and technical guidance for system and report design or enhancements, while developing work plans and monitoring schedules and progress to support timely completion.

The position may offer remote work within Arizona, based on departmental business needs and continued performance. Remote work is a management option, not an employee entitlement, and work must be performed within Arizona unless an exception is authorized.

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 multiple business intelligence applications, including SSIS, SQL, Tableau, Visual Basic, SSRS, SPSS, and MS Access, as well as 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; application analysis, design review, troubleshooting, implementation, and integration; problem-solving and negotiation; time management, organization, and attention to detail; and written and oral communication with technical and non-technical audiences.
• Ability to write requirements; diagram business processes, 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 meet satisfactory attendance and punctuality standards.
• 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.
• Ability to adapt quickly to changing needs and priorities and provide feedback based on rules and regulations.
• Ability to multitask and make sound decisions while balancing competing deadlines and priorities.
• Obtain and maintain a valid Level One fingerprint clearance card that meets DES requirements under Arizona Revised Statute 41-1969.
• Successfully pass background and reference checks; employment is contingent on completing the process and the agency’s ability to reasonably accommodate restrictions.
• Successfully complete the Electronic Employment Eligibility Verification Program (E-Verify), as required of newly hired State employees.

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 when needed, and record work activities and documents according to system procedures.
• Manage the development life cycle and deployment 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, development, and execution, ensuring consistency and relevance to strategic objectives.
• Participate in projects and pilots; develop work plans, monitor and schedule work, and provide technical guidance to support integration of business intelligence solutions with business requirements and timely completion.
• 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 planning, development, testing, delivery of solutions, and data stewardship; develop or review test plans, assist with and monitor testing, validate results, identify anomalies through integration and regression testing, and create system documentation.
• Analyze and evaluate business needs, 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
• Arizona State Retirement System participation 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed