Systems Developer Expert
Company: PSI International
Posted on: March 20, 2023
Agency Name: Office of Children and Family Services
Is this a Project/Program specific Position? Yes
If YES, list the Project/Program Name: SPPD Data Warehouse/System Developer Expert
Provide a short description of the Position: This resource will work on reporting, analysis and measurements for Adult Protective Services in New York State. This includes needed development of data structures and extractions that are necessary for the continued support of Local Districts of Social Services (LDSSs). Specifically, this resource will work on these areas: 1) update current system generated reports identified through OSC Audit as lacking accurate coding, 2) review and revise all remaining existing system reports for accuracy, 3) refine current caseload data reports to cover on-going cases, 4) add Client data to Commissioner Dashboard, create a Rep Payee report, referral month log, and address a large backlog of LDSS requested monitoring reports related to: case timeliness, completion dates, client needs and demographics, and return clients.
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 BREPA 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 11.1 R1, 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.
Number of Position(s) being requested: (Maximum of 5 per Attachment 7, Section 1.2.1) 1
Position Job Title: (Per Attachment 4) Systems Developer
Position Skill Level: (Per Attachment 4) Expert
"Number of Form 2 Candidate Responses allowed per Contractor, per Position?
(1 or 2 per Attachment 7, Section 1.2.2)" 1
"Target Start Date:
(30 Business Days minimum and 90 Calendar Days maximum from date of request)" 5/18/2023
"Engagement Length in Months:
(2 to 30 per Attachment 7, Section 1.2.3)" 18
"Is this a Full or Part-Time Position?
(Full-Time is 40 Hours Per Week)" Full-Time
If Part-Time, enter approximate number of hours per week:
"What are the daily work hours?
(Note if negotiable or list preferred start and end time):" 8am-5pm (negotiable)
Where is the Home Base Region? (Per Attachment 4) 1
Where is the physical work office located? "Bureau of Research, Evaluation and Performance Analytics (BREPA)
New York State Office of Children and Family Services
52 Washington St., Room 323 North
Rensselaer, NY 12144"
"Is telecommuting allowed for this position?
(As designated by the Authorized User)" Yes
If YES, note if negotiable or list the percentage allowed/number of days allowed per week 40% after the first three months, pending satisfactory job performance / evaluation
What is the format of the Candidate interview? Webcasting
If Webcasting, is Candidate required to be on camera? Yes
What type of software is typically used by the Agency? Microsoft
What type of hardware is typically used by the Agency? Microsoft
Position Mandatory Qualification (Per Attachment 7, Section 1.2.4)
"Position Job Title: Systems Developer
Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
"Position Skill Level: Expert
84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication
84 Months of Experience in creating and modifying Framework Manager models
84 Months of Experience in creating and modifying reports using COGNOS tools
84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries
84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting complex data challenges to stakeholders
84 Months of Experience working in social services or relating fields
Additional Information Requests:
Are there additional security requirements for the Authorized User? No
If YES, include the additional security requirements:
Will additional training potentially be required during the Engagement? No
If YES, provide description of anticipated training:
What type and/or manner, of knowledge transfer is requested during the Engagement? We will have weekly meetings with the resource and other OCFS team members to understand and get an update of progress to date on tasks assigned. Additionally, upon completion of assigned tasks we will have debriefing sessions to assist in knowledge transfer.
Is travel anticipated during the Engagement? No
If YES, list anticipated frequency and locations for travel:
Agency Name: Office of Children and Family Services
Keywords: PSI International, Albany , Systems Developer Expert, IT / Software / Systems , Rensselaer, New York
here to apply!