Cloud and Things
Cloud and Things

Mainframe ETL Data Analyst – (VSAM, Cobol, ETL, DataStage, DB2)

Hybrid in New York, NY, US • Posted 10 hours ago • Updated 10 hours ago
Full Time
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

Summary

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. Salary commensurate with experience*

Job Title: Mainframe ETL Data Analyst – (VSAM, Cobol, ETL, DataStage, DB2)
Location: Brooklyn, NY (Must be LOCAL - Hybrid)
Duration: 12 Months (with potential for extension)
Start Date: October 1, 2026 (anticipated)
W2 Hourly Rate: $75 - $85/hour
Application Deadline: August 9, 2026


Overview:

We are seeking a Mainframe ETL Data Analyst who will support our NYS client. This role will provide technical expertise for data profiling, cleansing, source-to-target mapping, conversion, migration, and validation activities supporting a legacy replacement initiative and ongoing process improvement programs. The consultant will analyze VSAM and COBOL-based source data, map it into relational and dimensional SQL structures, maintain the master data dictionary, and support the design and validation of mission-critical data solutions.



Duties:
  • Perform detailed field-level analysis, metadata analysis, data profiling, cleansing, and source-to-target mapping for legacy replacement and process improvement initiatives.
  • Analyze and map VSAM files and legacy data structures into relational and dimensional SQL database tables.
  • Develop and maintain source-to-target mapping documents, the master data dictionary, business terms, valid values, definitions, and related metadata documentation.
  • Design, develop, and support IBM DataStage ETL processes for data extraction, transformation, conversion, migration, and validation.
  • Extract field references, calculated data, and business rules from COBOL programs and other legacy application code.
  • Develop complex SQL queries, stored procedures, and data validation routines based on source-to-target mappings and target data models.
  • Develop and maintain SSRS reports and support database design and component inventory for mission-critical applications.
  • Work across IBM Mainframe, Windows Server, and SQL Server environments using COBOL, CICS, DB2, Control-M, and Git.
  • Analyze business and technical requirements, recommend solutions aligned with team methodology, troubleshoot issues, and collaborate with project stakeholders.

Mandatory Qualifications:
  • 5+ years’ experience of source-to-target data mapping experience in mixed mainframe and relational database environments.
  • 3+ years’ experience developing ETL applications using IBM DataStage.
  • 3+ years’ experience with pension administration systems.
  • Experience creating data dictionary documentation that includes business terms, valid values, and definitions.
  • Experience converting and migrating VSAM data to relational and dimensional SQL distributed databases.
  • Experience extracting field references and calculated data from COBOL programs.
  • Experience with BMC Control-M workload automation software and Git version control software.
  • Strong SQL expertise, including complex queries, stored procedures, and data validations based on source-to-target mappings and target data models.
  • Proficiency in SSRS report development.
  • Ability to work across IBM Mainframe, Windows Server, and SQL Server environments.
  • Proficiency with mainframe applications and technologies including COBOL, CICS, and DB2.
  • Strong understanding of data structures and their relationship to ETL applications.
  • Strong analytical, problem-solving, requirements analysis, information-gathering, and technical 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.
  • Experience with SQL Server Reporting Services (SSRS).
  • Prior experience supporting a pension system, preferably a New York State or New York City pension system.



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:
  • 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91116955
  • Position Id: 9388
  • Posted 10 hours ago
Contact the job poster
Dylan Carroza

Dylan Carroza

Senior Technical Recruiter @ Cloud and Things
View Profile
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Mainframe Data Modeler - (IBM DataStage, ETL, SSRS, COBOL)

Hybrid in New York, New York

•

Today

Easy Apply

Full-time

Depends on Experience

Senior Data Analyst with ETL expertise

Brooklyn, New York

•

Today

Easy Apply

Full-time, Third Party

85+

Mainframe Data Analyst

Hybrid in New York, New York

•

Today

Easy Apply

Contract

Depends on Experience

Senior Data Analyst-W2 Only-Brooklyn, NY-Hybrid

Hybrid in New York, New York

•

Today

Easy Apply

Contract

Depends on Experience

Search all similar jobs
More jobs at Cloud and Things in New York, NY