> Markdown version of [/jobs/ext/3122162-data-analyst](https://www.wearedevelopers.com/jobs/ext/3122162-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** UNIVERSAL Technologies, LLC - **Location:** New York, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Customer Information Control System (CICS), COBOL (Programming Language), Data Validation, Data Cleansing, Data Conversion, Data Dictionary, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Mart, Data Migration, Data Profiling, Data Structures, Data Warehousing, IBM DB2, Relational Databases, Database Queries, IBM InfoSphere DataStage, Document-Oriented Databases, IBM Mainframe, Mainframes, Microsoft SQL Server, Windows Servers, Performance Tuning, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Virtual Storage Access Methods, Enterprise Data Management, Mainframe Programming, Git, Information Technology, Control M - **Published:** September 28, 2026 - **Apply:** https://www.dice.com/job-detail/faaee97a-102e-45a2-8567-a6bd44a1bd30 ## About the Role * 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. ## Description 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., * 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. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Business Strategies for Scaling European Tech](https://www.wearedevelopers.com/videos/1694-business-strategies-for-scaling-european-tech) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)