Job Description :
Job Title: Data Modeler
Job location: Long Island, NY
Job Duration: Full Time Project

Technical/Functional Skills:
Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
Analyze source system data using profiling tools.
Designs dimensional data models for Highly scalable data warehouse.
Interacts with OLTP systems and translated 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 tools (ER Studio)
Knowledge of RDBMS platforms (e.g. SQL Server, Oracle, DB2 / UDB, NoSQL, MongoDB, Hadoop) with experience in generating DD
Roles & Responsibilities:
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