Systems Developer - Expert

Provide a short description of the Position: The position will be responsible for creating and updating Client reporting functions to comply with new Federal Client reporting requirements. This includes updating system-generated reports as a result of OSC audits, addressing reporting backlogs, refining current caseload data reports to cover on-going cases, adding Client data to the Commissioners Dashboard, and creating new reports for payee, referrals, case timeliness, completion, clients, performance (using NAMRS data), as well as other LDSS requests. Reporting capabilities will also be enhanced to allow for real-time report generation.

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 Client staff 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 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.