Job #: 840

Title: Data Modeler – Whitehouse Station


  • Central New Jersey
  • Job Type:

  • Contract
  • Salary Range:
  • $100,000 to $125,000

  • Contract Pay Rate:
  • $50-75
    • Anywhere
    • Posted 2 years ago

    The role of the senior data modeler is to develop conceptual, logical and physical data models for data marts. This role will involve in establishing data modeling best practices and installing/administering a data modeling tool.

    · Communicate and collaborate with internal and external customers. Analyze/create requirements for incorporation into data models
    · Design and develop conceptual, logical and physical data models for data marts. Co-ordinate with DBA team for the physical implementation.
    · Responsible for establishing data modeling best practices. Implement and administer data modeling tool (Erwin)
    · In collaboration with other data modelers, helps to establish a Master data model for MDM implementation

    · Bachelor’s degree (or equivalent) in CS, IT or related field
    · 5-8 years of experience in data modeling for data marts using Erwin or similar tools
    · Experience in model creation for master data management (MDM) solution
    · Expertise in dimensional data modeling and sound knowledge of data warehouse concepts
    · Experience in installing and administering data modeling tools
    · Microsoft SQL Server current and past versions to 2008 proficiency and stored procedure and function development experience
    · Strong proficiency with SQL and experience with SQL query tuning and optimization
    · Experience with MS Azure Technologies
    · Database tuning experience
    · Ability to work in an agile environment
    · Knowledge to troubleshoot potential issues, and experience with best practices around database operations
    · Excellent written and oral communication skills, ability to articulate and document data models and related documentation
    · Working knowledge of ETL toolsets
    · Ability to work independently as well as collaboratively
    · Hands on experience on Big Data technologies and integrating it with Data Warehouse a plus

    Your Name*

    Your Email*

    Your Phone*

    Your Message

    Please attach your Resume*