Short Description Of The Position
This resource will work on reporting, analysis and measurements for Juvenile Justice and Child Welfare This includes needed development of data structures and extractions that are necessary for the continued support of Voluntary Agencies, Local Districts of Social Services (LDSSs) and Federal Reporting. Reporting areas may include (but are not limited to) prevention services, safety assessments, candidacy, permanency, education records, and finance.
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:
W ork collaboratively with OREPA and participate in business requirement gathering for BI projects.
W ork with Business Analyst on analysis and logical design.
P erform complex SQL coding to facilitate reporting and testing functions.
M odeling using IBM Cognos BI Framework Manager and Transformer to support mission critical reporting initiatives including all layers of the model and package development.
S ecuring the Framework Manager and Transformer models for data level, object level and package access security.
C reate 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.
C omplete testing of all reports, dashboards and analytics in all environments prior to business owner review/approval.
T ransfer knowledge to other Cognos users creating their own reports in person and using electronic technologies.
P rovide troubleshooting and end user support and problem resolution.
R esearch and develop solutions utilizing new product functionality to integrate into Human Services Cluster business deliverables.
Requested
Qualification Number
Requested Qualification
Please mention your experience in MONTHS
1
84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication
2
84 Months of Experience in creating and modifying Framework Manager models
3
84 Months of Experience in creating and modifying reports using COGNOS tools
4
84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries
5
84 Months Of Experience Testing Reports, Analytics, Troubleshooting, Problem
solving, documenting and presenting complex data challenges to stakeholders
6
84 Months of Experience working in social services or relating fields
7
Bachelor's Degree