5399 - Business Intelligence Analyst I

Salary Grade: 13

Pay Range
Hiring Range: $57,607 - $69,128 Annually
Full Range: $57,607 - $80,649 Annually

Salary offers are based on the candidate's equivalent experience and internal equity with other employees within the same job classification.

(Work assignments may vary depending on the department's needs 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 assigned departments;

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

Works with internal and external customers and Analytics and Data Governance partners 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, workflow and automated tasks using structured query language and various database management tools;

May identify and analyze commonly used queries and reports to determine if currently available solutions are applicable;

Researches department reporting problems and assists in the creation of models to help analyze department 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 the collected data is within 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 the business intelligence solutions.

KNOWLEDGE & SKILLS:

Knowledge of:

• software development and applications programming;
• principles and techniques of systems analysis and design;
• development and maintenance of data communications, security, and privacy measures;
• principles of database design, data warehousing, data modeling, and data mining;
• reporting tools such as Crystal Reports, Web Intelligence, or SSRS;
• effective teamwork behaviors.

• working within the Agile sprint methodology;
• using Microsoft Excel (lookups, formulas, pivots, macros);
• writing SQL statements to analyze data: joining, filtering, 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;
• employing quality skill sets and diagnostic tools;
• problem-solving and resolution techniques;
• employing diagnostic, analytical, and conceptual skills with detailed orientation;
• gathering requirements, analyzing business problems, automating business processes, and implementing application solutions;
• visual design using SAP Lumira, Tableau, or Power BI.

A 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 appointing authority 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.):

1. Minimum two (2) years experience within the last five (5) years in C#, Java and Python.
2. Minimum two (2) years experience within the last five (5) years in Full Stack planning to completion, creating a new app, and working on the data layer/business logic/UI.
3. Minimum two (2) years experience within the last five (5) years in using Git and Jira.
4. Minimum two (2) years experience within the last five (5) years with a strong knowledge of Powershell scripting.
5. Minimum two (2) years experience within the last five (5) years with creating and managing automated deployment pipelines.
6. Minimum two (2) years experience within the last five (5) years in the Snowflake platform.
7. Minimum two (2) years experience within the last five (5) years with Reporting and Analytics tools such as Power BI or Qlik Sense.

Licenses and Certificates: Some positions require a valid Arizona Class D driver's license at the time of application. Failure to obtain/maintain 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.

Physical/Sensory Requirements: Physical and sensory abilities 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.