Business Intelligence Analyst II - Information Technology
Business Intelligence Analyst II - Information Technology
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 68931 - 82721
1 Vacancy
Job Description
Job Description Summary
Department - Information TechnologyJob Description
Job Type: Classified
Job Classification: 5253 - Business Intelligence Systems Analyst II
Salary Grade: 15
Pay Range
Hiring Range: $68931 - $82721 Annually
Pay Range: $68931 - $96512 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.
Works closely with business units to analyze document and design solutions for data analysis interpretation and reporting. Responsible for providing data that is accurate congruent and reliable ensures the information is easily available to user departments for analysis or integration with other systems. The Business Intelligence Analyst II is distinguished from the Business Intelligence Analyst I by its focus on in depth data solutions and lead responsibilities.
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 departments need 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.
Minimum Qualifications:
Bachelors 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 AND five years of business analysis or related technical experience.
OR:
Two years with Pima County within a Business Intelligence Analyst I position or similar level position 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 two (2) years experience writing SQL statements.
Minimum two (2) years experience query data in Snowflake.
Minimum one (1) year experience with Power BI.
Experience using (within the last 2 years) Tableau/Crystal.
Minimum two (2) years experience with Excel/Qlik Sense and/or other analytic tools (writing reports visualizations or dashboards).
Minimum two (2) years experience with problem analysis.
Minimum two (2) years experience with case studies or business process reviews.
Minimum two (2) years experience communicating with others and lead stakeholders in person over the phone and/or via email.
Minimum two (2) years experience defining and documenting business problems.
Minimum two (2) years experience defining and implementing reporting 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. 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 applicants 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 candidates 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. 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 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.
Physical/SensoryRequirements: 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.
Required Experience:
IC
Employment Type
Full-Time
