4 results (1 new)

Group by company

Incipient Corp.

New York, New York • Today

Easy Apply

Third Party, Contract

70 - 80

Senior Data Analyst with ETL expertise

UNIVERSAL Technologies

Hybrid in Brooklyn, New York • 2d ago

Easy Apply

Full-time, Third Party

Depends on Experience

Data Analyst (ETL, Mainframe)

Spruce Technology Inc.

Remote • 2d ago

Easy Apply

Contract, Third Party

Depends on Experience

Role: Senior Data Analyst - Exp with Pension Administration systems

Prohires

Hybrid in Brooklyn, New York • Yesterday

Easy Apply

Contract

Depends on Experience

Job Details

Skills

Data Analyst
etl
mainframe
Pension Administration systems

Summary

Senior Data Analyst (ETL, Mainframe)

Introduction: We are seeking a Senior Data Analyst with ETL expertise to support the IT Division and Data Management team. The role will focus on data profiling, cleansing, mapping, conversion, migration, and validation of legacy data as part of the enterprise-wide Legacy Replacement program and ongoing process improvement initiatives.

Responsibilities:

Participate in identification, inventory, and classification of critical data.
Work with data SME's to document data quality rules and definitions.
Actively participate in optimization and performance tuning of existing ETL and SQL processes.
Extract business rules from the existing Legacy code and create Source-to-Target mappings.
Transform business rules and data quality rules into ETL and/or SQL technical specifications.
Develop complex SQL data validations based on STTMs and target Data Models.
Provide technical and analytical support to NYCERS data integrity and quality initiatives.
Collaborate with SME's and technical leads in identifying and addressing data quality gaps.
Work with IT partners to remediate identified gaps using both manual and automated solutions.
Support processes that proactively detect, correct, and prevent invalid data values.
Defect handling and problem resolution.

Requirements:

Mandatory Skills/Experience:

Experience Mandatory:
- Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
- Experience creating data dictionary documentation with business terms, valid values, and definitions.
- Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
- Minimum of three (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.
- Minimum of three (3) years of recent experience with Pension Administration systems.
Technical Ability Mandatory:
- Strong SQL knowledge working with complex queries and stored procedures.
- Proficiency in SSRS reports' development.
- Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology.
- Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
- Proficiency in mainframe applications encompassing COBOL, CICS, and DB2.
- Understanding of data structures and their relationship to ETL applications.
- Ability to develop complex SQL data validations based on STTMs and target Data Models.
- Excellent analytical, problem-solving, and information gathering skills along with fundamental technique troubleshooting abilities.

Desirable Skills/Experience:

Experience extracting business rules from the existing legacy code.
Experience with Data Quality/Profiling tools.
Experience with Data Warehouses/Data Marts.
Experience with SQL Server Reporting Services (SSRS).
Prior experience working in a pension system, preferably New York State or New York City pension system.

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: 91119062
Position Id: 9100155
Posted 5 hours ago

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Contact the job poster

Sushanta Mallick

Recruiter @ Incipient Corp.

View Profile

Create job alert

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

Similar Jobs

Senior Data Analyst with ETL expertise

Hybrid in Brooklyn, New York

•

2d ago

UNIVERSAL Technologies, LLC is seeking an experienced Senior Data Analyst with ETL expertise for a hybrid role in Brooklyn, NY to work with the Information Technology (IT) Division. UNIVERSAL Technologies reserves the right to hire the candidate(s) as an employee, at no additional cost, after a period of six (6) months. The Senior Data Analyst will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL

Easy Apply

Full-time, Third Party

Depends on Experience

Role: Senior Data Analyst - Exp with Pension Administration systems

Hybrid in Brooklyn, New York

•

Yesterday

Role: Senior Data Analyst - Exp with Pension Administration systems & (3 official references) Mandatory Location: 335 Adams Street, Brooklyn, NY 11201. Hybrid schedule combining in -office and remote workday Duration: 1+ Year Contract with likely Extension Scheduled Work Hours: Monday through Friday, 40 hours per week. 8:00 AM - 4:45 PM EST Mandatory Skills/Experience Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments

Easy Apply

Contract

Depends on Experience

Senior Data Analyst with Pension/Retirement::Need locals to NY/NJ

Hybrid in Brooklyn, New York

•

Today

The Senior Data Analyst shall provide the Client's 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 ongoing process improvement programs. Prior experience working in a pension system is required, preferably a New York State or New York City pension system.The following deliverables shall apply: Participate in identification, inventory, and classificat

Easy Apply

Contract

Depends on Experience

Data Warehouse ETL Developer/Informatica Developer

Hybrid in New York, New York

•

Today

Job Summary: We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts, ETL processes, and strong problem-solving skills to ensure high-quality, timely, and accurate data integration. Key Responsibilities: Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter. Extract

Easy Apply

Contract, Third Party

$60

Job Details

Skills

Data Analyst
etl
mainframe
Pension Administration systems

Summary

Senior Data Analyst (ETL, Mainframe)

Responsibilities:

Participate in identification, inventory, and classification of critical data.
Work with data SME's to document data quality rules and definitions.
Actively participate in optimization and performance tuning of existing ETL and SQL processes.
Extract business rules from the existing Legacy code and create Source-to-Target mappings.
Transform business rules and data quality rules into ETL and/or SQL technical specifications.
Develop complex SQL data validations based on STTMs and target Data Models.
Provide technical and analytical support to NYCERS data integrity and quality initiatives.
Collaborate with SME's and technical leads in identifying and addressing data quality gaps.
Work with IT partners to remediate identified gaps using both manual and automated solutions.
Support processes that proactively detect, correct, and prevent invalid data values.
Defect handling and problem resolution.

Requirements:

Mandatory Skills/Experience:

Experience Mandatory:
- Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments.
- Experience creating data dictionary documentation with business terms, valid values, and definitions.
- Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases.
- Minimum of three (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.
- Minimum of three (3) years of recent experience with Pension Administration systems.
Technical Ability Mandatory:
- Strong SQL knowledge working with complex queries and stored procedures.
- Proficiency in SSRS reports' development.
- Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team's methodology.
- Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
- Proficiency in mainframe applications encompassing COBOL, CICS, and DB2.
- Understanding of data structures and their relationship to ETL applications.
- Ability to develop complex SQL data validations based on STTMs and target Data Models.
- Excellent analytical, problem-solving, and information gathering skills along with fundamental technique troubleshooting abilities.

Desirable Skills/Experience:

Experience extracting business rules from the existing legacy code.
Experience with Data Quality/Profiling tools.
Experience with Data Warehouses/Data Marts.
Experience with SQL Server Reporting Services (SSRS).
Prior experience working in a pension system, preferably New York State or New York City pension system.

Dice Id: 91119062
Position Id: 9100155
Posted 5 hours ago

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Contact the job poster

Sushanta Mallick

Recruiter @ Incipient Corp.

View Profile

Create job alert

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

Similar Jobs

Senior Data Analyst with ETL expertise

Hybrid in Brooklyn, New York

•

2d ago

Easy Apply

Full-time, Third Party

Depends on Experience

Role: Senior Data Analyst - Exp with Pension Administration systems

Hybrid in Brooklyn, New York

•

Yesterday

Easy Apply

Contract

Depends on Experience

Senior Data Analyst with Pension/Retirement::Need locals to NY/NJ

Hybrid in Brooklyn, New York

•

Today

Easy Apply

Contract

Depends on Experience

Data Warehouse ETL Developer/Informatica Developer

Hybrid in New York, New York

•

Today

Easy Apply

Contract, Third Party

$60