Senior Data Analyst

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

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.

Skills

ETL development

SQL

IBM DataStage

Git

COBOL

COBOL/CICS/DB2

VSAM

Mainframe

Pension systems

SSRS

Tools

BMC Control-M

Job description

Other Area(s) Brooklyn , New York W-2 hourly Sep 30, 2026

Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of transforming the public sector's IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers the opportunity to work on rewarding projects, consider a career with Cloud and Things.
*This is an exempt position. Salarycommensuratewith experience*
Job Title: Senior Data Analyst
Location: Brooklyn, NY 11201 (Hybrid)
W2 Hourly Rate: $75 - $86/hour
Application Deadline: 10/04/2026

Overview

We are seeking a Senior Data Analyst who will support our NYCERS client as part of the Data Management team. This role will lead data profiling, cleansing, conversion, migration, and validation activities for the Legacy Replacement initiative while supporting ongoing data quality and process improvement efforts. The analyst will work across mainframe and relational database environments to translate legacy business rules and source data into validated target-state data solutions.

Duties

• Participate in the identification, inventory, and classification of critical NYCERS data and work with data subject matter experts to document data quality rules and definitions.
• Extract business rules from existing legacy code and create source-to-target mappings for data conversion and migration activities.
• Transform business rules and data quality rules into ETL and/or SQL technical specifications and develop complex SQL data validations based on STTMs and target data models.
• Optimize and performance-tune existing ETL and SQL processes supporting data profiling, cleansing, conversion, migration, and validation efforts.
• Provide technical and analytical support for data integrity and quality initiatives, including identifying and remediating data quality gaps with SMEs, technical leads, and IT partners.
• Support processes that proactively detect, correct, and prevent invalid data values, including defect handling and problem resolution.

Mandatory Qualifications

• 5+ years of source-to-target data mapping experience in mixed IBM Mainframe and relational database environments.
• Experience creating data dictionary documentation that includes business terms, valid values, and definitions.
• Experience converting or migrating VSAM data to relational or dimensional SQL distributed databases.
• 3+ years of recent experience developing applications using IBM DataStage ETL.
• Experience extracting field references and calculated data from COBOL programs.
• Experience with BMC Control-M workload automation software.
• Experience with Git version control software.
• 3+ years of recent experience with Pension Administration systems.
• Strong SQL knowledge, including complex queries and stored procedures.
• Proficiency in SQL Server Reporting Services (SSRS) report development.
• Strong analytical skills with the ability to analyze requirements and propose solutions that adhere to team methodology.
• Ability to work across IBM Mainframe, Windows Server, and SQL Server environments.
• Proficiency with mainframe applications using COBOL, CICS, and DB2.
• Understanding of data structures and their relationship to ETL applications.
• Ability to develop complex SQL data validations based on source-to-target mappings (STTMs) and target data models.
• Excellent analytical, problem-solving, information-gathering, and troubleshooting skills.

Desirable Qualifications

• Experience extracting business rules from existing legacy code.
• Experience with data quality and data profiling tools.
• Experience with data warehouses and data marts.
• Prior experience working with a New York State or New York City pension system.

What We Offer

Opportunities to lead impactful transformations in the public sector infrastructure.

Engagement with high-profile government initiatives, supporting meaningful change.

Professional development through exposure to innovative Agile practices and leadership collaboration.

A collaborative environment that values ownership, initiative, and continuous learning.

Ready to make a difference?

We're eager to connect with qualified candidates committed to delivering results and fostering excellence within client projects.

Cloud and Things complies with all applicable federal, state, and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race,color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.

AI-Assisted Resume Evaluation Notice

Cloud and Things - Talent Management

Notice to Candidates

Cloud and Things utilizes artificial intelligence (AI) tools to assist our recruiting team in evaluating candidate applications for streamlining; consistency, efficiency, and thoroughness. All hiring decisions are ultimately made by our human recruiting professionals.

How AI Is Used

Our AI tools assist by:

Analyzing resumes against job requirements

Supporting our recruiters in candidate data evaluation

Ensuring consistent review standards across all applications

Important: AI serves as a support tool only. As noted above, all candidate selection and hiring decisions are made by experienced human recruiters. Your unedited resume will be processed by our AI tools as part of this evaluation.

Your Data and Privacy

Cloud and Things Data Handling

Your information is processed securely and used exclusively for recruitment purposes

Cloud and Things may store your resume in our Applicant Tracking System (ATS) indefinitely for future job matching opportunities

You may opt out of long-term ATS storage by emailing your name and your request to opt out of storing your resume in the ATS to: [e-mail]

All personal information is handled confidentially in accordance with our privacy policy

AI Tool Data Processing

AI processing data is retained for a maximum of 90 days, after which it is deleted

All data sent to AI tools is encrypted in transit and at rest

AI tools comply with applicable privacy laws including GDPR and CCPA

Personal data is anonymized or minimized wherever possible during AI processing

Your Participation

By submitting your application, you acknowledge this notice and consent to AI-assisted evaluation as part of our recruitment process. You may opt out only by choosing not to submit your resume for consideration.