Job Description

Job Location: Available to work On-Site, Rensselaer, NY.

Note:   Experience (12+ Years), candidates from nearby states who are in 50 miles or 45-50 minutes' drive.

Job Description:

This resource will work on reporting, analysis and measurements for Juvenile Justice and Child Welfare in New York State. This includes needed development of data structures and extractions that are necessary for the continued support of Voluntary Agencies, Local Districts of Social Services (LDSSs) and Federal Reporting. Reporting areas may include (but are not limited to) prevention services, safety assessments, candidacy, permanency, education records, and finance.

Duties 

• 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.
• Develops and implements applications and programs for the backend processing systems used in businesses and organizations

Requirements

Skills Set:

Job Tags

Similar Jobs