Data Analyst

No 3rd Party Submissions

No Sponsorship

Work Location: The job locations are Brooklyn, NY and New York, NY

Scheduled Work Hours: 7 hour work day

Assignment Start/End Date: Start dates TBD (but not before July 1, 2018)

Total Estimated Assignment Hours: 36 months.

Functional Job TitleData Analyst_2

PROJECT DESCRIPTION:

The Client Assistance and Rehousing Enterprise System (CARES) the agency’s case and sheltering management system and is used throughout the agency and the DHS provider network. The application drives business processes throughout the agency (e.g.: intake case and questionnaire, diversions, shelter assignments, outreach, assessments, service plans, invoicing, claiming, etc.), for all types of services offered by DHS (shelter, Outreach, Home-based preventative, permanent housing, etc.). The current version of the application is at the end of life and supportTasks & Duties * Perform Data Analysis and Reporting

• Develop and maintain automated online web-based dashboards using Cognos Reporting tools
• Analyze, evaluate and track metrics such as Key Performance Indicators (KPIs) and Key Risk Indicators (KRIs) to measure CoB, Audit and Regulatory risk across multiple operational dimensions
• Interpret the data to answer the question of why it is important, and to suggest recommended actions for management to take in response to it
• Perform Data Extraction
• Extract critical data from various data sources, load data into a centralized Microsoft SQL Server Database
• Prepare data feed files for a business intelligence database, and identify new data sources
• Create new Extract, Transform and Load (ETL) jobs using Microsoft SSIS

SPECIAL REQUIREMENTS: N/A

Minimum 5-7 Years Extensive experience using IBM Cognos (version 10.2) Report Studio, Active Reports and

Minimum 5-7 Years Oracle and Microsoft SQL Server is required SQL Server SSIS

Minimum 5-7 Years IBM Cognos Analytics version 11 IBM Cognos for Microsoft Office (Go Office) IBM

Minimum 5-7 Years Continuity of Business (CoB), Regulatory, and Audit reporting

Job Type: Contract

Salary: $30.00 to $40.00 /hour

Experience:

• IBM Cognos Analytics version 11 IBM Cognos for Microsoft Off: 7 years (Required)
• Continuity of Business (CoB), Regulatory, and Audit reportin: 7 years (Required)
• Create new Extract, Transform and Load (ETL) w/ ssis: 7 years (Required)
• Oracle and Microsoft SQL Server is required SQL Server SSIS: 7 years (Required)
• using IBM Cognos (version 10.2) Report Studio, Active Report: 7 years (Required)

Education:

• Bachelor’s (Preferred)

Job Location:

• New York, NY (Required)