Job Description

Reference # : 20-01326Title : IT Specialist
Location : Albany, NY
Position Type : Contract
Experience Level : Start Date / End Date : 12/29/2020 / 06/29/2022

DPS NET Projects and Support

The Department of Public Services requires assistance with implementation of new and existing reports for .Net applications including but not limited to Pipeline Audit Safety (Client),Water Master (WMast), Document and Matter Management (DMM), Power To Choose (PTC), Regulatory Calculator and other systems.
The Department has identified a list of new initiatives and enhancements to improve the systems efficiency related to their business process which require a consultant's assistance.

Gather and validate of BI and reporting requirements
• Document requirements & solutions
• Perform Data profiling on the source systems
• Perform Source to Target Mapping between source system database and data warehouse target database
• Develop ETL transformations using the ETL tool SQL Server Integration Services (SSIS)
• Develop analytics and reports using SQL Server Reporting Services (SSRS)
• Develop complex queries using Transact-SQL leveraging analytic functions
• Perform necessary Testing
• Complete Documentation


Please see our complete list of jobs at:

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online