Senior Data Analyst Hybrid

3 days ago


New York, New York, United States CyberTec Full time
Job Summary

The Senior Data Analyst will be responsible for detailed field-level analysis, profiling, and metadata analysis of IBM Mainframe VSAM files. They will create and maintain the master data dictionary, assist in database design, and map data to NYCERS' mission-critical applications.

Key Responsibilities

Participate in the identification, inventory, and classification of NYCERS' critical data.
Work with data SMEs to document data quality rules and definitions.
Actively 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.
Provide technical and analytical support to NYCERS' data integrity and quality initiatives.
Collaborate with SMEs 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.

Requirements

Minimum 5 years of source-to-target data mapping experience in mixed Mainframe and Relational Database environments.
Hands-on IBM DataStage ETL administration experience in Windows environments.
Hands-on experience with SQL Server Reporting Services (SSRS) platform.
Hands-on experience with IBM RAA (Rational Asset Analyzer).
Experience creating data dictionary documentation with business terms, valid values, and 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 software, Build, and CICD pipeline automation.
Minimum 3 years of recent experience with Pension Administration systems.
Excellent analytical, problem-solving, and information gathering skills along with fundamental technique troubleshooting abilities.
Strong SQL knowledge working with complex queries and stored procedures.
Proficiency in LINUX/UNIX Shell scripting, C#, and VB.NET.
Proficiency in SSRS reports' development and administration.
Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server.
Proficiency in mainframe applications encompassing COBOL and CICS.
Proficiency creating Control-M Jobs, Smart Folders, Schedules with complex interdependencies.
Understanding of data structures and their relationship to ETL applications.

Preferred Skills

Experience extracting business rules from existing legacy code.
Experience with Data Quality/Profiling tools.
Experience with Data Warehouses/Data Marts.
Experience with SQL Server Integration Services (SSIS).
Prior experience working in a pension system, preferably New York State or New York City pension system.

  • New York, New York, United States Hybrid Full time

    About HybridHybrid is a full-service media and creative agency in the heart of Philadelphia. We turn ideas into actionable insights and drive impactful results for our clients. Through a seamless combination of data, leading tech, and unique creativity, our digital teams drive business performance and long-term growth for our clients.Job SummaryWe are...


  • New York, New York, United States Motion Recruitment Full time

    Senior Data Business AnalystGrow your career in a dynamic and innovative global bank in New York, NY as a Senior Data Business Analyst with extensive Regulatory experience. This contract role offers a strong possibility of extension and requires working a hybrid schedule 2-3 days onsite per week.About the RoleJoin one of the world's most renowned global...


  • New York, New York, United States Saxon Global Full time

    Role:As a Senior Business Data Analyst at Saxon Global, you will be responsible for analyzing and interpreting complex data to inform business decisions. This role requires strong investment banking domain experience and a solid understanding of data mart and data warehouse projects.Location:NYC NY (3 days hybrid from day 1)Client:JefferiesDomain:Investment...


  • New York, New York, United States PitchBook Data Full time

    About the RolePitchBook Data is seeking a highly skilled Associate Data Analyst to join our Editorial team. As a key member of our team, you will play a critical role in helping our customers make informed investment decisions by providing accurate and timely data insights.The ideal candidate will have a strong background in finance, economics, or...


  • New York, New York, United States Motion Recruitment Full time

    Senior Data Business AnalystGrow your career in a dynamic and innovative global bank in New York, NY as a Senior Data Business Analyst with extensive Regulatory experience. This contract role offers a strong possibility of extension and requires working a hybrid schedule with 2-3 days onsite per week.Key ResponsibilitiesProvide in-depth and sophisticated...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Apex Systems, Inc. Full time

    Job Title: Senior Data AnalystApex Systems, Inc. is seeking a highly skilled Senior Data Analyst to join our team. As a Senior Data Analyst, you will play a critical role in supporting the successful completion of OS upgrades and migrations at a leading financial services client in New York City.Key Responsibilities:Assist with OS upgrades and migrations,...


  • New York, New York, United States Good Inside Full time

    The OpportunityGood Inside is seeking a skilled Senior Data Analyst, Product & Marketing Insights to drive business growth and product improvements through data-driven insights.This is a hybrid role based in Manhattan with three days onsite, requiring collaboration across teams to drive real-world impact.The ideal candidate will have 5+ years of experience...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Citigroup Full time

    Job Title: Senior Data AnalystJoin Citigroup as a Senior Data Analyst and play a vital role in designing, developing, and deploying large-scale data solutions that fortify our firm's risk management strategies.Job Summary:We are seeking a highly skilled Senior Data Analyst to join our Portfolio Management Analytics – Data & Platform team within the global...

  • Senior Data Analyst

    3 days ago


    New York, New York, United States 1stDibs Full time

    Senior Data AnalystAt 1stDibs, we're seeking a Senior Data Analyst to join our team. As a Senior Data Analyst, you will be responsible for leading analytics projects that solve business problems, mining and synthesizing data from multiple sources, and developing predictive models.Key Responsibilities:Partner with stakeholders across various business...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States CircleCo Inc. Full time

    About CircleCo Inc.CircleCo Inc. is a pioneering company that is revolutionizing the way communities come together. Our mission is to create a platform that enables creators, coaches, educators, and businesses to build and engage with their audience in a seamless and immersive experience.About the RoleWe are seeking a highly skilled Senior Data Analyst to...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Zenith Full time

    Job Title: Senior Analyst, AnalyticsJob SummaryZenith is a leading media agency seeking a skilled Senior Analyst to join our Analytics team. As a key member of our team, you will be responsible for analyzing complex data sets, identifying trends, and developing insights to drive business growth.Key ResponsibilitiesAnalyze large data sets to identify trends...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Zenith Full time

    Job Title: Senior Analyst, AnalyticsAt Zenith, we're seeking a highly skilled Senior Analyst to join our Analytics team. As a key member of our team, you'll play a critical role in driving business outcomes through data-driven insights.About the RoleThe Senior Analyst will be responsible for designing and implementing data strategies to tie our clients'...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States V-Soft Consulting Group Full time

    Job Title: Senior Data AnalystWe are seeking a highly skilled Senior Data Analyst to join our team at V-Soft Consulting Group. As a Senior Data Analyst, you will be responsible for building, updating, and monitoring data warehouse and business systems performances to maintain integrity.Key Responsibilities:Builds, updates, and monitors data warehouse and...

  • Senior Data Analyst

    3 days ago


    New York, New York, United States Traba Full time

    Job Title: Senior Data AnalystAt Traba, we're revolutionizing the staffing industry through a marketplace that connects businesses with reliable talent. As a Senior Data Analyst, you'll play a pivotal role in shaping our company's strategy through data-driven insights.Responsibilities:Develop and execute business intelligence strategies aligned with company...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States King Games Full time

    About King GamesKing Games is a leading developer of mobile games, with a portfolio of iconic franchises such as Candy Crush and a strong presence in the gaming industry. Our mission is to create engaging and addictive games that bring joy to millions of players worldwide.Job DescriptionWe are seeking a highly skilled Senior Data Analyst to join our team. As...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States The Mice Groups Full time

    Senior Data AnalystWe are seeking a highly skilled Senior Data Analyst to join our Technology team at The Mice Groups. In this role, you will leverage your expertise in data manipulation and visualization tools to support the development and implementation of data-driven solutions for Investment Management.Key Responsibilities:Partner with business...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States Jiffy Limited Full time

    Senior Data AnalystJiffy Limited is seeking a highly skilled Senior Data Analyst to play a critical role in analyzing and interpreting large-scale data sets related to our customer base, payment systems, pricing, logistics, and customer cohorts.Key Responsibilities:Conduct in-depth data analysis to identify trends, patterns, and anomalies in large...

  • Senior Data Analyst

    2 weeks ago


    New York, New York, United States Traba Full time

    Job Title: Senior Data AnalystTraba is a technology company revolutionizing the staffing industry through a marketplace connecting businesses with reliable talent. As a Senior Data Analyst, you will play a pivotal role in shaping our company's strategy through data-driven insights.Responsibilities:Develop and execute business intelligence strategies aligned...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Spark Foundry Full time

    Job Title: Senior Analyst, Data and DMP, Client StrategyAt Spark Foundry, we're seeking a highly skilled Senior Analyst to join our team. As a key member of our data-driven Digital Marketing team, you'll be responsible for developing and implementing data strategies that drive business growth and customer engagement.Key Responsibilities:Develop and execute...

  • Senior Data Analyst

    2 weeks ago


    New York, New York, United States Zenith Full time

    Job Title: Senior Analyst, AnalyticsJob SummaryZenith is a leading media agency seeking a skilled Senior Analyst to join our Analytics team. As a key member of our team, you will be responsible for pulling and arranging data from various sources to provide business-improving insights to our clients.Key ResponsibilitiesPull and arrange data from multiple...