Senior Data Analyst Hybrid

4 weeks ago

New York, United States CyberTec Full time

Job Title : Senior Data Analyst - Hybrid ( Only Local )
Location: Suite 2300 Brooklyn, NY,11201
Job Type : Hybrid
Duration : 72 months
Opening : 1 Opening

The Senior Data Analyst will primarily be responsible for detailed field level analysis, profiling, metadata analysis and mapping of the current IBM Mainframe VSAM files into relational/dimensional SQL tables, create and maintain the master data dictionary, assist in database design and mapping to NYCERS mission critical applications and inventory of its components.

The Senior Data Analyst shall provide NYCERS' Data Management with technical expertise for the completion of Data Quality, Data Profiling and Data Cleansing efforts part of Legacy Replacement initiative, as well as NYCERS' ongoing process improvement programs.

RESPONSIBILITIES

  • Participate in identification, inventory, and classification of NYCERS 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.
  • 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.
MANDATORY SKILLS

Note: Candidates who do not have the mandatory skills will not be considered
  • Minimum 5 years of source-to-target data mapping experience in a 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 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.
  • 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 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 the 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

    6 days ago

    New York, United States Center for Alternative Full time

    Job DescriptionJob DescriptionJob Title: Senior Data Analyst   Job Summary:    CASES is a New York City non-profit organization at the forefront of alternative to incarceration programs and comprehensive services for criminal justice-involved populations. If you are passionate about emerging data reporting and analysis techniques and take pride in your...

  • Senior Data Analyst

    2 weeks ago

    New York, United States Center for Alternative Full time

    Job DescriptionJob DescriptionJob Title: Senior Data Analyst   Job Summary:    CASES is a New York City non-profit organization at the forefront of alternative to incarceration programs and comprehensive services for criminal justice-involved populations. If you are passionate about emerging data reporting and analysis techniques and take pride in your...

  • Report Developer/Data Analyst-Hybrid/NYC

    2 weeks ago

    New York, United States Phaxis Full time

    Our direct client, a global banking organization is seeking a Data Analyst/Report Developer for a long-term consulting engagement. This position is hybrid, 3-4 days per week onsite in NYC, 1-2 days remote. Pay Rate: $55.00- $60.00 per hour W2., W2 only, no third parties please !! Must Haves: Minimum of 5 years’ experience in writing complex SQL queries...

  • Report Developer/Data Analyst-Hybrid/NYC

    2 weeks ago

    New York, United States Phaxis Full time

    Our direct client, a global banking organization is seeking a Data Analyst/Report Developer for a long-term consulting engagement. This position is hybrid, 3-4 days per week onsite in NYC, 1-2 days remote. Pay Rate: $55.00- $60.00 per hour W2., W2 only, no third parties please !! Must Haves: Minimum of 5 years’ experience in writing complex SQL queries...

  • Report Developer/Data Analyst-Hybrid/NYC

    2 weeks ago

    New York, United States Phaxis Full time

    Our direct client, a global banking organization is seeking a Data Analyst/Report Developer for a long-term consulting engagement. This position is hybrid, 3-4 days per week onsite in NYC, 1-2 days remote. Pay Rate: $55.00- $60.00 per hour W2., W2 only, no third parties please !! Must Haves: Minimum of 5 years’ experience in writing complex SQL queries...

  • Senior Data Analyst

    4 days ago

    New York, New York, United States Public Full time

    About PublicPublic is an investing platform that makes building a multi-asset portfolio fast, frictionless, and secure. Members can trade stocks, options, bonds, crypto, ETFs, and alternative assets—all in one place. Alongside its robust suite of investing tools, Public offers Alpha, a layer of artificial intelligence that provides fundamental data and...

  • Senior Healthcare Data Analyst

    1 week ago

    New York City, United States Government Systems Technologies Inc. (GSTi) Full time

    Role: Senior Healthcare Data AnalystLocation: NYC, NY (Hybrid Model)ContractJob Description: 12+ years of experience is required.Experience in data profiling, Strong experience in SQL analytic functions.Hands on experience in Writing SQL Procedures, Functions and View.Strong Knowledge in PostGres SQL Conncepts, experience in Postgres JSON management.Hands...

  • Senior Data Transformation Analyst

    1 week ago

    New York, United States Motion Recruitment Full time

    Grow your career with an innovative global bank as a Lead Business Intelligence & Automation Analyst with a focus in Lending Transformation. Contract role with strong possibility of extension or conversion to full-time employment. Will require working a hybrid schedule 2-3 days onsite per week. Join one of the world's most renowned global banks and trusted...

  • Senior Data Analyst, Marketing

    4 days ago

    New York, New York, United States Justworks Full time

    Who We AreAt Justworks, you'll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We work hard and care about our most prized asset - our people.We're helping businesses get off the ground by enabling them to focus on running...

  • Senior Data Transformation Analyst

    1 week ago

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

    Grow your career with an innovative global bank as a Lead Business Intelligence & Automation Analyst with a focus in Lending Transformation. Contract role with strong possibility of extension or conversion to full-time employment. Will require working a hybrid schedule 2-3 days onsite per week.Join one of the world's most renowned global banks and trusted...

  • Supply Chain Analyst

    2 days ago

    New Brunswick, United States Pioneer Data Systems Full time

    Our client, a world-leading Pharmaceutical Company in New Brunswick, NJ is currently looking for a Supply Chain Analyst to join their expanding team. Position Details: Job Title: Supply Chain Analyst / Pharma Industry / Hybrid Work Duration: 9 months contract, extendable up to 24 months Location: New Brunswick, NJ Hybrid: 3 days in office - Mon-Thu...

  • Data Analyst

    6 days ago

    New York, United States The Judge Group Full time

    The Judge Group is an international leader in business technology consulting, talent solutions, and learning and development. One of our top Financial Services clients is looking for a Data Analyst.Position: Data AnalystHours/Week: 40 Worksite type: Hybrid 3/week, NYCDuration of Assignment: 5 MonthsShift (Start/End Time): 8:30- 5 Overtime required? No Work...

  • Data Analyst

    7 days ago

    New York, United States The Judge Group Full time

    The Judge Group is an international leader in business technology consulting, talent solutions, and learning and development. One of our top Financial Services clients is looking for a Data Analyst.Position: Data AnalystHours/Week: 40 Worksite type: Hybrid 3/week, NYCDuration of Assignment: 5 MonthsShift (Start/End Time): 8:30- 5 Overtime required? No Work...

  • Product Data Analyst

    1 week ago

    New York, United States HireTalent - Diversity Staffing & Recruiting Firm Full time

    Title: Product Data AnalystPosition Type: Long-term ongoing contractLocation: Hybrid 1 day in office. New York, NY 10010. Client Online is seeking a Product Analyst with a passion for data and solutions. The primary role will be the data partner for agile teams to support the transformation from project-based to team-based funding towards Digital...

  • Product Data Analyst

    1 week ago

    New York, United States HireTalent - Diversity Staffing & Recruiting Firm Full time

    Title: Product Data AnalystPosition Type: Long-term ongoing contractLocation: Hybrid 1 day in office. New York, NY 10010. Client Online is seeking a Product Analyst with a passion for data and solutions. The primary role will be the data partner for agile teams to support the transformation from project-based to team-based funding towards Digital...

  • Product Data Analyst

    1 week ago

    New York, United States HireTalent - Diversity Staffing & Recruiting Firm Full time

    Title: Product Data AnalystPosition Type: Long-term ongoing contractLocation: Hybrid 1 day in office. New York, NY 10010. Client Online is seeking a Product Analyst with a passion for data and solutions. The primary role will be the data partner for agile teams to support the transformation from project-based to team-based funding towards Digital...

  • Supply Chain Analyst

    4 days ago

    New Brunswick, United States Pioneer Data Systems Inc Full time

    Our client, a world-leading Pharmaceutical Company in New Brunswick, NJ is currently looking for a Supply Chain Analyst to join their expanding team. Position Details: Job Title: Supply Chain Analyst / Pharma Industry / Hybrid Work Duration: 9 months contract, extendable up to 24 months Location: New Brunswick, NJ Hybrid: 3 days in office – Mon-Thu...

  • Data Analyst

    4 days ago

    New York, United States Atlas Search Full time

    We are working with a professional soccer league sanctioned by the US Soccer Federation. They are actively looking to hire a Data Analyst to join their Finance Department for a hybrid, contract assignment. The candidate in this role will review data based on parameters provided, conduct thorough analysis of large data sets, clean data within Excel and...

  • Data Analyst

    5 days ago

    New York, United States Infojini Inc Full time

    Below is the job description for the position:Position Title - Data AnalystLocation - New York City, NY 10007 (Hybrid work - 3 Days Onsite & 2 Days Remote)Duration- 6+ months (with possible extension)Working Hour- 35 Hours/WeekNEED LOCAL CANDIDATES ONLYDescription:Data Analyst/QA Specialist is responsible for performing data quality assurance; and role has...

  • Corporate Services Sourcing Data Analyst

    6 days ago

    New Brunswick, United States Corporate Services Sourcing Data Analyst Full time

    Nice to have Procurement or supply chain experience. Work location New Brunswick, NJ Hybrid-partial 3 days in office Mon-Thu ideal. Additional candidate qualities. Co-ops were great, positive and looking for future potential job/job reference. Great attitudes. Agile. Open to improvement & looking to be challenged. Specific previous experience isn't as...