Senior Data Analyst Hybrid

3 weeks 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 current IBM Mainframe VSAM files. They will create and maintain the master data dictionary, assist in database design, and map to NYCERS mission-critical applications and inventory of its components.

Key Responsibilities

Participate in identification, inventory, and classification of NYCERS critical data.
Work with data SMEs to document data quality rules and definitions.
Actively participate in 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 environment.
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 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
  • Senior Data Analyst

    3 weeks ago


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

    Job Title: Senior Data AnalystAt Saxon Global, we are seeking a highly skilled Senior Data Analyst to join our team. As a Senior Data Analyst, you will be responsible for analyzing and interpreting complex data to inform business decisions.Key Responsibilities:* Develop and maintain advanced data visualizations and dashboards using Tableau and Power BI*...


  • 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...


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

    Job SummaryThe 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,...

  • Senior Data Analyst

    4 weeks 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

    4 weeks 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 Grid Dynamics Full time

    About the Role:We are seeking a highly skilled Senior Data Analyst to join our team at Grid Dynamics. As a Senior Data Analyst, you will be responsible for data quality root cause & impact analysis, data validations, and data profiling for analytics engineering projects.The ideal candidate will have excellent analytical and problem-solving skills, with...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States RemoteOnline Full time

    About the RoleWe are seeking a highly skilled Senior Data Analyst to join our team at RemoteOnline. As a Senior Data Analyst, you will play a key role in analyzing systems, gathering insights on data usage, and designing information flows from source systems to the data lake.Key ResponsibilitiesDesign and build a holistic data management frameworkDefine data...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States Con Edison Full time

    **Job Summary**We are seeking a highly skilled Senior Data Analyst to join our team at Con Edison. As a Senior Data Analyst, you will be responsible for analyzing complex data sets, identifying trends, and developing insights to inform business decisions.Key Responsibilities:Analyzing large data sets to identify trends and patternsDeveloping and maintaining...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Pyramid Consulting, Inc Full time

    Job Title: Senior Data AnalystJob Description:We are seeking a highly skilled Senior Data Analyst to join our team at Pyramid Consulting, Inc. The ideal candidate will have a strong background in data analysis, machine learning, and programming, with experience working with large datasets.Key Responsibilities:Design, develop, and evaluate predictive models...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States PACO Group Full time

    Job Title: Senior Data AnalystPACO Group is seeking a highly skilled Senior Data Analyst to support the Project Controls Unit with the Port Authority of New York and New Jersey (PANYNJ). The ideal candidate will have demonstrated experience in conducting quantitative, statistical, and qualitative analyses within the transportation sector.The successful...

  • Senior Vendor Analyst

    4 weeks ago


    New York, New York, United States Solugenix Corp Full time

    Senior Vendor Analyst OpportunitySolugenix Corp is assisting a prestigious investment management company in their search for a Senior Vendor Analyst.This is a 6-month contract opportunity based out of Irvine, CA/San Antonio, TX/New York, NY (Hybrid).Key Responsibilities:Provide support to management through data consolidation, data analysis, and management...

  • Senior Data Analyst

    4 weeks ago


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

    Job Title: Senior Data AnalystJob Summary:Apex Systems is seeking a Senior Data Analyst to assist with OS upgrades at the Bank. This role is key to timely and successful completion of In-place upgrades and VDS upgrades to Windows 11 in 2024 leading into 2025.Responsibilities:Preparing refresh into Waves and sprints by LOB and site and achieving...

  • Senior Data Analyst

    3 weeks ago


    New York, New York, United States Maven Clinic Full time

    Maven Clinic is seeking a highly skilled Senior Data Analyst to join our Business Intelligence team. As a key member of our team, you will be responsible for designing and developing data structures from internal and external sources to support business insights and decision-making.With a strong background in data visualization and experience with SQL and...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States Maven Clinic Full time

    About the RoleMaven Clinic is seeking an experienced Senior Data Analyst to join our Business Intelligence team. As a key partner in the design, development, and maintenance of highly scalable data and reporting models, you will enable key cross-functional teams to report on critical business metrics independently.You will work closely with our Client...


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

    Job SummaryKBRA Analytics is seeking a highly skilled Senior Financial Data Analyst to join our team. The successful candidate will be responsible for ingesting, curating, and managing U.S. GAAP financial data for our KFI product. This will involve monitoring industry events, executing projects to improve data timeliness, accuracy, and quality, and providing...


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

    Job SummaryKBR Analytics is seeking a Senior Financial Data Analyst to join our team. The successful candidate will be responsible for ingesting, curating, and managing U.S. GAAP financial data for our KFI product.Key ResponsibilitiesExtract and standardize XBRL data from SEC financial filings to KBRA financial statement taxonomiesPerform data quality...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States GroupM Choreograph Full time

    About the RoleThe Senior Analyst is a key member of our team at GroupM Choreograph, responsible for providing analytical support to clients across various industries. This role requires a strong analytical mindset, excellent communication skills, and the ability to work independently with minimal guidance.Key ResponsibilitiesProvide data-driven insights to...


  • New York, New York, United States Diverse Lynx Full time

    Job Title: Senior Data Analyst LeadJob Summary: We are seeking a skilled Senior Data Analyst Lead to manage a critical project for one of our biggest clients in the insurance domain.The ideal candidate will have a passion for technology, experience in developing and managing cutting-edge technology applications, and a strong background in data analysis and...

  • Data Analyst

    4 weeks ago


    New York, New York, United States A1 Works in Progress Associates, LLC Full time

    Job Title: Data AnalystWPA is seeking a Data Analyst to support our team in analyzing and interpreting transportation data. The ideal candidate will have a strong background in statistics and economics, with experience in data analysis and visualization tools such as Excel and Power BI.Key Responsibilities:Analyze and interpret transportation data to inform...

  • Senior Data Analyst

    4 weeks ago


    New York, New York, United States City National Bank Full time

    Job SummaryWe are seeking a highly skilled Senior Data Analyst to join our team at City National Bank. As a Senior Data Analyst, you will play a critical role in executing a successful data initiative implementation across target areas. This will involve operationalizing data domains, data automation tools, data sourcing, aggregation, and integration for...