> Markdown version of [/jobs/ext/3128311-data-analyst-etl-mainframe](https://www.wearedevelopers.com/jobs/ext/3128311-data-analyst-etl-mainframe). 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 (ETL, Mainframe) - **Company:** Spruce Technology Inc. - **Location:** New York, NY, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Customer Information Control System (CICS), COBOL (Programming Language), Data Dictionary, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Profiling, Data Structures, IBM DB2, Relational Databases, Database Queries, IBM InfoSphere DataStage, Distributed Data Store, Document-Oriented Databases, IBM Mainframe, Mainframes, Microsoft SQL Server, Windows Servers, Performance Tuning, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Virtual Storage Access Methods, Mainframe Programming, Git, Data Management, Control M - **Published:** September 28, 2026 - **Apply:** https://www.dice.com/job-detail/dab8f021-6622-465c-b8f7-83c103661255 ## About the Role + * 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. ## Description 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. ## 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) - [Grappling With Clunky Old Software? Start by Understanding What’s Inside!](https://www.wearedevelopers.com/videos/1189-grappling-with-clunky-old-software-start-by-understanding-what-s-inside) - [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) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Business Strategies for Scaling European Tech](https://www.wearedevelopers.com/videos/1694-business-strategies-for-scaling-european-tech) ## Related Articles - [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 the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [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) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)