Senior Cognos BI Engineer: Data Warehouse & Dashboards

Knowledge Builders Inc; City of Rensselaer (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Knowledge Builders Inc. seeks a Programmer–Expert for the OREPA Data Warehouse project to develop and document Cognos reports and dashboards related to Child Welfare, enhance data quality dashboards, and standardize metrics across the warehouse environment.

The role requires extensive Cognos experience, SQL proficiency, and a Bachelor’s degree, with collaboration across OCFS, LDSS, and VA teams to deliver secure, scalable BI solutions.

Qualifications

• 84 Months of Experience in business requirement gathering, analysis and logical design; understanding and 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 complex data challenges to stakeholders.
• 84 Months of Experience working in social services or related fields.
• Bachelor’s Degree.

Responsibilities

• Work collaboratively with OREPA 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 and dashboards 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.

Skills

SQL

Data quality

Business requirement gathering

Reporting design

Education

Bachelor’s Degree

Tools

Framework Manager

Transformer

Cognos Analytics 12

Job description

Knowledge Builders Inc. seeks a Programmer–Expert for the OREPA Data Warehouse project to develop and document Cognos reports and dashboards related to Child Welfare, enhance data quality dashboards, and standardize metrics across the warehouse environment.

The role requires extensive Cognos experience, SQL proficiency, and a Bachelor’s degree, with collaboration across OCFS, LDSS, and VA teams to deliver secure, scalable BI solutions.