Systems Developer - Cognos

Nys Ocfs•Room 323 North Rensselaer, NY

2d•Hybrid

About The Position

The Systems Developer will create and update client reporting functions to meet new federal client reporting requirements. Work includes updating system-generated reports in response to OSC audits, addressing reporting backlogs, refining caseload data reports for ongoing cases, adding client data to the Commissioners Dashboard, and developing reports for payees, referrals, case timeliness and completion, clients, performance using NAMRS data, and other LDSS requests. The role will also enhance reporting capabilities to support real-time report generation. The developer will collaborate with OREPA and client staff on business requirements and work with a Business Analyst on analysis and logical design. Responsibilities include complex SQL coding; IBM Cognos BI Framework Manager and Transformer modeling, package development, and security; advanced report development in IBM Cognos Analytics 12; testing across environments; knowledge transfer; troubleshooting and end-user support; and researching new product functionality for Human Services Cluster deliverables. This is a 24-month contract with a hybrid work model: 50% telecommuting and 50% in the office in Rensselaer, New York.

Requirements

Bachelor's degree.
84 months of experience using SQL for analysis and reporting, including conditional formatting and joining queries sourced from multiple tables or views.
84 months of experience testing reports and analytics, troubleshooting, problem solving, documenting, and presenting data challenges to stakeholders.
84 months of experience working in social services or related fields.
84 months of experience gathering business requirements, performing analysis and logical design, and translating issues through oral and written communication.
84 months of experience creating and modifying Framework Manager models.
84 months of experience creating and modifying reports using Cognos tools.

Responsibilities

Collaborate with OREPA and client staff and participate in business requirement gathering for business intelligence projects.
Work with a Business Analyst on analysis and logical design.
Perform complex SQL coding to support reporting and testing functions.
Model with IBM Cognos BI Framework Manager and Transformer, including developing all model layers and packages for mission-critical reporting initiatives.
Secure Framework Manager and Transformer models for data-level, object-level, and package access.
Create advanced reports using IBM Cognos Analytics 12, including multi-page reports with conditional formatting and joined queries that produce a single dataset.
Test reports, dashboards, and analytics in all environments before business owner review and approval.
Transfer knowledge to other Cognos users creating reports, in person and through electronic technologies.
Provide troubleshooting, end-user support, and problem resolution.
Research and develop solutions using new product functionality for Human Services Cluster business deliverables.
Update and develop client reports to meet federal reporting requirements, address audit findings and backlogs, refine caseload reporting, add data to the Commissioners Dashboard, and support real-time report generation.