HBITS-08-15097-Programmer-Expert

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

Job Description

Project/Program:

OREPA Data Warehouse/Programmer Expert.

The position will be responsible for the development and documentation of data warehouse reports and dashboards related to Child Welfare. Areas of focus include enhancement and continued support of Data Quality Dashboard to add requested data quality items and trends data visualization to help assess data quality improvement efforts; development of Casework Monitoring Dashboard for use by Local Department of Social Services (LDSS) and Voluntary Agency (VA) staff; standardization of common reporting metrics such as Race & Ethnicity and Age across the data warehouse environment (tables, reports, and dashboards); increasing data warehouse user engagement by updating and improving training materials and guides; and provide technical assistance to OCFS, LDSS, and VA data warehouse users through development and enhancement of data warehouse Cognos reports.

Day-to-day Tasks

• 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.

Mandatory Qualifications

Programmer–

Creates computer software. May specialize in one area of computer software or may write code for many kinds of software.

Expert

84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Requested 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.

We provide equal employment opportunity for all applicants and employees regardless of race, color, sex, gender identity, gender expression, religion, age, national origin, citizenship, disability, medical condition, family care status, marital status, domestic partner status, sexual orientation, genetic information, military/veteran status, or any other protected basis.