Job Location : Rensselaer,NY, USA
Job Title: Programmer - Expert Task ID: HBITS-06-13648 Position Duration: 24 Months Client: State of NY Agency: Office of Children and Family Services Please call (703) ###-#### | (571) ###-#### | (703) ###-#### or email at nysreqsilinksolutions.com Description Tasks that this position will be handling during the period the position is being requested: Work collaboratively with OREP nd 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. 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; 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 Required Documentation Rsum 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.) Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability