layiq

/la·yiq/adjective

worthy; deserving; fitting; suitable.

A role, opportunity, or path that merits attention, time, and pursuit.

ITSD – Business Intelligence Analyst II at Pima County | LAYIQ

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.

ITSD – Business Intelligence Analyst II

Employer job description

Minimum Qualifications:

Preferred Qualifications:

Knowledge of:

Must have:

Licenses and Certificates:

Physical/Sensory Items:

Benefits:

About this listing