Mindlance
Provide a short description of the Position: This resource will provide localized Cognos report administrative functions and provide guidance on developing data models, data mappings, data migrations and facilitate/accommodate data warehouse and Oracle needs from a design perspective for Cognos Report Development and Oracle Database tables/ETL. To support Federal government reporting, the resouce will generate the needed data files in the prescribed XML format. This resource will also work on reporting, analysis and measurements for Juvenile Justice in New York State, as well as any ad hoc reporting as needed.
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 using IBM Cognos Analytics 11.2, 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. • Mentor State staff and other contract resources as required. • Lead data exchange efforts for Federal and State Reporting to content and file specifications (.xml) • 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.
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
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 using IBM Cognos Analytics 11.2, 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. • Mentor State staff and other contract resources as required. • Lead data exchange efforts for Federal and State Reporting to content and file specifications (.xml) • 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.
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.