Senior Data Analyst with ETL expertise

UNIVERSAL Technologies; New York (NY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Group Life Insurance

401(k)

HSA/FSA

PTO & Holidays

Job summary

UNIVERSAL Technologies, LLC is seeking an experienced Senior Data Analyst with ETL expertise for a hybrid role in Brooklyn, NY. The role focuses on detailed data analysis, metadata profiling, and mapping VSAM files into relational SQL structures as part of a Legacy Replacement program.

You will work in the IT Division with substantial exposure to COBOL, CICS, and DB2 environments, and will collaborate with SMEs to ensure data quality.

Qualifications

• Five+ years of source-to-target data mapping in mixed Mainframe and relational databases.
• Experience creating data dictionary documentation with business terms and values.
• Converting and migrating VSAM data into relational and dimensional SQL databases.
• Three+ years of ETL development using IBM DataStage.
• Extracting field references and calculated data from COBOL programs.
• Extracting business rules from legacy code.
• Experience with BMC Control-M workload automation.
• Experience with Git version control.
• Three+ years with Pension Administration systems.
• Experience in NY State or NYC pension environments.
• Strong SQL knowledge with complex queries and stored procedures.
• Developing SQL data validations from STTMs and target data models.
• Proficiency in SSRS report development.
• Experience with Data Quality and Data Profiling tools.
• Experience with Data Warehouses and Data Marts.
• Proficiency in IBM Mainframe, Windows Server, and SQL Server environments.
• Knowledge of COBOL, CICS, and DB2 on mainframe.
• Strong understanding of data structures and their ETL relationships.
• Strong analytical and problem-solving skills; effective requirements analysis.
• Excellent information gathering abilities.

Responsibilities

• Provide technical support for Data Profiling, Data Cleansing, Data Migration, and Validation in enterprise Legacy Replacement.
• Perform detailed field-level analysis, metadata analysis, profiling, and mapping of VSAM to SQL tables.
• Identify, inventory, and classify critical data assets.
• Collaborate with SMEs to document data quality rules and definitions.
• Support optimization and performance tuning of ETL and SQL processes.
• Transform legacy business rules into ETL/SQL specs.
• Develop complex SQL data validations based on STTMs and target models.
• Provide data integrity and quality support across initiatives.
• Work with IT partners to remediate data quality gaps using manual and automated methods.
• Assist in data conversion and validation for migrations from legacy environments.
• Support defect handling, troubleshooting, and issue resolution.
• Contribute to ongoing enterprise data management process improvements.

Skills

Data mapping

Data dictionary

COBOL data extraction

Business rules extraction

SQL queries

Analytical thinking

Troubleshooting

Data quality awareness

Data profiling concepts

Mainframe/ETL knowledge

Tools

IBM DataStage

BMC Control-M

Git

SSRS

Data profiling tools

Data warehousing tools

Job description

Career Opportunities with Universal Technologies

A great place to work.

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

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 tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program.

*** 3 days onsite in Brooklyn, NY.

***Expected to start Jan. 1, 2027.

WHO WE ARE

UNIVERSAL Technologies, LLC is a Women-Owned Business Enterprise (M/WBE) providing IT solutions and consulting services to government and private-sector clients. We deliver enterprise technology solutions across Application Development, Business/Systems/Data Analysis, Project Management, Cyber Security, Data Analytics, Infrastructure/Network Engineering, and High-Level Systems Architecture.

WHAT WE OFFER

As a W2 employee of UNIVERSAL Technologies, you may be eligible for:

• Competitive compensation
• Health, Dental, and Vision Insurance
• Group Life Insurance
• 401(k)
• HSA/FSA
• Generous PTO and Holiday Benefits

MANDATORY SKILLS/EXPERIENCE

• Minimum of five (5) years of source-to-target data mapping experience within mixed Mainframe and relational database environments.
• Experience creating data dictionary documentation including business terms, valid values, and definitions.
• Experience converting and migrating VSAM data into relational and dimensional SQL databases.
• Minimum of three (3) years of recent experience developing ETL applications using IBM DataStage.
• Experience extracting field references and calculated data from COBOL programs.
• Experience extracting business rules from existing legacy code.
• Experience with BMC Control-M workload automation software.
• Experience with GIT version control software.
• Minimum of three (3) years of recent experience working with Pension Administration systems.
• Prior experience working within a pension system, preferably a New York State or New York City pension environment.
• Strong SQL knowledge, including complex queries and stored procedures.
• Experience developing complex SQL data validations based on Source-to-Target Mapping documents (STTMs) and target data models.
• Proficiency in SQL Server Reporting Services (SSRS) report development.
• Experience with Data Quality and Data Profiling tools.
• Experience working with Data Warehouses and Data Marts.
• Proficiency working in IBM Mainframe, Windows Server, and SQL Server environments.
• Proficiency with mainframe applications and technologies including COBOL, CICS, and DB2.
• Strong understanding of data structures and their relationship to ETL applications.
• Strong analytical skills with the ability to receive and analyze requirements and propose appropriate solutions that align with established team methodologies.
• Excellent analytical, problem-solving, troubleshooting, and information-gathering skills.

SCOPE OF SERVICES

• Provide technical expertise supporting Data Profiling, Data Cleansing, Data Conversion, Data Migration, and Data Validation efforts for an enterprise-wide Legacy Replacement initiative.
• Perform detailed field-level analysis, metadata analysis, profiling, and mapping of VSAM files into relational and dimensional SQL tables.
• Participate in the identification, inventory, and classification of critical organizational data.
• Work with data Subject Matter Experts (SMEs) to document data quality rules and definitions.
• Participate in the optimization and performance tuning of existing ETL and SQL processes.
• Extract business rules from 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 for data integrity and data quality initiatives.
• Collaborate with SMEs and technical leads to identify and address data quality gaps.
• Work with IT partners to remediate identified data quality gaps using manual and automated solutions.
• Support processes designed to proactively detect, correct, and prevent invalid data values.
• Perform data conversion and validation activities supporting migration from legacy environments.
• Support defect handling, troubleshooting, and problem resolution.
• Contribute to ongoing process improvement initiatives related to enterprise data management.

UNIVERSAL Technologies is an equal opportunity employer.