Data Modeler

data, data modeler, data analyst, data architect, erwin, sql, database, analyst
Contract W2, Contract Independent, 5+ mos
$90 hr

Job Description

Data Modeler

ROLE LOCATION(S) Purchase, NY; New York, NY; Florham Park, NJ; Conshohocken, PA; Charlotte, NC
Partial Remote: Onsite Requirement Tuesday, Wednesday and Thursday of each week

ROLE SUMMARY AND RESPONSIBILITIES
The Data Modeler is responsible for defining and managing critical data structures for current and future needs. The primary responsibilities are to gather business requirements and translate them into logical data models, and to create technical design specifications including source to target mapping documentation for ETL developers.

ROLE RESPONSIBILITIES

  • Develop entity relationships (ER models) for normalized and dimensional models
  • Assist and guide existing Data Modelers and Data Architects
  • Technical evaluation for assignments involving existing models for legacy applications and creation of new model in support of application development
  • Work closely with the ETL, BI, DBA and other teams to develop appropriate data models
  • Participates in collaborative working environment using the agile methodology
  • Provide technical leadership and guidance to business partners, peers and vendor partners
  • Performs related duties as assigned or requested
REQUIRED TECHNICAL QUALIFICATIONS (in order of level of need)
  • 10+ years of BI/DW and data modeling experience
  • 5 years of P&C insurance business and systems such as Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD is a huge plus
  • Knowledge of Data Warehousing, ETL and BI architectures, concepts and frameworks
  • Deep knowledge of Kimball and Inmon approaches and the core differences
  • Experience in data modeling principles/methods including conceptual, logical & physical Data Models
  • Capable of facilitating data discovery sessions involving business subject matter experts
  • Experience in translating/mapping relational data models into Data Base Schemas
  • Experience with modeling tools (such as ERWin and ER/Studio)
  • Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL)
  • Ability to create and maintain conceptual/business, logical and physical data models
  • Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes
  • Experience maintaining a model repository
  • Ability to synchronize models to ensure that database structures match models
  • Familiar with metadata ingestion and translation
  • Strong interpersonal skills and ability to work as part of a team
EDUCATION REQUIREMENTS
  • BS in Computer Science, Information Management or Statistics

For more information please contact Brian Otten at or

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.

Dice Id : 10111560
Position Id : 21-26461
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Data Modeler
  • iTech Solutions
  • Florham Park, NJ, USA
Data Modeler
  • iTech Solutions
  • Harrison, NY, USA
Data Modeler
  • Stellar Consulting Solutions
  • New York, NY, USA
DATA ANALYST
  • AR Solutions, Inc.
  • Florham Park, NJ, USA
Data Analyst
  • iTech Solutions
  • Florham Park, NJ, USA
Data Analyst
  • iTech Solutions
  • Harrison, NY, USA
Data Analyst
  • APN Consulting Inc
  • Florham Park, NJ, USA
Data Analyst (Data Warehouse)
  • Birlasoft Solutions, Inc.
  • Harrison, NY, USA
Data Analyst - Insurance Industry Experience
  • MJP Associates
  • Morristown, NJ, USA
Data Analyst - Insurance Industry Experience
  • MJP Associates
  • White Plains, NY, USA