> Markdown version of [/jobs/ext/3805158-systems-developer-ibm-cognos-bi](https://www.wearedevelopers.com/jobs/ext/3805158-systems-developer-ibm-cognos-bi). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Systems Developer - IBM Cognos BI

- **Company:** Cays Inc
- **Location:** Rensselaer, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Data Presentation, IBM Cognos Business Intelligence, Package Development Process, Standard Sql, SQL Databases, Transformer Architectures, Conditional Formatting
- **Published:** October 17, 2026
- **Apply:** https://www.careerjet.com/jobad/us38d0ef4eeacc2bf75d644d9eeeb4cfe7

## About the Role

* 84 Months of Experience in business requirement gathering, analysis and logical design; translating 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 queries sourced from multiple tables or views
 * 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting data challenges to stakeholders
 * 84 Months of Experience working in social services or related fields
 * Bachelor's Degree

## Description

Daily tasks include, but are not limited to:

 * Work collaboratively with OREPA and APS staff 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 12, 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.