Senior Data Analyst: Public Sector Data & ETL Lead

Cloud & Things Inc

New York (NY)

Hybrid

USD 103,000 - 118,000

Full time

3 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Cloud and Things is seeking a Senior Data Analyst to support the NYCERS client. You will lead profiling, cleansing, conversion, and validation across mainframe and SQL environments, translating legacy rules into validated target-state data solutions.

The role requires extensive ETL/SQL and COBOL experience, with a focus on data quality and migrations. This exempt, hybrid position in Brooklyn, NY offers a W2 hourly rate of $75 - $86/hour and an emphasis on collaboration with the Data Management

Qualifications

5+ years of source-to-target data mapping in IBM Mainframe and relational databases.
Experience creating data dictionaries with terms, values and definitions.
Experience migrating VSAM data to relational SQL databases.
3+ years with IBM DataStage ETL.
Experience extracting fields from COBOL programs.
Experience with BMC Control-M and Git.
3+ years in Pension Administration systems.
Strong SQL, including stored procedures, and SSRS knowledge.
Ability to work across IBM Mainframe, Windows Server and SQL Server.
COBOL, CICS and DB2 knowledge.
Understanding data structures for ETL mappings.

Responsibilities

Lead data profiling, cleansing, conversion, migration and validation for NYCERS.
Create source-to-target mappings from legacy rules and source data.
Translate business rules into ETL/SQL specifications with complex validations.
Optimize ETL and SQL processes for data quality and migration tasks.
Support data integrity initiatives with SMEs and IT partners.
Help detect and resolve invalid data values and defects.