Job Description Summary

Department - Information Technology

Job Description

Job Type: Classified

Job Classification: 5399 - Business Intelligence Analyst I

Salary Grade: 13

Pay Range

Hiring Range: $60,507 - $72,612 Annually 

Pay Range: $60,507 - $84,718 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.

The Pima County Information Technology Department is seeking an entry-level Business Intelligence Analyst I who will work closely with business units to analyze, document, and design solutions for data analysis, interpretation, and reporting. This role involves providing data that is accurate, congruent, and reliable, ensuring that the information is easily accessible to user departments for analysis or integration with other systems.

The successful candidate will have experience:

• Working within the Agile sprint methodology

• Using Microsoft Excel (including lookups, formulas, pivots, and macros)

• Writing SQL statements to analyze data, including joining, filtering, and aggregating

• Writing procedures and work instructions

• Communicating with internal and external customers through written, verbal, interpersonal, and management presentations

• Operating as an effective member of a team

• Problem-solving and resolution techniques

• Analytical and conceptual skills with a strong attention to detail

We offer an opportunity to apply and expand your skills, work in a supportive team environment, and advance your career. Bring your energy, enthusiasm, professionalism, and drive for continuous improvement and help make a difference in your community by supporting the mission of Pima County government.

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:

As defined under the Americans with Disabilities Act, this classification may include any of the following tasks, knowledge, skills, and other characteristics. This list is ILLUSTRATIVE ONLY and is not a comprehensive listing of all functions and tasks performed by incumbents of this class. Work assignments may vary depending on the department’s need and will be communicated to the applicant or incumbent by the supervisor.

• Acts as the subject matter expert on reporting tools and data analysis; makes recommendations on process changes;

• Provides data analysis and reporting solutions support for various departments;

• Works on data analysis tasks within one or more functional areas independently or as part of a team;

• Collaborates with internal and external stakeholders to gather and validate requirements;

• Develops and writes business requirements for identified data analysis and reporting solutions;

• Creates and maintains a variety of reports, data queries, scripts, workflows, and automated tasks using structured query language and various database management tools;

• Identifies and analyzes commonly used queries and reports to determine if currently available solutions are applicable;

• Researches reporting problems and assists in the creation of models to help analyze reporting needs;

• Develops, executes, and documents user test plans;

• Coordinates and performs quality control testing of new or updated software and processes; helps resolve issues based on test results;

• Verifies that collected data meets required quality standards;

• May maintain the quality of metadata repository/data dictionary by adding, modifying, and deleting data;

• Creates data quality tickets and ensures they are resolved in a timely manner;

• Assists in the development and presentation of end-user training materials;

• May train and assist clients in the use of business intelligence solutions.

Minimum Qualifications:
 

Bachelor's degree from an accredited college, university, or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the department head at the time of recruitment.

(Relevant experience and/or education from an accredited college, university, or technical trade school may be substituted.)
 

Qualifying education and experience must be clearly documented in the "Education" and "Work Experience" sections of the application. Do not substitute a resume for your application or write "see resume" on your application.

Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies, specifically addressing the required and preferred qualifications.):

• Minimum one (1) year of experience with/knowledge of SQL (writing SQL statements to query data).

• Minimum one (1) year of experience with/knowledge of Power BI, Tableau, and other analytic tools (writing reports, visualizations, or dashboards).

• Minimum one (1) year of experience with/knowledge of problem analysis (case studies or business process reviews).

• Minimum one (1) year of experience communicating with others to define business problems and solutions.

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. Valid AZ driver 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 or appointment. Failure to maintain the required licensure shall be grounds for termination.

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 satisfactory completion of a 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. Some positions may require satisfactory completion of a 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. Occasional after hours and weekend hours are required to support system implementations and deployments. The Information Technology Department is unable to provide visa sponsorship for this position.
 

Physical/Sensory Requirements: Physical and sensory abilities will be determined by position.

Working Conditions: Working conditions will be determined by position.

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.