Jobs
>
New York City

    Senior Data Analyst Hybrid - New York, United States - CyberTec

    Default job background
    Description

    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


  • Metergy Solutions LLC Long Island City, United States

    Job Title: Billing & Energy Analyst · FLSA Status: Non-Exempt · Department: Billing · Hybrid: ~2 days in office a week · **Summary**: Create and deliver a high volume of accurate and on-time monthly invoices to our submetering clients. · Duties and Responsibilities: · - Maintain ...


  • Citi Jersey City, United States

    The Cash & Trade Processing Associate Analyst is an entry level role responsible for assisting the function with any projects and initiatives related to cash management in coordination with the Transaction Services team. The overall objective is to facilitate multiple complex tra ...


  • Citi Jersey City, United States

    The Cash & Trade Proc Assoc Analyst 2 is an entry level role responsible for assisting the function with any projects and initiatives related to cash management in coordination with the Transaction Services team. The overall objective is to facilitate multiple complex transaction ...


  • The Jacobson Group New York, United States

    Job Description · Job DescriptionJoin a financial services industry leader · **6 month contract role** · Hybrid schedule: 3 days onsite, 2 days WFH · Job Summary: · Maintains information technology strategies by managing staff; researching and implementing technological strategi ...


  • Crossfire Consulting New York, United States

    Job Description: *PLEASE NOTE THIS POSITION WILL ALLOW CONSULTANT TO WORK REMOTELY. HOWEVER, DUTIES WILL REQUIRE CONSULTANT TO WORK ONSITE 3 DAYS PER WEEK. THEREFORE, WILL BE CRITICAL FOR THE CONSULTANT TO BE LOCAL TO NYC AND ABLE TO TRAVEL TO OUR OFFICE WITHOUT ISSUE, AS NEEDED ...


  • JVT Advisors New York, United States

    Full-time role with excellent benefits. 3 days a week on-site in NYC. · JOB SUMMARY: · The MicroStrategy Solutions Analyst will join a team of developers responsible for the firm's enterprise data warehouse, management reporting, and business intelligence solutions. Key initiati ...


  • 1836 Total Commerce New York, United States Permanent

    About Us · Founded in 2016, 1836 Total Commerce is more than just a consumer goods e-commerce company. Leveraging strategic manufacturing processes, we deliver top-tier, comfortable, and essential apparel to millions of consumers worldwide. · Our journey began seven years ago wi ...


  • Phaxis New York, United States

    HYBRID TEMP WORKDAY REPORTING ANALYST AT TOP NYC HEALTHCARE FIRM · Hourly Pay Rate is $59.50 to $64.50 | Temporary Assignment | MUST be Fully Vaccinated · Position Hybrid with Mixture of Home and In Office | Near Grand Central · Top NYC Healthcare firm is looking for an experie ...


  • Pyramid Consulting Group New York, United States

    Our client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of intel ...


  • Pyramid Consulting Group New York, United States

    Our client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of int ...


  • Pyramid Consulting Group, LLC New York, United States

    Our client, a wellness brand, is hiring a temp Senior Cyber Analyst to join their team in NYC on a hybrid schedule. This is a temp position that will begin in early May and continue for approximately 1 year. · Job Duties Include: · Conduct research and strategic analysis of intel ...


  • Columbia University New York, United States

    Job Type: Officer of Administration · Regular/Temporary: Regular · Hours Per Week: Full-time · Salary Range: $90,000-$100,000 · The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qual ...


  • Phaxis New York, United States

    Our direct client, a major hospital, is seeking a Human Capital Analyst for a immediate consulting engagement. This position is hybrid requiring 2-3 days onsite in midtown NYC, 2-3 days remote . The duration is 3 months plus extensions. · Compensation-$ $ 65.00 per hour W2. W2 on ...


  • Phaxis New York, United States

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


  • First Citizens Bank New York, NY, United States

    Overview · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, business ...


  • First Citizens Bancshares, Inc. New York, United States

    Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. First Citizens Bank helps p Office, Analyst, Client Suppo ...


  • First Citizens Bank New York, NY, United States

    Overview · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, business ...


  • First Citizens Bank New York, United States

    Overview: · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, busin ...


  • First Citizens Bank New York, United States

    Overview: · Together, Silicon Valley Bank and First Citizens offer you the strength and stability of a diversified financial institution with a 125-year tradition of service and the personalized approach of a nimble financial partner. · First Citizens Bank helps personal, busin ...


  • Masis Professional Group New York, United States

    MASIS Professional Group's Insurance Staffing Team has partnered with a Global Reinsurance organization to conduct a search for a Sr. Reinsurance Contract Analyst based in NYC. · Sr. Reinsurance Contract Analyst - Hybrid NYC · Since 1977 our client has delivered first class solut ...