IT Specialist Expert, Saratoga Springs

IT Specialist Expert– HYBRID - North Rensselaer, NY

Agency Name: Office of Children and Family Services Project/Program Name: OCFS Data Warehouse This resource will provide localized Cognos report administrative functions and be the primary resource for the development and maintenance of fiscal reports. This resource will also work on reporting, analysis and measurements for Child Welfare in New York State, as well as any ad hoc reporting as needed.Day-to-Day Tasks

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 financial reports as required by Federal and State initiatives Job Title: IT Specialist Skill Level: Expert Target Start Date: 2/14/2026 Engagement Length in Months: 24Is this a Full or Part-Time Position: Full-Time What are the daily work hours: 8am-5pm (negotiable) Where is the physical work office located: Office of Research, Evaluation and Performance Analytics (OREPA) New York State Office of Children and Family Services 52 Washington St., Room 323 North Rensselaer, NY 12144Is telecommuting allowed for this position: Yes If YES, note if negotiable or list the percentage allowed/number of days allowed per week: In-person for the first three months. Can request for up to 50% telecommuting after the first three months, pending satisfactory job performance / evaluation What is the format of the Candidate interview: WebcastingIf 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: Dell / Client Position Job Title: IT Specialist Position Job Title Description: Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.Position Skill Level: Expert Position Skill Level Description: 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. Requested Qualifications

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 with troubleshooting expertise 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 production84 Months Experience in social services-related reporting including troubleshooting for user support Bachelor's Degree Required Documentation

Résumé Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) Are there additional security requirements for the Authorized User: No Will additional training potentially be required during the Engagement: YesIf YES, provide description of anticipated training: Human Trafficking/Commercial Sexual Exploitation of Children: An Overview, Equal Employment Opportunity and Workplace Discrimination Prevention, Gender Identity in the Workplace, Information, Cyber Security, and Privacy Awareness Internal Controls, NYS Right to Know Law, Prevention of Workplace Violence, Other Trainings as Mandated by OERWhat type and/or manner, of knowledge transfer is requested during the Engagement: We will have weekly meetings with the resource and other OCFS team members to understand and get an update of progress to date on tasks assigned. Additionally, upon completion of assigned tasks we will have debriefing sessions to assist in knowledge transfer.Is travel anticipated during the Engagement: No