Senior Cognos BI Developer — Data Reporting & Modeling

Intellibee; City of Rensselaer (NY); Sur place; USD 90 000 - 130 000; Plein temps

Avantages offerts par ce poste

Long-Term Stability

Comprehensive Health Coverage

Future Planning: 401(k)

GC Assistance

Résumé du poste

IntelliBee is seeking an IBM Cognos BI Developer in Rensselaer, NY to support mission critical reporting initiatives. You will design, model, and secure Cognos frameworks and dashboards across environments.

Responsibilities include requirements gathering, SQL development, report creation, testing, and end-user training. This role emphasizes data integrity, security, and collaboration with business partners in Human Services clusters.

Qualifications

• 7+ years of experience in business requirement gathering, analysis and logical design.
• 7+ years of experience in creating and modifying Framework Manager models.
• 7+ years of experience in creating and modifying reports using Cognos tools.
• 7+ years of Experience using SQL for analysis and reporting including conditional formatting and joining queries from multiple tables or views.
• 7+ years of Experience testing reports and dashboards and presenting data challenges to stakeholders.
• 7+ years of Experience in social services or related fields.
• Bachelor’s Degree is required.

Responsabilités

• Collaborate with OREPA and APS staff to gather requirements for BI projects.
• Analyze with Business Analyst on logical design.
• Develop complex SQL queries to support reporting/testing.
• Model datasets with Cognos Framework Manager and Transformer.
• Secure models with data/object/package access controls.
• Create advanced Cognos reports using Cognos Analytics 12 with multi-page layouts.
• Test all reports/dashboards across environments before review.
• Transfer knowledge to Cognos users for self-service reporting.
• Provide troubleshooting and end-user support and problem resolution.
• Research new Cognos features to enhance Human Services reporting.

Connaissances

Requirements gathering

Analysis

Logical design

SQL for analysis

Cognos reports

Framework Manager

Transformer modeling

Testing reports

End user support

Data security controls

Formation

Bachelor's Degree

Outils

Cognos Analytics

Cognos Framework Manager

Cognos Transformer

Description du poste

IntelliBee is seeking an IBM Cognos BI Developer in Rensselaer, NY to support mission critical reporting initiatives. You will design, model, and secure Cognos frameworks and dashboards across environments.

Responsibilities include requirements gathering, SQL development, report creation, testing, and end-user training. This role emphasizes data integrity, security, and collaboration with business partners in Human Services clusters.