Data Modeler - Long Island City, NY - Georgia IT Inc.

Data Modeler
Location: Long Island City, NY
Duration: Full time
Salary plus benefits

U.S Citizens, GC holders preferred and no third party C2C agencies
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
Required 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 DDL