Business Intelligence Analyst - Phoenix, United States - State of Arizona

State of Arizona

Verified Company

Phoenix, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

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

Job Location:
Division of Aging and Adult Services (DAAS)
Address: 1789 W. Jefferson, Phoenix, AZ 85007

Posting Details:

Salary:
$59,987- $75,504 Annually

Grade: 24

Closing Date:
Open Until Filled

Job Summary:

The Department of Aging and Adult Services (DAAS) is looking for a highly motivated individual to join our team as a Business Intelligence Analyst.

This position conducts data extraction, interpretation, and presentation for reports and special projects from multiple databases. The position will develop and maintain a Business Intelligence reporting infrastructure utilizing analytics packages (i.e., Tableau and SQL).

The development of the infrastructure will be done in collaboration with the Division of Technology Services and DAAS Business Analysts.

The position is responsible for interfacing with leadership, supervisors and management to facilitate the collection of data, define requirements and drive the development of reporting infrastructure, and development of final analysis and dashboards which may result in participating in the establishment of guidelines and policies.

This position is available for remote work on a full-time basis within Arizona (including virtual office arrangements).

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:

Develop, update, and maintain Tableau reporting infrastructure utilizing custom SQL resulting in clear and meaningful reporting of data.
Plan, organize and prioritize business analysis project deliverables from inception to completion in collaboration with business stakeholders.
Responsible for requirements gathering for business questions of staff and management and develop those technical needs into meaningful reports which enable data driven decision making and may result in participating in the establishment of guidelines and policies.
Interface with other team members to analyze and design methodologies for complex data extraction from a variety of data sources and assist other team members in crosstraining, quality control and reporting methodologies.
Troubleshooting issues and resolve any bugs which emerge in the Tableau reporting environment.
Verifies data collected is within required quality standards (QA)
Researches tools, framework,mechanisms for data analytics

Knowledge, Skills & Abilities (KSAs):

Knowledge in:

Business intelligence concepts, practices and procedures
Data visualization software (e.g., Tableau, Power BI, Looker etc.)
Techniques and methodologies for data analysis and design, requirements gathering, quality assurance and report development

Principles and practices of data pulls from a data warehouse/database

Skills in:

Intermediate/Advanced data manipulation from a SQL based database/warehouse/lake and Working on moderately to highly complex BI/data analytic solutions
Dashboard/Report Development with Data Visualization tools
Establishing and maintaining interpersonal relationships with internal stakeholders

Providing formal and informal instruction and technical support to end users

Ability to:

Gather, read, interpret, and present data for various reports, end users' needs and management requests
Develop functional and technical specifications for Business Intelligence reports through interfacing with staff
Analyze complex data and identify trends in relation to data queries, Compile clear, concise, and accurate reports, and spot inefficiencies and propose solutions
Provide and maintain technical support to end users of the database

Selective Preference(s):

Prefer a Bachelor's degree in Computer Science, Business Admin, Statistics, Math, Economics, Data Analytics, Data Science, Finance, Physics, or a related field; OR
3+ months work experience using Tableau or similar visualization tools, and SQL or other SQL based platforms like Snowflake/Azure etc; OR
Completion of an Industry Accepted Certificate Program or Bootcamp. If applicable, list work other schedule info written differently from the standard note below, (e.g. Flexibility in willingness to work longer shift hours or afterhours coverage, if necessary.)

Pre-Employmen