Cognos Developer

This resource is critical to continue creating business requirements for Child Welfare in New York State. This is necessary for the continued support of Local Districts of Social Services (LDSSs) and Federal Reporting. Reporting include AFCARS NCANDS CFSR and Casework Contacts Federal Reporting where gaps carry substantial penalties.

Responsibilities:

• Write SQL scripts to extract and analyze child welfare data to assist
• creating requirements
• Elicit and collect necessary information and create business requirements documents
• Data extraction and programming to investigate issues associated with reporting
• Write and maintain COGNOS reports

Required Skills:

• Experience in business requirement gathering analysis and logical design; understanding and translating complex issues both in oral and written communication.
• Experience in creating and modifying Framework Manager models
• Experience in creating and modifying reports using COGNOS tools
• Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries
• Experience testing reports analytics troubleshooting problem solving documenting and presenting complex data challenges to stakeholders
• Experience working in social services or relating fields