Job Title: Systems Developer - Expert Task ID: HBITS-08-15044 Position Duration: 24 Months Client: State of NY Agency: Office of Children and Family Services Interview : In-Person Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at nysreqs@ilinksolutions.com
Description 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.
Mandatory Qualifications 1 84 Months of Experience in business requirement gathering, analysis and logical design; translating 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 queries sourced from multiple tables or views 5 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting data challenges to stakeholders 6 84 Months of Experience working in social services or related fields 7 Bachelor's Degree
Required Documentation • Resume
• Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.) i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.
