BUSINESS INTELLIGENCE ANALYST

Job Summary :

The Business Intelligence Analyst position involves designing, managing, and deploying data systems, reports, and dynamic dashboards, as well as training users in these systems and the use of reports.

The Business Intelligence Analyst will also present analytic findings. This position is responsible for extracting data from multiple sources, manipulating and validating

data, and conducting root cause analysis. The successful candidate should be comfortable performing the following : writing queries in SQL Management Studio, writing ETL’s in SSIS, developing analytical visualizations such as Tableau, Power BI, etc.

and managing data systems development / enhancements projects.

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 :

Acts as primary liaison between Information Technology department, Business Intelligence Team, and the Water Quality Division.

Supports the organizations key business processes and applications and recommends business process redesign where applicable.

Works with key stakeholders to identify reporting needs, defines the reporting requirements, designs the report, and writes the code required to deliver the report.

Queries multiple data sources using SQL, develops ETLs, and produces analysis / reporting using data analysis and visualization tools such as Tableau, R, Stata, Python, etc.

Analyzes data and provides insights and recommendations for organizational planning and operations.

Performs detailed quality control checks on significant and diverse data sets related to programs.

Demonstrate continuous effort to improve operations, streamline work processes, and work cooperatively with both internal and external customers.

Prepares and delivers informative, well-organized presentations

Knowledge, Skills & Abilities (KSAs) :

Knowledge of current computing technologies and software applications such as SQL query language, and other database applications appropriate to the position’s job responsibilities.

Knowledge of statistical and business analysis; business operations, methods, practices and workflow engineering.

Knowledge of or ability to learn and apply LEAN concepts, principles and tools used to create and deliver the most value from the customers perspective while consuming the fewest resources.

Skill in providing technical assistance to business partners; performing analytic functions including workflow and statistical analysis.

Ability to promote the use of business intelligence to make effective business decisions; communicate verbally and in writing;

to establish and maintain effective working relationships; collaborate with IT / BI and program staff to achieve shared goals.

Selective Preference(s) :

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

Experience with Business Intelligence and analytical applications such as Tableau, Power BI, SQL Server

Management Studio, Visual Studio.

Pre-Employment Requirements :

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 :

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits :

Among the many benefits of a career with the State of Arizona, there are :

• 10 paid holidays per year
• Accrual of sick and annual leave beginning at 12 and 13 days per year respectively for full-time employees
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster / adopted child (pilot program).
• A top-ranked retirement program with lifetime pension benefits
• A robust and affordable insurance plan to include medical, dental, life, short-term and long-term disability
• An incentivized commuter club and public transportation subsidy program
• We promote the importance of work / life balance by offering workplace flexibility
• We offer a variety of learning and career 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 pilot program . For a complete list of benefits provided by The State of Arizona, please visit our

Retirement :

ASRS Lifetime Benefits!