Overview
On Site
Depends on Experience
Contract - Independent
Contract - 30 Month(s)
Able to Provide Sponsorship
Skills
Criminal Justice
Cubes
Data Modeling
Database Design
Debugging
ERwin
Microsoft SSIS
Extract
Transform
Load
Microsoft Visual Studio
Relational Databases
Reporting
Management
Microsoft Excel
Stored Procedures
Supervision
Testing
Writing
Microsoft SQL Server
Microsoft SSRS
Oracle
SQL
Software Development Methodology
Albany
NY
USA
Job Details
Job Title: ON-SITE - SQL Developer W/ Criminal Justice exp
Job Id: HBITS-06-14019
Location: Albany, NY, 12210
Duration: Long-term
Job Description:
- 84 months of report development experience using Microsoft SQL Server Reporting Services (2014 or higher) and Microsoft Visual Studio (2014 or higher).
- 60 months experience designing and developing ETL processes using Microsoft SQL Server Integration Services (2014 or higher).
- 84 months experience creating Views, Triggers, stored procedures, functions, and writing SQL on one or more relational databases such as Oracle or SQL Server.
- 48 months experience with logical and physical data modelling and database design using Data Modelling Tools such as Erwin.
- 24 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).
_________________________________________________________
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 develop data cubes for use in report development. The person will follow agency software lifecycle methodologies, create design documents, perform coding/debugging/testing develop.
Max: SEVEN 32.800.2838
Kirtan:- SEVEN 32.800.2373
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.