IT Specialist Expert Job at PSI INTERNATIONAL, Inc. in City of Rensselaer

Overview

IT Specialist Expert role at PSI INTERNATIONAL, Inc.

Position details

Location: Albany, NY

Engagement: 24 months

Target Start Date: 2/20/2024

Engagement length: 24 months

Office address: 52 Washington St., Room 323 North, Rensselaer, NY 12144

Telecommuting: Yes (40% after the first three months, pending performance)

Responsibilities

• Participate in business requirement gathering for BI projects.


• Work with Business Analyst on analysis and logical design.


• Perform complex SQL coding to facilitate reporting and testing functions.


• Modeling using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development.


• Securing the Framework Manager and Transformer models for data level, object level and package access security.


• Create advanced reports using IBM Cognos Analytics, which include but are not limited to several pages with conditional formatting and joining multiple queries to produce a single dataset for the requested report.


• Complete testing of all reports, dashboards, and analytics in all environments prior to business owner review/approval.


• Transfer knowledge to other Cognos users creating their own reports in person and using electronic technologies.


• Provide troubleshooting and end user support and problem resolution.


• Research and develop solutions utilizing new product functionality to integrate into Human Services Cluster business deliverables.


• Support rewriting of claims reports required by changes caused by federal Family First initiative.

Qualifications

• Position Title: IT Specialist


• Position Skill Level: Expert


• 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.


• 84 Months of Experience in working collaboratively on business requirement gathering, analysis and logical design


• 84 Months of Experience in Creating and modifying Framework Manager & Transformer models


• 84 Months of Experience in Creating and modifying reports using COGNOS tools


• 84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries


• 84 Months of Experience testing all reports and analytics prior to moving to production


• 84 Months Experience in social service-related reporting including trouble shooting for user support


• Bachelor's Degree

Additional Information

• Are there additional security requirements for the Authorized User? No


• Will additional training potentially be required during the Engagement? No


• What type and/or manner, of knowledge transfer is requested during the Engagement? Weekly meetings with the resource and OCFS team members to understand progress; debriefings upon task completion for knowledge transfer.


• Is travel anticipated during the Engagement? No


• What is the format of the Candidate interview? Webcasting; if Webcasting, is Candidate required to be on camera? Yes


• What type of software is typically used by the Agency? Microsoft


• What type of hardware is typically used by the Agency? Microsoft

Job function

• Information Technology

Industries

• Government Administration