Sr. Cognos BI Developer
30 Months
Albany NY
HBITS/ Office of Children and Family Services
- 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.
Title : Location : Duration : Client : Requirements :