Pima County · 1 week ago
ITSD - Business Intelligence Analyst III
Tucson, AZ
Full-time
Onsite
Mid, Senior Level
$85K/yr - $102K/yr
6+ years expPima County is seeking a Business Intelligence Analyst III to perform reporting duties using various reporting tools. The role involves requirements documentation, design, creation, testing, maintenance, and distribution of database reports and dashboard applications for court staff and programs.
GovernmentHealth CareRecyclingSustainabilityWaste Management
No H1B
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 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
Provides dashboard overview to judicial staff as required
Provides training and mentoring to other business intelligence analysts
Performs other related duties and projects as assigned
Qualification
Required
A bachelor's degree with a major in math, computer science, management information systems, or a related field
Six (6) years of work experience in database report generation
Expert knowledge with scripting languages and automated SQL Server jobs/agents
Expert knowledge with data migration methods and data warehousing concepts
Expert skills in Microsoft SQL
Expert skills in software reporting and business intelligence tools such as SSRS and Microsoft Power BI
Expert 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
Must have a valid Arizona Driver's License at time of appointment
Preferred
Expert level skills and work experience in Microsoft SQL
Microsoft Power BI
Microsoft SQL stored procedures
Microsoft SSRS
Work experience creating business data applications and scripts in Microsoft PowerApps
Company
Pima County
Pima County is a government sector that provides health, development, business, community, sustainability, wastewater & recycling services.
5001-10000 employees
Funding
Current Stage
Late StageTotal Funding
$0.49MKey Investors
U.S. Environmental Protection Agency
2023-10-23Grant· $0.49M
Recent News
Arizona Daily Star
2026-01-17
2025-09-19
Arizona Daily Star
2025-09-01
Company data provided by crunchbase