Population Health - Impact Assessment Analyst Ii (5253 - Business Intelligence Analyst Ii)

REOPEN
Salary Grade: 15
Pay Range
Hiring Range: $66,536 - $79,843 Annually
Full Range: $66,536 - $93,150 Annually
Salary offers are based on the candidate's equivalent experience and internal equity with other employees within the same job classification.
This grant-funded position requires an individual who can conduct analysis on qualitative data collection and analysis for the department through the lens of Health Impact Assessments (HIA). HIA uses a combination of procedures, methods, and tools to systematically judge the potential-and sometimes unintended-effects of a proposed project, plan, or policy on the health of a population and the distribution of those effects within the population.
This role supports the data quality and infrastructure at Pima County Health Department which is used to inform public health decision-making both within the department and at the County Administration level. This position is responsible for assisting the health department with analysis that informs data to action activities that support the department across many divisions and project teams involving various health data themes. (Work assignments may vary depending on the department's needs and will be communicated to the applicant or incumbent by the supervisor.)
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.
KNOWLEDGE & SKILLS:
Knowledge of:

• software development and applications programming applicable to area of assignment;
• 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;
• effective teamwork behaviors.

Skill in:

• using Microsoft Excel (lookups, formulas, pivots, macros);
• writing SQL statements to analyze data: joining, filtering, aggregating;
• working within the Agile sprint methodology;
• written, verbal, interpersonal and management presentation communications;
• operating as an effective member of a team;
• writing procedures and work instructions;
• employing quality skill sets and diagnostic tools;
• problem solving and conflict resolution;
• understanding client applications and business requirements and concepts;
• employing diagnostic, analytical and conceptual skills with detailed orientation;
• gathering requirements, analyzing business problems, automating business processes and implementing application solutions;
• using BI tools such as SAP BO, Lumira, Tableau or Power BI;
• using reporting tools such as Crystal Reports, Web Intelligence or SSRS.

(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. Master's degree or higher from an accredited college, university, or technical trade school with a major in, computer science, computer engineering, or a related field.
2. Experience setting up structures to facilitate qualitative data collection and analysis.
3. Experience using project management techniques (SCRUM methodology) and implementing the workflow on a growing informatics and data team.
4. Experience in Population Health analysis.
5. Experience in translating complex legal language into data that can be used to evaluate how laws affect Population Health.

Selection Procedure:
Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum/desired qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum/desired 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.Licenses and Certificates: Valid driver license is required at time of application.Valid AZdriver 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.
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, 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 data base systems.
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.Employment Type: Full Time