Search Jobs | Dice.com

4 results (2 new)

Group by company

Data Analyst (ETL, Mainframe)

Spruce Technology Inc.

Remote • Today

Easy Apply

Contract, Third Party

Depends on Experience

Senior Data Analyst with ETL expertise

UNIVERSAL Technologies

Hybrid in Brooklyn, New York • Today

Easy Apply

Full-time, Third Party

Depends on Experience

TxDMV - Systems Analyst - Data Engineer (Remote in TX)

CAPPS

Remote or Texas • Today

Full-time

USD 5,797.66 - 9,508.25 per month

Data Warehouse Analyst

inteletech

Tallahassee, Florida • Today

Full-time

Job Details

Skills

Data
ETL
Mainframe

Summary

Title: Senior Data Analyst (ETL, Mainframe)
Location: Brooklyn, NY
Long Term

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.

Tasks:

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.

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.

All full-time employees are eligible for the following benefits:
Medical, dental, vision health benefits
Life Insurance and AD&D (paid by company)
401k, Flexible and Dependent Care Spending Account plans.
Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).

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: 10215935
Position Id: 26-01092
Posted 2 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.

Create job alert

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

Similar Jobs

Automation ETL tester

Remote

•

Today

Job Responsibilities and Qualifications for Automation ETL tester/ Data Tester: Design, develop, and execute test strategies and test cases for ETL processes and data pipelines. Validate data movement from source systems through staging, transformation, and target data platforms. Perform source-to-target data validation and reconciliation. Validate data transformations, mappings, business rules, calculations, aggregations, and data conversions. Develop complex SQL queries to validate data across

Easy Apply

Third Party, Contract

$DOE

Data Engineer (Ex Walmart Needed)

Remote

•

5d ago

Ex Walmart Candidate only Role Overview: Seeking a Data Engineer with experience in data pipelines, data integration, data modeling, SQL, and data governance. The candidate will design and develop scalable data solutions, perform data quality checks, and work with business stakeholders to translate requirements into technical solutions. Key Responsibilities: Develop and maintain data pipelines, ETL/ELT processes, and data integrations. Extract, transform, and validate data from multiple source

Easy Apply

Contract, Third Party

Depends on Experience

ETL Developer - Entry Level

Remote

•

Today

Job DescriptionWe are seeking a motivated Entry-Level ETL Developer to join our data engineering team. The ideal candidate will have a strong foundation in SQL, databases, data integration, and programming, with an interest in building and maintaining reliable data pipelines. This position offers an opportunity to work with enterprise data platforms and collaborate with data engineers, analysts, application teams, and business stakeholders. ResponsibilitiesDevelop, maintain, and monitor ETL/ELT

Easy Apply

Full-time

60,000 - 80,000

Senior Data Quality & Snowflake Migration Engineer

Remote or Boston, Massachusetts

•

Today

RESPONSIBILITIES: Kforce has a client in need of a Senior Data Quality & Snowflake Migration Engineer in Boston, MA. Responsibilities: * Design and implement data quality and validation processes for large-scale cloud data migrations * Profile source data to identify accuracy, completeness, consistency, duplication, and formatting issues * Develop SQL-based validation rules, reconciliation processes, and exception reporting * Perform source-to-target mapping, transformation analysis, and data v

Contract

$71 - $80 hourly

Job Details

Skills

Data
ETL
Mainframe

Summary

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.

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.

Dice Id: 10215935
Position Id: 26-01092
Posted 2 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.

Create job alert

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

Similar Jobs

Automation ETL tester

Remote

•

Today

Easy Apply

Third Party, Contract

$DOE

Data Engineer (Ex Walmart Needed)

Remote

•

5d ago

Easy Apply

Contract, Third Party

Depends on Experience

ETL Developer - Entry Level

Remote

•

Today

Easy Apply

Full-time

60,000 - 80,000

Senior Data Quality & Snowflake Migration Engineer

Remote or Boston, Massachusetts

•

Today

Contract

$71 - $80 hourly