Senior Data Analyst - Data Migration & Quality Lead(Hybrid)

Cloud & Things Inc; New York (NY); Hybrid; USD 103,000 - 118,000; Full time

Job summary

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

The role requires 5+ years in data mapping and 3+ years with IBM DataStage ETL, plus strong SQL and SSRS experience. Hybrid work in Brooklyn, NY with an hourly W-2 arrangement and a deadline of 10/04/2026.

Qualifications

• 5+ years of source-to-target data mapping in IBM Mainframe and relational DBs.
• Documentation of data dictionaries with terms, values and definitions.
• Migration of VSAM data to relational/CDS databases.
• 3+ years with IBM DataStage ETL.
• Extracting data from COBOL programs and using SQL for validations.
• Experience with Pension Administration systems.
• Strong SQL, including complex queries and stored procedures.
• SSRS report development experience.
• Ability to work across IBM Mainframe, Windows Server, and SQL Server.

Responsibilities

• Lead data profiling, cleansing, conversion, migration, and validation.
• Document data quality rules with SMEs and IT partners.
• Create source-to-target mappings for data conversion.
• Develop complex SQL validations based on STTMs and target models.
• Optimize ETL and SQL processes for data quality initiatives.
• Support defect handling and data integrity improvements.

Skills

Data mapping

SQL & SSRS

Data profiling

ETL development

Mainframe data handling

COBOL/CICS/DB2

Pension systems

Git version control

Data quality

Tools

IBM DataStage

VSAM

SQL Server

SSRS

BMC Control-M

Job description

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

The role requires 5+ years in data mapping and 3+ years with IBM DataStage ETL, plus strong SQL and SSRS experience. Hybrid work in Brooklyn, NY with an hourly W-2 arrangement and a deadline of 10/04/2026.