Pima County
Business Intelligence Analyst I - Overdose Data Insights Analyst
Pima County, Tucson, Arizona, United States, 85718
Overview
Pima County Health Department is seeking a
Business Intelligence Analyst I – Overdose Data Insights Analyst
to join our Public Health Informatics and Data Services team. This role supports overdose surveillance, reporting, and prevention by ensuring overdose‑related data is accurate and ready to drive action. The position involves integrating diverse data sources and maintaining data quality processes to transform raw information into meaningful insights for dashboards and reports. Essential Functions
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 SQL 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
Experience using Snowflake, SQL, R, Qlik, or ArcGIS for data integration, transformation, or quality monitoring. Advanced degree in Computer Science, Information Systems, Public Health Informatics, Data Engineering, or a closely related field. Experience developing and maintaining ETL workflows and supporting backend logic for dashboards or automated reporting systems. Experience creating and maintaining data dictionaries, metadata repositories, and data lineage documentation. Experience troubleshooting data quality issues and collaborating with IT or engineering teams to resolve integration challenges. Other Details
THIS IS A GRANT FUNDED POSITION ENDING AUGUST 2028. The first review of applications will be on 10/3/2025. 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. 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. 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. 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. Job Details
Job Type: Classified Salary Grade: 13 Pay Range: Hiring Range: $59,675 - $71,614 annually Pay Range: $59,675 - $83,553 annually Location: In-office, Tucson, AZ
#J-18808-Ljbffr
Pima County Health Department is seeking a
Business Intelligence Analyst I – Overdose Data Insights Analyst
to join our Public Health Informatics and Data Services team. This role supports overdose surveillance, reporting, and prevention by ensuring overdose‑related data is accurate and ready to drive action. The position involves integrating diverse data sources and maintaining data quality processes to transform raw information into meaningful insights for dashboards and reports. Essential Functions
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 SQL 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
Experience using Snowflake, SQL, R, Qlik, or ArcGIS for data integration, transformation, or quality monitoring. Advanced degree in Computer Science, Information Systems, Public Health Informatics, Data Engineering, or a closely related field. Experience developing and maintaining ETL workflows and supporting backend logic for dashboards or automated reporting systems. Experience creating and maintaining data dictionaries, metadata repositories, and data lineage documentation. Experience troubleshooting data quality issues and collaborating with IT or engineering teams to resolve integration challenges. Other Details
THIS IS A GRANT FUNDED POSITION ENDING AUGUST 2028. The first review of applications will be on 10/3/2025. 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. 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. 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. 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. Job Details
Job Type: Classified Salary Grade: 13 Pay Range: Hiring Range: $59,675 - $71,614 annually Pay Range: $59,675 - $83,553 annually Location: In-office, Tucson, AZ
#J-18808-Ljbffr