Senior Data Analyst
Expert In Recruitment Solutions
Job Description
Job Description
Title: Senior Data Analyst with IBM DataStage ETL Expertise
About the Role
Client is seeking a Senior Data Analyst with ETL Expertise to join its Data Management team within the Information Technology (IT) Division. This role is central to NYCERS' Legacy Replacement Program , a large-scale, enterprise-wide initiative to modernize mission-critical pension administration systems currently running on mainframe/VSAM architecture.
The successful candidate will provide hands-on technical expertise across the full data lifecycle — profiling, cleansing, conversion, migration, and validation — as legacy VSAM data is transformed into modern relational/dimensional SQL structures. This is a high-visibility role supporting both the Legacy Replacement effort and NYCERS' broader, ongoing process improvement programs.
What You'll Do
- Perform detailed field-level and metadata analysis of legacy VSAM files to support conversion into relational/dimensional SQL tables
- Conduct data profiling and source-to-target mapping across mixed Mainframe and Relational Database environments
- Build and maintain the organization's master data dictionary , including business terms, valid values, and definitions
- Support database design for NYCERS' mission-critical applications and maintain a component inventory
- Extract field references and calculated/derived data from COBOL programs to inform mapping and validation logic
- Develop and execute ETL pipelines using IBM DataStage to move and transform data between legacy and target systems
- Design and run complex SQL data validations based on Source-to-Target Mapping documents (STTMs) and target data models
- Collaborate with the Data Management team on process improvement initiatives beyond the core migration effort
- Develop reporting deliverables using SSRS
- Minimum 5 years of source-to-target data mapping experience spanning mixed Mainframe and Relational Database environments
- Experience creating data dictionary documentation (business terms, valid values, definitions)
- Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases
- Minimum 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
- Minimum 3 years of recent experience with Pension Administration systems
- Strong SQL skills, including complex queries and stored procedures
- Proficiency in SSRS report development
- Strong analytical skills — able to interpret requirements and propose solutions aligned with team methodology
- Ability to work across multiple environments: IBM Mainframe, Windows Server, and SQL Server
- Proficiency in mainframe technologies: COBOL, CICS, and DB2
- Solid understanding of data structures and their relationship to ETL processes
- Ability to build complex SQL-based data validations from STTMs and target data models
- Excellent analytical, problem-solving, and information-gathering skills, plus fundamental technical troubleshooting ability
- Experience extracting business rules from existing legacy code
- Experience with Data Quality / Data Profiling tools
- Experience with Data Warehouses / Data Marts
- Experience with SQL Server Reporting Services (SSRS)
- Prior experience in a pension system environment — New York State or New York City pension systems preferred
This is a hybrid position ; onsite presence is required at:
335 Adam Street, Suite 2300, Brooklyn, NY 11201
Submission Requirements
- Minimum of 3 professional references required at time of submission
- Candidate must clearly demonstrate alignment with all mandatory skills/experience listed above; submissions lacking evidence of mandatory qualifications may not be considered
Vacancy posted 21 days ago
Similar jobs that could be interesting for youBased on the Senior Data Analyst in New York, NY vacancy
$172.5k - $260.1k
...4/2026.What You'll Be Doing & Why It MattersThe Staff Product Data Analyst role is part of the Data & Insights team at Slack, which is part... ...through advanced analysis and implementation, and influence senior stakeholders with concise, executive-ready recommendations.Design...SeniorFull time- ...We are looking for an experienced Data Governance Analyst to lead enterprise-wide data governance initiatives, with a strong focus on Informatica Data Governance solutions . The ideal candidate will have hands-on expertise in Informatica EDC, CDGC, or Axon, along...SeniorFull time
- ...Position Summary The Senior Data Analyst will serve as the bridge between business stakeholders and the Enterprise Data team. This individual will transform data into actionable insights, define business metrics, ensure data quality, and help expand company's AI-ready...Senior
- RESPONSIBILITIES: Kforce has a client in Midtown Manhattan that is seeking a Senior Business Analyst to join an Enterprise Data Management team supporting a firm-wide data platform. This is a contract-to-hire opportunity with a mandatory hybrid schedule of 2 days per...SeniorHourly payContract work2 days per week
- ...About the job Senior Data Analyst The Role: As a senior data analyst, you'll work in a close-knit but high calibre team to deliver a range of high profile projects for clients. For instance, analysing exam data to understand student performance, often building...Senior
$25k
...technological savvy and fan-first attitude we're simplifying and modernizing the ticketing industry. We're looking for a Senior Data Analyst to join our Analytics team and focus on the supply side of SeatGeek's marketplace. You'll partner with stakeholders across the...SeniorWork at officeLocal areaRemote workWork from homeHome officeFlexible hoursShift work$124.9k - $167.4k
...Job Requirements SUMMARY The Disney DTC Sports & ESPN Analytics team is seeking a Senior Data Analyst who will be an exceptional addition to our team. You will be responsible for turning data into information, information into insights, and insights into key business...SeniorWork experience placement- ...have the freedom to explore ideas and impact the roadmap and vision of our company. About the Role Rain is hiring a Senior Product Data Analyst to be the analytical engine behind our product team. Payments and stablecoin infrastructure generate enormous, rich, and...SeniorFull timeLive inWork at officeWork from homeWorldwideFlexible hours
$27 per hour
HomeDepot in Atlanta, USA is seeking a Senior Data Analyst to join our analytics team to drive data-driven decisions. You will partner with engineers, product, and clients to define requirements and deliver analytics solutions. Responsibilities include programming in SQL...Senior$80k - $90k
...Senior Analyst, Omnichannel Data & Analytics MRM is part of the Omnicom Precision Marketing activation practice. This practice integrates CRM platform expertise, journey management, and first-party data capabilities with creative excellence and performance capabilities...Senior- ...explore ideas and impact the roadmap and vision of our company. About the Role Rain is building a modern data team from the ground up. This role is for a high agency analyst who ensures data is useful and adopted, not just available. You’ll own the tools and data that all...SeniorWork at officeWork from homeFlexible hours
- A leading data services company is seeking a Senior Data Analyst who will analyze and interpret data from various sources. The successful candidate will utilize statistical methods and create predictive models while working with large datasets. Qualifications include a...SeniorRemote workFlexible hours
- Nearform ищет опытного аналитика данных на контрактной основе в Польше. Ваша задача — анализировать крупные наборы данных, строить дашборды и визуализации через Tableau/Power BI/Looker, сотрудничать с кросс-функциональными командами и обеспечивать точность отчетности. Вы...Senior
- Genpact Ltd. is seeking a Senior Data Analyst to translate bold ideas into actionable insights. You will work across analytics, data quality, and reporting to support client needs with SQL and SAS expertise, Excel/PowerBI validation, and automation of reports. Join a fast...SeniorRemote job
- Navitus Health Solutions is seeking a Sr. Analyst, Data to join our team. The role focuses on leading cross-functional analytical projects, designing scalable data solutions, and partnering with stakeholders to deliver trusted insights. Strong SQL, SSMS, and Power BI skills...SeniorRemote job
- ...United Kingdom seeks an experienced Analytics Engineer to bridge Gecko telemetry and product strategy, building dashboards and auditing data collection to ensure high‑fidelity insights for leadership. You will sanitize telemetry streams, reduce bot contamination, and...SeniorRemote job
- CareSource Management Services seeks an FWA Payment Integrity Data Analyst III to develop, implement, and present in-depth analyses addressing Fraud, Waste and Abuse across multiple lines of business. You will lead analytic ideation, validate vendor results, and communicate...Senior
- Elanco is seeking a Senior Analyst for EKS Beef Operations. The role focuses on data strategy, quality, and governance to support farm-animal productivity and the Benchmark/Experior programs. You will partner with internal teams to optimize data flows and deliver actionable...SeniorRemote job
- Accenture Federal Services is seeking a data analyst/scientist to analyze large datasets, build dashboards, and deliver clear recommendations to stakeholders. The role covers data prep, SQL analysis, dashboard development, and reporting, with opportunities to apply predictive...Senior
- We are looking for seasoned Senior Data Technology Consultants to join our Databricks Data & AI Consulting Practice. You will own end-to-end Databricks initiatives. In pre-sales, you will design the Lakehouse and AI solution. After the win, you will lead strategic client...Senior
$116.38k - $138.41k
...and brokers to provide insurance solutions that enable businesses to manage risks with confidence. Job Description The Senior Data Analyst plays a critical role in advancing the organization's regulatory reporting, data quality, and analytical capabilities. This position...SeniorLocal area- IMPACT Initiatives seeks a Senior Data Analyst / Data Specialist to lead the mission's data team in Kampala, with travel to Addis Ababa as needed. The role focuses on planning, design, data collection, cleaning and analysis across multiple units, ensuring data quality and...Senior
$111.2k - $126.9k
...Senior Data Analyst - Enterprise Services At Capital One, data is at the center of everything we do. When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the relational...SeniorFull timePart timeWork at officeLocal area- Elanco seeks a Senior Analyst, EKS Beef Operations to drive data strategy, reporting, and platform development for beef operations. You will analyze complex biological data, ensure data quality, and collaborate with IT vendors and internal teams to deliver mobile and web...SeniorRemote job
- Kforce has a client in the Asset Management space, based in Midtown Manhattan, NY that is seeking a Senior Data Analyst to join an Enterprise Data Management team supporting a firm-wide data platform. This is a contract-to-hire opportunity with a mandatory hybrid schedule...SeniorContract workTemporary work3 days per week
£58.5k - £78k per year
...and real-world user behavior. We currently face challenges with data quality, such as bot contamination in nightly telemetry, which obscures... ...our understanding of true performance trends. A dedicated analyst is required to bridge the gap between engineering telemetry and...SeniorContract workRemote workShift workNight shift- ...year, millions of animals enter shelters across the United States -- and the data behind their stories has the power to transform how shelters and communities care for them. As Senior Data Analyst at Shelter Animals Count (a Program of the ASPCA), you'll be at the center...SeniorFor contractorsWork experience placementSeasonal workRemote workWork from homeMonday to FridayFlexible hoursWeekend workAfternoon shiftEarly shift
- The Kraft Heinz Company is seeking a Sr Analyst, Strategic Planning & Insights to own and integrate large datasets, model retail problems... .... You will collaborate with business leadership, CAP teams, and data engineers to translate metrics into scalable data assets and...Senior
- Circana is seeking a Client Insights Sr. Analyst II to collaborate with client partners, translate data into insights, and drive growth for a CP G client base. This... ...’s data platforms and tailored analytics. As a senior contributor, you will engage with stakeholders, apply...SeniorRemote job
$70k - $85k
A consulting firm in the United States seeks an Insights & Consulting role focusing on data analysis and storytelling. The position requires a Bachelor’s degree and at least 2 years of relevant experience, with strong analytical skills and proficiency in tools like SPSS...SeniorRemote job
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Analyst. Be the first to apply!
Related searches
- neuroscience data analyst New York, NY
- data center analyst New York, NY
- talent data analyst New York, NY
- virtual data analyst New York, NY
- data analyst internship New York, NY
- healthcare data analyst New York, NY
- remote data analyst New York, NY
- data protection analyst New York, NY
- data analyst supply chain analytics New York, NY
- information risk analyst New York, NY




