Apply Now

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

Hybrid in New York, NY, US • Posted 9 hours ago • Updated 9 hours ago

Full Time

Hybrid

Depends on Experience

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

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 Data Modeler - (IBM DataStage, ETL, SSRS, COBOL)
Location: Brooklyn, NY 11201 (Hybrid –Local candidates)
Duration: 12 Months (with potential for extension)
Start Date: anticipated October 1, 2026
W2 Hourly Rate: $75 - $85/hour
Application Deadline: August 6, 2026

Overview:

We are seeking a Mainframe Data Modeler who will support our client’s Data Management team with data modeling, profiling, cleansing, conversion, migration, and validation activities for a legacy replacement initiative and ongoing process improvement programs. The role will perform detailed field-level and metadata analysis, develop conceptual, logical, physical, and dimensional data models, and translate legacy business and data quality rules into source-to-target mappings and technical specifications.

Duties:

- Participate in the identification, inventory, and classification of critical data.
- Perform detailed field-level analysis, metadata analysis, and profiling of internal and external data sources.
- Create conceptual, logical, physical, and dimensional data models.
- Work with data subject matter experts to document data quality rules, business terms, valid values, and definitions.
- Support data profiling, cleansing, conversion, migration, and validation efforts for legacy replacement and process improvement initiatives.
- Optimize and tune existing ETL and SQL processes for performance.
- Extract business rules from legacy code and create source-to-target mappings.
- Transform business rules and data quality rules into ETL and SQL technical specifications.
- Develop complex SQL data validations based on source-to-target mappings and target data models.
- Provide technical and analytical support for data integrity and data quality initiatives.
- Collaborate with subject matter experts, technical leads, and IT partners to identify and remediate data quality gaps using manual and automated solutions.
- Support processes that proactively detect, correct, and prevent invalid data values.
- Perform defect handling, technical troubleshooting, and problem resolution.

Mandatory Qualifications:

- 5+ years’ experience of source-to-target data mapping experience in mixed IBM mainframe and relational database environments.
- 3+ years’ experience developing ETL applications using IBM DataStage.
- 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, calculated data, and business rules from COBOL programs and legacy code.
- Experience with BMC Control-M workload automation software.
- Experience with Git version control software.
- Minimum of three (3) years of recent experience with pension administration systems.
- Strong SQL knowledge, including complex queries, stored procedures, and complex data validations based on source-to-target mappings and target data models.
- Proficiency in SQL Server Reporting Services (SSRS) report development.
- Proficiency with mainframe applications and technologies, including COBOL, CICS, and DB2.
- Ability to work across IBM mainframe, Windows Server, and SQL Server environments.
- Strong understanding of data structures and their relationships to ETL applications.
- Strong analytical skills with the ability to analyze requirements and propose solutions that adhere to established team methodologies.

Desirable Qualifications:

- Experience with data quality and data profiling tools.
- Experience with data warehouses and data marts.
- Prior experience working in a pension system, preferably 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.
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:
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: 9389
Posted 9 hours ago

Contact the job poster

Dylan Carroza

Senior Technical Recruiter @ Cloud and Things

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Hybrid in New York, New York

•

Today

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 sectors 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:Mainframe ETL Data Analyst (VSAM, Cobol, ETL,

Easy Apply

Full-time

Depends on Experience

Senior Data Analyst with ETL expertise

Brooklyn, New York

•

Today

UNIVERSAL Technologies is seeking a Senior Data Analyst with ETL expertise and experience in mainframe/relational database management systems for a hybrid position in Brooklyn, NY. The applicant is expected to work onsite. Position: The Senior Data Analyst with ETL Expertise shall provide the clients Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts as part of the Legacy Replacement initiative as well as the

Easy Apply

Full-time, Third Party

85+

Senior Data Modeler

Hybrid in Brooklyn, New York

•

4d ago

UNIVERSAL Technologies, LLC is seeking one (1) Senior Data Modeler Analyst with Data Modeling for a hybrid role in Brooklyn, NY with expertise to work with Information Technology (IT). Active LinkedIn preferred. The Senior Data Analyst with Data Modeling expertise will primarily be responsible for detailed field-level analysis, metadata analysis and profiling of internal and external sources as well as creation of conceptual, logical physical, and dimensional data models as part of UNIVERSAL s o

Easy Apply

Contract, Third Party

Depends on Experience

Data Analyst

Brooklyn, New York

•

3d ago

Role: Data Analyst Location: Brooklyn NY (Onsite) Duration: 12 months Job Description: The Senior Data Analyst with Data Modeling expertise will primarily be responsible for detailed field-level analysis, metadata analysis and profiling of internal and external sources as well as creation of conceptual, logical physical, and dimensional data models as part of Client ongoing process improvement programs. Mandatory Skills/Experience Minimum of five (5) years of source-to-target data mapping exper

Easy Apply

Contract

Depends on Experience

Search all similar jobs

More jobs at Cloud and Things in New York, NY

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

Dice Job Match Score™

Job Details

Skills

Summary

Dylan Carroza

Similar Jobs