(CARES) -Senior Data Analyst – TechSolnZ LLC – Brooklyn, NY

(CARES) -Senior Data Analyst
TechSolnZ LLC
Brooklyn, NY

TechSolnZ LLC seeks a CARES Senior Data Analyst for the following upcoming project:

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 support

Tasks & 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

Required Skills

* Minimum 5-7 Years Extensive experience using IBM Cognos (version 10.2) Report Studio, Active Reports and Framework Manager to build Dashboards and Reports ,

* 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 InfoSphere DataStage data marts (star and snowflake schemas) and freehand SQL

* Minimum 4 Years Continuity of Business (CoB), Regulatory, and Audit reporting

General Info

* Authorized to work in the US for any employer

* No Relocation provided

Job Type: Full-time


  • Continuity of Business (CoB), Regulatory, and Audit reportin: 5 years (Required)
  • Oracle and Microsoft SQL Server is required SQL Server SSIS: 5 years (Required)
  • IBM Cognos Report Studio, Active Reports & Framework Manager: 5 years (Required)
  • IBM Cognos Report Studio to build Dashboards and Reports: 5 years (Required)
  • IBM Cognos Analytics version 11 for MS Office: 5 years (Required)

Apply Now

Please review all application instructions before applying to TechSolnZ LLC.

This employer accepts applications via Indeed.

Other jobs you may like

TechSolnz (pronounced, TechSolutions) provides a wide range of consultative services to customers both in the military and commercial…

Let employers find you

Thousands of employers search for candidates on Indeed