Job Description
Systems Developer-Expert
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.
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.
Qualifications:
- 84 Months of Experience in business requirement gathering, analysis and
logical design; understanding and translating complex issues both in oral
and written communication
- 84 Months of Experience in creating and modifying Framework Manager
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 reports, analytics, troubleshooting, problem
solving, documenting and presenting complex data challenges to
stakeholders
- 84 Months of Experience working in social services or relating fields