Programmer - Expert

Provide a short description of the Position: 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. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Tasks that this position will be handling during the period the position is being requested: • 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.