Job Details

ID #41298679
State Pennsylvania
City Conshohocken
Job type Contract
Salary USD $90 hr 90 hr
Source iTech Solutions
Showed 2022-05-21
Date 2022-05-20
Deadline 2022-07-19
Category Et cetera
Create resume

Data Modeler

Pennsylvania, Conshohocken, 19428 Conshohocken USA

Vacancy expired!

Data ModelerROLE LOCATION(S) Purchase, NY; New York, NY; Florham Park, NJ; Conshohocken, PA; Charlotte, NCPartial Remote: Onsite Requirement Tuesday, Wednesday, Thursday of each week in one of the office locations above. ROLE SUMMARY AND RESPONSIBILITIESThe 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.

Vacancy expired!

Subscribe Report job