Business Intelligence Analyst II - Information Technology

Pima County; Arizona; On-site; USD 72,000 - 101,000; Full time

Job summary

Pima County Information Technology is seeking a passionate Business Intelligence Analyst II to translate business needs into actionable data solutions. You will design dashboards, reports, and data models to support multiple departments, bridging the gap between stakeholders and data across the county.

The role emphasizes gathering requirements, building BI solutions, and delivering data projects end-to-end, with a focus on improving decision-making and efficiency.

Qualifications

• Experience gathering and validating business requirements to drive BI solutions.
• Ability to translate business needs into data models, dashboards and reports.
• Strong collaboration with stakeholders across departments to define analytics needs.

Responsibilities

• Lead discovery sessions to elicit and document business, data and reporting requirements.
• Design, build, and maintain BI dashboards and analytics solutions.
• Manage small to mid-sized BI projects with scope, timelines and stakeholders.
• Coordinate with Analytics and Data Governance to meet county reporting needs.
• Train users on BI tools and data solutions.

Skills

Requirements gathering

Business analysis

Stakeholder collaboration

Data modeling

BI dashboard design

Project coordination

Tools

Power BI

Tableau

SQL

Job description

Job Description Summary

Department - Information Technology Job Description Job Type: Classified Job Classification: 5253 - Business Intelligence Analyst II Salary Grade: 15 Pay Range Hiring Range: $72,009 - $86,403 Annually Pay Range: $72,009 - $100,817 Annually Range Explanation: Hiring Range is an estimate of where you can receive an offer. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, education, licenses, training, and internal equity. Pay Range is the entire compensation range for the position Pima County Information Technology is seeking a passionate Business Intelligence Analyst II. As a member of our team, you'll help translate business needs into actionable data solutions that guide decisions and improve the efficiency and effectiveness of departments across Pima County. You'll play a key role in bridging the gap between stakeholders and data, ensuring that reporting and analytics solutions are well-scoped, well-built, and aligned with real business goals. In this role, you will lead efforts to gather and validate business requirements, design and build BI solutions, and manage the delivery of data projects projects from concept to completion. You will work closely with teams across various departments to understand business processes, define reporting and data needs, and translate those needs into dashboards, reports, and data solutions that drive better decision-making. This position is ideal for someone who is a self-starter, eager to problem solve and collaborate with others. If you have experience and a strong desire to help turn business needs into practical, data-driven solutions. We invite you to apply today and join us in building a more efficient, data-driven future for Pima County.

Essential Duties:

• Acts as a subject matter expert on requirements gathering and business analysis, providing recommendations for process improvements.
• Leads discovery sessions with internal and external stakeholders to elicit, document, and validate business, data and reporting requirements.
• Translates business requirements into functional specifications, data models, and BI solution designs.
• Designs, builds, and maintains dashboards, reports, and analytics solutions using business intelligence tools.
• Manages small to mid-sized data and analytics projects, including scoping, timelines, milestones, and stakeholder communication.
• Facilitates user acceptance testing and iterates on solutions based on stakeholder feedback.
• Documents processes, workflows, and solution designs to support ongoing maintenance and knowledge transfer.
• Researches issues and assists in their resolution.
• Train users on BI and data solutions.
• Identifies operation inefficiencies and help facilitates organizational change processes.
• This is an in-office position located in Tucson, AZ, and cannot be remote.
• The Information Technology Department is unable to provide visa sponsorship for this position.

Essential Functions:

• 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 business intelligence needs
• Interprets business requirements and determines data analysis solutions to meet department needs
• Designs analytics and custom reports that can potentially 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 that help analyze identified issues
• Provides direction for the planning, design, and execution of data analysis solutions
• Reviews test plans and monitors testing process to ensure that results meet the identified need
• Provides support to test teams and resolves issues identified by the test results
• Provides input to the development of quality metrics, standards, policies and procedures for the form, structure, and attributes of the Business Intelligence tools and systems
• Creates data quality tickets, as needed and ensures timely resolution
• Researches tools, software frameworks and mechanisms for data analytics, interfaces with vendors to keep abreast of new technologies
• Ensure the proposed business intelligence 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

Selection Procedure:

Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidate from a referral list provided by Human Resources. Additional assessments/testing may be required as part of the selection process.

Supplemental Information:

Licenses and Certificates:

Valid driver license is required at time of application. ValidAZdriver license is required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicant’s suitability to operate county vehicles in accordance with Pima County administrative procedures. Failure to obtain and maintain the required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services’ review and approval of the candidate’s driving record. Some positions require a valid Arizona Class D driver license at the time of application. Some positions must possess and maintain as a condition of employment the Terminal Operator for ACJIS certification. Failure to maintain the required licensure shall be grounds for termination. Some positions may require satisfactory completion of a personal background investigation, polygraph examination and/or pre-/post-appointment drug-testing by law enforcement agencies due to the need for access to law enforcement, corrections or court facilities, property and associated confidential and sensitive information, documents, communications and database systems.

Special Notice Items:

The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County. Some positions may require completion of a satisfactory personal background investigation by the court or law enforcement agencies, due to the need for access to County Attorney and Court facilities, records, and communication systems. Pima County determines whether a position is eligible for visa sponsorship at the time of recruitment. Eligibility is based on the requirements of