Systems Developer - IBM Cognos BI, Remote, , US

Intellibee; United States; Remote; USD 85,000 - 130,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

Future Planning

GC Assistance

Job summary

IntelliBee in Rensselaer, NY seeks an IBM Cognos BI Developer to design and deliver BI solutions for Human Services clusters. You will model data, build reports, and ensure secure access across environments.

You will collaborate with analysts, gather requirements, write complex SQL, and train users on Cognos tools. This full-time role requires a Bachelor’s degree and 84 months in BI development.

Qualifications

• 84 months of experience in business requirements gathering and analysis.

Responsibilities

• Collaborate with OREPA and APS staff for BI requirements.
• Analyze with Business Analyst on design.
• Develop complex SQL for reporting and testing.
• Model with Framework Manager and Transformer; develop packages.
• Secure models with data and access controls.
• Create advanced Cognos reports with multi-query datasets.
• Test reports and dashboards across environments.
• Transfer knowledge to Cognos users.
• Provide troubleshooting and end-user support.
• Research new Cognos features to integrate into Human Services deliverables.

Skills

Business requirements gathering

Analysis & design

SQL reporting

Testing reports

Troubleshooting

Stakeholder communication

Education

Bachelor's Degree

Tools

Cognos Framework Manager

Cognos Transformer

Cognos Analytics 12

Job description

IBM Cognos BI Developer, Rensselaer, NY, US

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.

Required Qualifications:

• 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 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 at IntelliBee

• Long-Term Stability: Join us on a 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: We support immediate Green Card processing, if required.