Overview
Skills
Job Details
-
84 months of report development experience using Microsoft SQL Server (2008/2014/2016) stored procedures, Microsoft Reporting Services and Microsoft Visual Studio.
-
84 months experience writing SQL on one or more relational databases such as Oracle or SQL Server
-
60 months experience with SQL Error Handling, SQL Views, SQL Triggers, SQL Stored Procedures and Functions
-
36 months experience developing analytical cubes and multidimensional structures using SQL Server Analysis Services (SSAS).
-
36 months experience with logical and physical data modelling, and database design using Data Modelling Tools such as Erwin.
-
36 months experience planning, designing and implementing reports related to criminal justice processing (including but not limited to: criminal justice statistical reporting, disposition processing, fingerprint identification processing, criminal history inquiry, Sex Offender Management, tracking of Wanted/Missing persons, or initiatives related to offender supervision).
-
60 months experience using SSIS Package configurations.
_________________________________________________________
Agency: Information Technology Services (ITS)
Detailed Job Description: This position will support the Public Safety Portfolio in the development and maintenance of business solutions on the SQL Server platform using SSRS and advanced excel reporting techniques. The person will be expected to develop data cubes for use in report development. The person will be expected to follow agency software lifecycle methodologies, create design documents, perform coding/debugging/testing develop.