Back to search

Programmer

Develop and document data warehouse reports and dashboards for Child Welfare, including SQL coding, IBM Cognos BI modeling, and user support.

  • Rensselaer, New York, United States
  • Contract
  • Hybrid
  • Posted Nov 9, 2026
INDUSTRYSoftware & InternetData & Analytics

Responsibilities

  • Collaborate with OREPA and Business Analyst for BI projects
  • Gather business requirements
  • Perform complex SQL coding for reporting
  • Model using IBM Cognos BI Framework Manager and Transformer
  • Secure Framework Manager and Transformer models
  • Create advanced reports and dashboards with Cognos Analytics
  • Test reports and dashboards
  • Transfer knowledge to other Cognos users
  • Provide troubleshooting and end user support
  • Research and develop solutions with new product functionality

Skills

SQLIBM Cognos BI Framework ManagerIBM Cognos BI TransformerIBM Cognos Analyticsdata warehousereportingdashboardsIBM Cognos BI Framework ManagerIBM Cognos BI TransformerIBM Cognos Analytics

More jobs nearby

Full description

HBITS: HBITS-08-15097 Expert, Programmer 24 month contract Interview: Virtual Interview Work model: 50% telecommuting, 50% Office per week --- Project Description --- 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 --- 1. Work collaboratively with OREPA and participate in business requirement gathering for BI projects. 2. Work with Business Analyst on analysis and logical design. 3. Perform complex SQL coding to facilitate reporting and testing functions. 4. Modeling using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development. 5. Securing the Framework Manager and Transformer models for data level, object level and package access security. 6. 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. 7. Complete testing of all reports, dashboards and analytics in all environments prior to business owner review/approval. 8. Transfer knowledge to other Cognos users creating their own reports in person and using electronic technologies. 9. Provide troubleshooting and end user support and problem resolution. 10. Research and develop solutions utilizing new product functionality to integrate into Human Services Cluster business deliverables. --- Required Qualifications --- • 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 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 MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

Programmer at MVP Consulting | Referso Jobs