Business Intelligence Analyst II - RWRD

Pima County; Tucson (AZ); On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

A local government body in Tucson, Arizona is seeking a Business Intelligence Analyst II to assist in transforming data for visual analytics. Responsibilities include developing business intelligence solutions, interpreting data needs, and ensuring data quality. Ideal candidates have a relevant degree and significant experience in data analysis tools, with a strong focus on SQL and Power BI. This role demands collaboration across departments and an analytical mindset.

Qualifications

• 5+ years of business analysis or related technical experience required.
• 2+ years in BI Analyst I or similar role with Pima County is acceptable.
• Experience in data modeling and predictive analytics is preferred.

Responsibilities

• Provide analytical support for the development of business intelligence solutions.
• Design analytics and custom reports usable across departments.
• Assist in the transformation of critical data into visualizations.

Skills

Data analysis tools

SQL

Power BI

Tableau

Python

Education

Bachelor’s degree in computer science or related field

Tools

Power Query

Qlik

Job description

Join to apply for the Business Intelligence Analyst II - RWRD role at Pima County

Join to apply for the Business Intelligence Analyst II - RWRD role at Pima County

Overview

Pima County Regional Wastewater Reclamation Department (RWRD) is seeking a Business Intelligence Analyst II to assist in the transformation of critical data into data visualizations for tracking Key Performance Indicators (KPIs). The role is responsible for gathering, calculating, analyzing, and interpreting data, and working with personnel to provide information for improved operational efficiencies. The position involves working with business units to analyze, document, and design solutions for data analysis, interpretation, and reporting. The BI Analyst II ensures data is accurate, congruent, and reliable, and readily available for analysis or integration.

Responsibilities

• Provides analytical support for the development of business intelligence solutions.
• Works on complex, cross-functional business intelligence solutions affecting one or more departments.
• Participates in multiple projects as team member, can act as the team lead when needed.
• Works with internal and external customers and Analytics and Data Governance partners to develop and analyze BI needs.
• Interprets business requirements and determines data analysis solutions to meet department needs.
• Designs analytics and custom reports that can be used in multiple departments throughout the County.
• Performs analysis for a wide range of requests using data from various platforms.
• Researches business problems and creates data models to analyze identified issues.
• Provides direction for planning, design, and execution of data analysis solutions.
• Reviews test plans and monitors testing process to ensure results meet identified needs; provides support to test teams and resolves issues.
• Provides input to the development of quality metrics, standards, policies, and procedures for BI tools and systems.
• Creates data quality tickets and ensures timely resolution.
• Researches tools and mechanisms for data analytics; interfaces with vendors to stay current on technologies.
• Ensures BI solutions adhere to current County standards.
• Designs and delivers end-user training and training materials.
• Provides guidance, training, and problem-solving assistance to other team members.

Minimum Qualifications

Bachelor’s degree in computer science, computer engineering, management information systems (MIS), or a closely related field, and five years of business analysis or related technical experience, or two years with Pima County in BI Analyst I or similar role. Relevant education/experience may be substituted. Qualifying education and experience must be documented in the Education and Work Experience sections of the application.

Preferred Qualifications

• Minimum three (3) years of experience understanding and analyzing a wide variety of industry data systems related to financial systems, asset management, utilities, laboratory information systems, or SCADA systems.
• Minimum two (2) years of experience using data analysis tools, software, and languages including SQL, Power BI, Tableau, Qlik, Python, DAX, and Power Query.
• Minimum two (2) years of experience in an analytics/analyst role.
• Minimum one (1) year of experience in data modeling, predictive analytics, statistical methods, and data transformation.

Selection Procedure

Pima County HR reserves the right to admit only candidates who meet the minimum qualifications. Applications will be evaluated based on listed education and experience. Candidates meeting minimum qualifications may be evaluated against preferred qualifications. The hiring authority will interview and select from a referral list; additional assessments may be required.

Supplemental Information

Licenses and Certificates: Valid driver license is required at time of application. AZ driver license required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review. Failure to obtain/maintain required licenses and certifications may be grounds for termination. Any offer is contingent upon Fleet Services’ review/approval of driving record.

Special Notice Items: Pre-employment background checks; post-offer, pre-employment screening including verification of work history, education, and criminal history. A prior criminal conviction will not automatically disqualify a candidate.

EEO Information: Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.