IBM Cognos BI Developer

Location: Rensselaer, NY, US | Posted: 19-Oct-2026

Responsibilities

• 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

Requirements

• 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

Benefits

• Long-Term Stability: Multi-year opportunities with room to grow
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well
• Future Planning: Enroll in our 401(k) program and invest in your financial security
• GC Assistance: Support for immediate Green Card processing, if required