Exl Service

  • Data Modeler

    Job Location US-NY-New York
    ID
    2018-6007
    Group
    EXL Consulting
    Type
    Contractor / Temps on Agency Payroll
  • Overview

    Candidate will be a senior Data Modeler for a new Vendor Management System. The  Vendor Management System  will serve as a repository for the firm’s  vendor information and is considered a crucial application in the  Spend Management space.

    This system will be used as central inventory for vendor /third parties information sourced from various systems like Ariba, APDM etc. the system will consolidate vendor/third party related data according to VMO( vendor management office ) requirements.
    This is a state of the art Greenfield development that starts with a tactical phase, leading to a multi year strategic implementation.

     

    The Senior Data Modeler is responsible for Logical and Physical Modeling in Power Designer/Erwin for a highly scalable data warehouse. Understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers and DBA teams.



     

    Responsibilities

    • Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
    • Analyze source system data using profiling tools.
    • Capability to design models for OLTP and Dimensional modelling
    • Interacts with OLTP systems and translate relational models into dimensional models.
    • Maintains Data Model repository.
    • Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
    • Executes and provides feedback for data modeling policies, procedure, processes and standards.
    • Evaluates Database and data and develop the data model appropriately
    • Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
    • Design data models in Data Modeling in Power Designer

     

    Qualifications

     

    • 10+ years of data modeling experience;
    • Database experience in DB2 preferred
    • Power Designer is a must
    • Ability to develop stored procedures and SQL scripts as required
    • Any Informatica skills a plus
    • Experience with unit testing, release procedures, coding design and documentation protocol;
    • Knowledge of IT fields and computer systems;
    • Understanding of the systems development life cycle;
    • Ability to manage tasks independently.
    • Knowledge of basic Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria.
    • Experience with an Agile Tool, specifically JIRA is a plus
    • Previous Morgan Stanley experience a Plus.

     

    EEO Statement

    EEO/Minorities/Females/Vets/Disabilities

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed