IT Specialist Expert

IT Specialist ExpertNYS Office of Children & Family Services (OCFS) is seeking an IT Specialist Expert. Tasks that this position will be handling during the period the position is being requested:Work collaboratively with OREPA and 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 11.2, 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.Requested Qualifications:84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication84 Months of Experience in creating and modifying Framework Manager models84 Months of Experience in creating and modifying reports using COGNOS tools84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting complex data challenges to stakeholders84 Months of Experience working in social services or related fieldsBachelor's DegreeWork hours and location:Full time role with engagement length of 24 monthsDaily work hours: 8am-5pm (negotiable)Physical office location: 52 Washington St., Room 323 North Rensselaer, NY 12144Telecommuting options: In-person for the first three months. Can request for up to 50% telecommuting after the first three months, pending satisfactory job performance / evaluationSpruce Technology, Inc. is a mid-size, award-winning technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing. Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. All full-time employees are eligible for the following benefits: Medical, dental, vision health benefits Life Insurance and AD&D (paid by company) 401k, Flexible and Dependent Care Spending Account plans. Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).