ITSD – Business Intelligence Analyst II

Pima Sheriff; Tucson, Northern (AZ, KY); Hybrid; USD 72,000 - 79,000; Full time

Benefits offered by this job

Retirement Plan

Health Insurance

Paid Vacation

Paid Holidays

Tuition Reimbursement

Short-term Disability

Wellness Program

Job summary

Pima County Superior Court in Tucson, AZ seeks a BI Developer to create and maintain complex reports and dashboards for court staff and programs. You will handle data extracts, analyses, and validation, using SSRS, Power BI, and SQL scripts.

The role emphasizes data management, reporting accuracy, and collaboration with stakeholders to meet evolving data needs. On-site position with a strong focus on government BI solutions.

Qualifications

• Bachelor’s degree with a major in math, computer science, MIS, or a related field, and five years of work experience in database report generation.
• Equivalent combination of experience and/or education approved by Human Resources.

Responsibilities

• Prepares reports, data extracts, and dashboard applications with a high degree of complexity using various reporting technologies like Microsoft SSRS, SQL queries, and Microsoft Power BI.
• Conducts analysis of business procedures and processes to determine current and future data needs.
• Documents report requirements captured during analysis sessions with stakeholders.
• Performs all end-to-end duties in support of report specification, design, creation, maintenance, and deployment.
• Provides expertise in modern business intelligence dashboards with advanced visuals.
• Conducts functional testing and data validation for reports, ad-hoc data extracts, dashboards, and other applications.
• Collaborates with end users to identify data needs and reporting solutions.
• Evaluates stored procedures and applies SQL changes to increase efficiency, accuracy, and performance.
• Troubleshoots SQL code to resolve data/formatting issues.

Skills

Microsoft SQL

Power BI

SQL stored procedures

SSRS

PowerApps

Education

Bachelor’s degree in math, computer science, MIS or related field

Tools

Microsoft SSRS

Microsoft SQL Server

Job description

Job Description

Job Description Summary Performs reporting duties using various reporting tools, duties include requirements documentation, design, creation, testing, maintenance, and distribution of database reports and dashboard applications for court staff and programs. Provides support in the areas of data management, report generation, data extracts, basic statistical analysis, dashboard development, and data relationships. Executes functional testing for new or modified reports, dashboards, and a variety of business applications. This is a classified position that reports to the Manager, Business Systems Analysis, Application Development & Reporting. The incumbent performs duties under general supervision and has no supervisory responsibilities. Job Description Hiring Rate: $72,010- $78,541 Annually This is an on-site position located at 240 N. Stone Ave, Tucson, AZ 85701 and no relocation assistance will be provided.

Please be aware that selected candidates for this position must be authorized to work in the United States and will need to provide documentation of eligibility on the first day of employment. The court does not provide any type of visa sponsorship. All candidates are required to pass a background check in accordance with Superior Court policy. Any applicant who does not meet background‑check requirements will be disqualified from further consideration.

Minimum Qualifications

• A Bachelor’s degree with a major in math, computer science, management information systems, or a related field, and five years of work experience in database report generation; OR, any equivalent combination of experience and/or education approved by Human Resources.

Preferred Qualifications

• Advanced level skills and work experience in Microsoft SQL, Microsoft Power BI, Microsoft SQL stored procedures, and Microsoft SSRS.
• Work experience creating business data applications and scripts in Microsoft PowerApps.

Essential Duties

• Prepares reports, data extracts, and dashboard applications with a high degree of complexity using various reporting technologies like Microsoft SSRS, SQL queries, and Microsoft Power BI.
• Conducts analysis of business procedures and processes to determine current and future data needs.
• Documents report requirements captured during analysis sessions with stakeholders.
• Performs all end-to-end duties in support of report specification, design, creation, maintenance, and deployment.
• Provides specific expertise and guidance in the creation of modern business intelligence dashboards that utilize conditional formatting, drill downs, slicers, sub-reports, advanced filtering, cross tabs, tiles, and modern graphic visualization objects.
• Conducts functional testing and data validation activities supporting modified and/or new reports, ad-hoc data extracts, dashboards, and other business applications.
• Collaborates with end users such as directors, managers, project managers, outside agencies, and database administrators to identify data needs and reporting solutions.
• Evaluates stored procedures and applies SQL changes to increase efficiency, accuracy, and performance.
• Troubleshoots SQL code to resolve data and/or formatting issues reported by stakeholders.
• Researches any number of complex technical issues, for example database connectivity issues, configuration issues with environments, code problems within stored procedures/SQL, and software/OS version compatibility issues.
• Provides expertise in case management systems that leverages an understanding of data relationships and business practices to produce complex reports.

Additional Responsibilities/Duties

• Provides dashboard overview to judicial staff as required.
• Performs other related duties and projects as assigned.

Knowledge of

• Knowledge with scripting languages and automated SQL Server jobs/agents.
• Knowledge with data migration methods and data warehousing concepts.
• Advanced skills in Microsoft SQL.
• Advanced skills in software reporting and business intelligence tools such as SSRS and Microsoft Power BI.
• Advanced skills consolidating complex data relationships located within files, multiple tables/views, and multiple databases into user-friendly reports and dashboards.
• Current skills in Microsoft Visual Studio and applying SQL logic within stored database procedures.
• Strong writing and presentation skills.
• Ability to communicate effectively with a wide variety of employees including judicial and administrative personnel, IT management, and colleagues.
• Ability to take initiative and meet deadlines in a fast-paced environment.
• Ability to effectively solve technical problems using modern web-based research techniques.

Licenses and Certificates

• Must have a valid Arizona Driver's License at time of appointment.

Physical/Sensory Items

Typically performs duties in a court environment and may lift materials and/or equipment 20 lbs or less. Occasional after hours and weekend hours are required to support system implementations and deployments.

Benefits

We offer exceptional benefits: Retirement Plan Vacation, holidays, and sick leave 100% paid parental leave Employer-paid Short -term Disability Tuition Reimbursement Health Wellness discount program Mental and Behavioral Health Benefits Paid Training with Advancement Opportunities The Arizona Superior Court in Pima County and the Pima County Juvenile Court Center offer the same benefits as those offered to other employees working for Pima County.

We offer a competitive benefits package to benefits eligible employees, which includes medical, dental, life insurance, flexible spending accounts, paid vacation and sick leave.

Some benefits require contributions by employees in addition to contributions made by the employer.

Please see the link below for a complete description of the offerings.

Pima County Benefits Retirement Plan participation is mandatory for all eligible employees to include a mandatory pre-tax pay deduction.

Current rates can be viewed here: ASRS Contribution Rates Full-time employees of government organizations may be able to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

For more information click Student Loan Forgiveness | Federal Student Aid.

Equal Employment Opportunity (EEO) Statement

The Superior Court provides equal employment opportunities to all employees and applicants in accordance with applicable federal, state, and local laws. Employment decisions are made without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, disability, genetic information, veteran status, or any other protected characteristic under law.

Pima County stands out as an exceptional workplace, offering a supportive environment that fosters professional growth and personal satisfaction. As one of the largest employers in the region, Pima County prioritizes its commitment to creating a diverse and inclusive workplace, recognizing the unique contributions of each employee. Embracing innovation and collaboration, Pima County provides multiple opportunities in which individuals can make a meaningful impact on their community. One of the key advantages of working for Pima County is its comprehensive benefits package. Employees enjoy competitive salaries, generous health insurance coverage, and retirement plans that contribute to long-term financial security. Pima County recognizes the importance of a healthy work-life balance, offering flexible work schedules, a generous family leave policy and wellness programs that prioritize employee well-being. Furthermore, Pima County takes pride in fostering a culture of continuous learning and development. Employees benefit from opportunities for professional advancement through training programs, workshops, and educational reimbursement programs. In addition, a County-wide employee recognition program rewards employees who exemplify the County values of being accountable, respectful and ethical as well as providing great customer service. By joining Pima County, individuals become part of a dedicated team working towards a common goal: enhancing the quality of life for residents and building a vibrant future. Pima County is not just an employer; it's a community that values its employees, encourages their growth, and invests in their success.