Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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
Required Qualifications (Mandatory)
  • 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
Required Technical Ability
  • 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
Desirable Qualifications
  • 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
Work Location & Schedule
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... 
    Senior
    Full time

    Salesforce

    New York, NY
    1 day ago
  •  ...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... 
    Senior
    Full time

    Artiminds

    New York, NY
    14 hours ago
  •  ...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

    ASB Resources

    New York, NY
    26 days ago
  • 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... 
    Senior
    Hourly pay
    Contract work
    2 days per week

    Kforce Technology Staffing

    New York, NY
    2 days ago
  •  ...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

    Online Remote Jobs

    New York, NY
    3 hours ago
  • $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... 
    Senior
    Work at office
    Local area
    Remote work
    Work from home
    Home office
    Flexible hours
    Shift work

    SeatGeek

    New York, NY
    14 hours ago
  • $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... 
    Senior
    Work experience placement

    Disney Entertainment and ESPN Product & Technology Careers

    New York, NY
    12 days ago
  •  ...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... 
    Senior
    Full time
    Live in
    Work at office
    Work from home
    Worldwide
    Flexible hours

    rain

    New York, NY
    4 days ago
  • $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

    MaziCTools

    New York, NY
    1 day ago
  • $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

    Portland Communications

    New York, NY
    1 day ago
  •  ...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... 
    Senior
    Work at office
    Work from home
    Flexible hours

    Crypto Pro Network

    New York, NY
    3 hours ago
  • 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... 
    Senior
    Remote work
    Flexible hours

    Remote Career

    New York, NY
    14 hours ago
  • Nearform ищет опытного аналитика данных на контрактной основе в Польше. Ваша задача — анализировать крупные наборы данных, строить дашборды и визуализации через Tableau/Power BI/Looker, сотрудничать с кросс-функциональными командами и обеспечивать точность отчетности. Вы...
    Senior

    Nearform

    New York, NY
    1 day ago
  • 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... 
    Senior
    Remote job

    Genpact

    New York, NY
    14 hours ago
  • 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... 
    Senior
    Remote job

    Navitus Health Solutions

    New York, NY
    3 days ago
  •  ...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... 
    Senior
    Remote job

    Mozilla

    New York, NY
    14 hours ago
  • 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

    CareSource Management Services

    New York, NY
    14 hours ago
  • 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... 
    Senior
    Remote job

    US01 Elanco US Inc.

    New York, NY
    14 hours ago
  • 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

    accenturefederalservices

    New York, NY
    1 day ago
  • 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

    EPAM Systems

    New York, NY
    4 days ago
  • $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... 
    Senior
    Local area

    Argo Corporation

    New York, NY
    2 days ago
  • 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

    Impact Initiatives Inc.

    New York, NY
    1 day ago
  • $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... 
    Senior
    Full time
    Part time
    Work at office
    Local area

    Capital One

    New York, NY
    2 days ago
  • 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... 
    Senior
    Remote job

    Elanco

    New York, NY
    2 days ago
  • 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... 
    Senior
    Contract work
    Temporary work
    3 days per week
    New York, NY
    6 days ago
  • £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... 
    Senior
    Contract work
    Remote work
    Shift work
    Night shift

    Mozilla

    New York, NY
    14 hours ago
  •  ...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... 
    Senior
    For contractors
    Work experience placement
    Seasonal work
    Remote work
    Work from home
    Monday to Friday
    Flexible hours
    Weekend work
    Afternoon shift
    Early shift

    Remote Jobs

    New York, NY
    3 hours ago
  • 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

    The Kraft Heinz Company

    New York, NY
    14 hours ago
  • 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... 
    Senior
    Remote job

    Circana

    New York, NY
    2 days ago
  • $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... 
    Senior
    Remote job

    Escalent

    New York, NY
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Data Analyst. Be the first to apply!