Data Modeler

East West Systems Inc
Fairfield, NJ
Full-time

Requirements :

  • Responsible for the development of conceptual, logical and physical data models, the implementation of RDBMS, operational data store, data marts and data lakes on target platforms.
  • Analyze user requirements and define functional specifications.
  • Understand production state of application to determine impact of new implementation on business processes.
  • Review the process structure to determine elements that affect business development and performance.
  • Create data model for optimal performance. Build new data model for multiple data sources.
  • Prepare Erwin data model template for Postgres, Dynamo DB on cloud environment. Prepare mapping documents and project documents.
  • Maintain data model. Propose outline of project improvement by performance tuning.
  • Propose ideas for implementation of new technology by analyzing, exploring and measuring project output value.
  • Identify the architecture, infrastructure and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
  • Create DDL to install new and updated objects in the database.
  • Coordinate with team members on progress of DDL execution. Ensure the database implementation activities are completed within timeline.
  • Meet with stakeholders to normalize database and improve overall performance of the application and database environment.
  • Bachelor’s degree or equivalent in Computer Science, Applied Mathematics, Electronics Engineering or related field of Engineering with 5 years of progressive experience or Master’s degree with 3 years of experience
  • Must have experience in Oracle, MySQL, SQL Server, Postgres, Hadoop, Erwin, Power BI, Toad, SQL Server Management Studio, SQL Workbench, Dbeaver.
  • This position is eligible for the employee referral program.
  • 30+ days ago
Related jobs
Promoted
Virtusa
Rutherford, New Jersey

Strong Database and Data Modeler experience. ETL Data modeler with Ab Initio. IT experience and exposure to tools ETL/Data warehousing technology (Experience in Ab Initio technologies including, but not limited to Ab Initio graph development, EME, Co-Op, BRE, Continuous flow/Talend). ...

Promoted
LTI - Larsen & Toubro Infotech
NJ, United States

The position is within ICG Technology, and we are seeking a Data Modeler with strong hands-on experience in developing Conceptual, Logical and Physical Data Model for Wholesale Lending. Determine database structural requirements by analyzing client operations, applications and data from existing sys...

Promoted
Virtusa
Rutherford, New Jersey

Strong Database and Data Modeler experience. ETL Data modeler with Ab Initio. IT experience and exposure to tools ETL/Data warehousing technology (Experience in Ab Initio technologies including, but not limited to Ab Initio graph development, EME, Co-Op, BRE, Continuous flow/Talend). ...

Promoted
eTeam
Jersey City, New Jersey

Must have strong experience in Data Analysis in an enterprise DWH environment. Strong analyst background in data-oriented applications. Knowledge of Mortgage Insurance Industry must be able to understand P&C data. ...

Promoted
Crescens
Jersey City, New Jersey

Creates logical data models adhering to the best practices, data modelling standards and architectural principles. Data Lake/ Data warehouse experience. CDM Canonical Data Model exp is must ***. Strong Data modeller with experience in Azure Synapse. ...

Promoted
4 Staffing Corp
Newark, New Jersey

The ideal candidate will have a strong background in data modeling and database design, particularly in relational and non-relational databases within the financial industry. Build catalogues, business terms, technical metadata, and data lineage for effective data management. Experience with Data Go...

ITech Recruiting
Jersey City, New Jersey

Demonstrate knowledge of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, & end-user tools • Proficient in 3rd normal form relational modeling and/or dimensional modeling fo...

East West Systems Inc
Fairfield, New Jersey

Responsible for the development of conceptual, logical and physical data models, the implementation of RDBMS, operational data store, data marts and data lakes on target platforms. Identify the architecture, infrastructure and interfaces to data sources, tools supporting automated data loads, securi...

tekHouse
Bayonne, New Jersey

Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models. Responsible for the ...

Lorven Technologies
Jersey City, New Jersey

Perform data mapping based on data source schemas and reverse engineering of existing transformations from multiple source database systems on cloud data platform to meet the corporate standards. Develop and maintain conceptual, logical, and physical data models with its corresponding metadata. Perf...