Apply Now

Senior Data Analyst with ETL Expertise

New York, NY, US • Posted 5 hours ago • Updated 5 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Information Technology
Meta-data Management
Mapping
Master Data Management
Database Design
Inventory
Data Mapping
RDBMS
Data Dictionary
Documentation
Migration
VSAM
Database
IBM InfoSphere DataStage
BMC Control-M
Git
Version Control
Stored Procedures
IBM Mainframe
Microsoft Operating Systems
Microsoft Windows Server
Mainframe
COBOL
CICS
IBM DB2
Data Structure
Extract
Transform
Load
SQL
Analytical Skill
Problem Solving
Conflict Resolution
Information Gathering
Business Rules
Data Quality
Data Warehouse
Data Marts
Microsoft SQL Server
Microsoft SSRS

Information Technology
Meta-data Management
Mapping
Master Data Management
Database Design
Inventory
Data Mapping
RDBMS
Data Dictionary
Documentation
Migration
VSAM
Database
IBM InfoSphere DataStage
BMC Control-M
Git
Version Control
Stored Procedures
IBM Mainframe
Microsoft Operating Systems
Microsoft Windows Server
Mainframe
COBOL
CICS
IBM DB2
Data Structure
Extract
Transform
Load
SQL
Analytical Skill
Problem Solving
Conflict Resolution
Information Gathering
Business Rules
Data Quality
Data Warehouse
Data Marts
Microsoft SQL Server
Microsoft SSRS

Summary

Role: Senior Data Analyst with ETL Expertise

Location: Brooklyn, NY (Hybrid)

Duration: Long Term

Scope of Services:

The client seeks one (1) Senior Data Analyst with ETL expertise to work with the Information Technology (IT) Division. The Senior Data Analyst with ETL Expertise will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program. The Senior Data Analyst will create and maintain the master data dictionary, and assist in database design of client mission-critical applications and inventory of its components.

Mandatory Skills/Experience

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 technical 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: RTL939169
Position Id: 489e0b48f3f39d4794513bb25b44ac73
Posted 5 hours ago

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

Brooklyn, New York

•

3d ago

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 Analyst with DataStage

Hybrid in Brooklyn, New York

•

Today

Need data extraction from Cobol programs and ETL DataStage development You will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program. Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments. Experience creating data dictionary

Easy Apply

Contract, Third Party

Depends on Experience

Senior Data Analyst with ETL

New York, New York

•

2d ago

Senior Data Analyst with ETL Brooklyn, NYContractMandatory Skills/Experience 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 that includes 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 Da

Easy Apply

Contract

Depends on Experience

Data Analyst with ETL expertise and Pension/Retirement

Hybrid in Brooklyn, New York

•

Today

Position: Data Analyst with ETL expertise and Pension/Retirement Location: Brooklyn, NY (Hybrid) Should be local to NY/NJ within commute Duration: 1-2 years contract The Senior Data Analyst with ETL Expertise shall provide the client 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 client''s ongoing process improvement programs. Client is seeking

Easy Apply

Contract

Depends on Experience

Search all similar jobs

More jobs at Yale University in New York, NY