Senior Data Analyst: ETL & Legacy Migration Pro

Universal Technologies; United States; Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Competitive compensation

Health Dental and Vision Insurance

Group Life Insurance

401k

HSA/FSA

Pre Tax Transportation Benefits

Generous PTO and Holiday Benefits

Job summary

UNIVERSAL Technologies LLC, based in Brooklyn, NY, seeks an experienced Senior Data Analyst with ETL expertise for a hybrid IT role. You will map VSAM files into SQL, perform metadata profiling, and contribute to an enterprise Legacy Replacement program.

The position requires 5+ years in data mapping with mainframe and relational DBs, IBM DataStage experience, and strong SQL/SSRS skills. Starts Jan 1, 2027.

Qualifications

• 5+ years of data mapping in mixed mainframe and relational DB environments.
• Create data dictionaries with business terms and definitions.
• Convert and migrate VSAM data into relational and dimensional SQL databases.
• 3+ years developing ETL with IBM DataStage.
• Extract data from COBOL programs and business rules from legacy code.
• Experience with Pension Administration systems; NY pension environment preferred.
• Strong SQL knowledge including complex queries and stored procedures.
• SSRS report development and data quality/profiling tool familiarity.
• Experience with Data Warehouses/Data Marts and BI tooling.
• Proficiency with IBM Mainframe, Windows Server, SQL Server environments; COBOL/CICS/DB2 knowledge.
• Analytical, problem-solving and requirements gathering abilities.

Responsibilities

• Analyze and map field-level data from VSAM into relational and dimensional SQL structures.
• Support conversion, validation, and migration for Legacy Replacement initiatives.
• Profiling, cleansing, and documenting data quality rules with SMEs.
• Develop ETL processes and implement data quality validations and STTMs.
• Collaborate with IT partners to remediate data quality gaps and support ongoing improvements.
• Provide technical analysis for data integrity across data warehouses and marts.
• Create and maintain SQL/SRS reports to support business needs.

Skills

ETL data integration

SQL & stored procedures

Data profiling

VSAM to SQL mapping

COBOL & CICS

IBM DataStage

GIT version control

Pension administration systems

Data validation & STTM

Data warehousing concepts

SSRS report development

Mainframe/DB2/Windows Server

Data quality tools

Tools

IBM DataStage

GIT

BMC Control-M

SSRS

COBOL/CICS/DB2

Job description

UNIVERSAL Technologies LLC, based in Brooklyn, NY, seeks an experienced Senior Data Analyst with ETL expertise for a hybrid IT role. You will map VSAM files into SQL, perform metadata profiling, and contribute to an enterprise Legacy Replacement program.

The position requires 5+ years in data mapping with mainframe and relational DBs, IBM DataStage experience, and strong SQL/SSRS skills. Starts Jan 1, 2027.