Data Modeler

7 days ago


Summit, NJ, United States RIT Solutions, Inc. Full time
Job Title: Data Modeler
Location: Richmond, VA or Dallas, TX (Hybrid)
Duration: 6-month contract to hire with FTE potential

Overview: This group is migrating data from on-prem to cloud environments, has different data domains (i.e. sales, finance, marketing) and need to build comprehensive, enterprise data model to incorporate all that can be put into semantic reporting layer. Immediate goal is to build a few data models, starting with logical/conceptual and moving into physical, that can demonstrate value to business stakeholders. Room to scale the team to incorporate more Senior Modelers and BA resources.
  • Need experience in Erwin, DBT, or other tools to create logical and physical data models.
  • Define requirements with the business around reporting needs, building out data models around them, and tracing back data availability from their Oracle, Snowflake, and Databricks sources.
  • Apply dimensional and data vault modeling techniques.
  • Collaborate with data architects and solution architects to ensure best practices in data modeling. Existing Data Architect will be primary POC and support on this role.
  • Develop data models for data sources primarily in Oracle, transitioning to Snowflake and Databricks (majority curated data in Databricks).
  • Assist with create and maintenance of existing lineage documentation, tracking, source to target mapping, and data dictionaries.
  • Use Draw.io or Miro for conceptual data modeling--physical modeling tools still in discussion.
  • Implement snapshots and manage slowly changing dimensions Type 1, 2 mostly.
  • Ensure compliance with data governance practices, though immediate collaboration is not required.

Requirements:
  • Proficiency in data modeling using tools like Erwin, DBT, etc.
  • Strong understanding of data vault concepts and warehousing environments.
  • Familiarity with RDBMS, Snowflake, and Databricks or other warehousing
  • Experience with normalization and denormalization techniques.
  • Ability to create logical and physical data models and DDLs.
  • Knowledge of data lineage and data governance practices.
  • Experience with tools like Draw.io and Miro for logical data modeling preferred


  • Summit, NJ, United States ShiftCode Analytics Full time

    Interview: Onsite (F2F) Visa: USC, GC, GC EAD and H4 EAD Hybrid: Summit, NJ Some with the MMM Marketing Mix Modeling experience as well. JD: . Your focus will be on developing and deploying machine learning algorithms and data mining strategies to optimize omnichannel communications for media/advertising applications, with an emphasis on generative AI...

  • Senior Data Scientist

    2 weeks ago


    Summit, NJ, United States ShiftCode Analytics Full time

    Interview: Onsite (F2F) Visa: USC, GC, GC EAD and H4 EAD Hybrid: Summit, NJ Some with the MMM Marketing Mix Modeling experience as well. JD: . Your focus will be on developing and deploying machine learning algorithms and data mining strategies to optimize omnichannel communications for media/advertising applications, with an emphasis on generative AI...

  • Senior Data Scientist

    2 weeks ago


    Summit, NJ, United States ShiftCode Analytics Full time

    Interview: Onsite (F2F) Visa: USC, GC, GC EAD and H4 EAD Hybrid: Summit, NJ Some with the MMM Marketing Mix Modeling experience as well. JD: . Your focus will be on developing and deploying machine learning algorithms and data mining strategies to optimize omnichannel communications for media/advertising applications, with an emphasis on generative AI...

  • Data Migration Lead

    2 weeks ago


    Summit, NJ, United States TCS CT USAAvance Consulting Full time

    Key Skills and Experience: Expert knowledge of the Veeva data model, including documents, records, and metadata. Proficient in grooming data migration requirements in JIRA and leading data migration strategies, tools, and best practices for transitioning data to Veeva. Strong ability to analyze and map existing data sources to the Veeva Vault structure. ...

  • Data Migration Lead

    2 weeks ago


    Summit, NJ, United States TCS CT USAAvance Consulting Full time

    Key Skills and Experience: Expert knowledge of the Veeva data model, including documents, records, and metadata. Proficient in grooming data migration requirements in JIRA and leading data migration strategies, tools, and best practices for transitioning data to Veeva. Strong ability to analyze and map existing data sources to the Veeva Vault structure. ...

  • Data Migration Lead

    2 weeks ago


    Summit, NJ, United States TCS CT USAAvance Consulting Full time

    Key Skills and Experience: Expert knowledge of the Veeva data model, including documents, records, and metadata. Proficient in grooming data migration requirements in JIRA and leading data migration strategies, tools, and best practices for transitioning data to Veeva. Strong ability to analyze and map existing data sources to the Veeva Vault structure. ...

  • Data Migration Lead

    1 week ago


    Summit, NJ, United States TCS CT USAAvance Consulting Full time

    Key Skills and Experience: Expert knowledge of the Veeva data model, including documents, records, and metadata. Proficient in grooming data migration requirements in JIRA and leading data migration strategies, tools, and best practices for transitioning data to Veeva. Strong ability to analyze and map existing data sources to the Veeva Vault structure. ...


  • Summit, NJ, United States Tata Consultancy Services Full time

    Must Have Technical/Functional Skills Veeva Solution Architect Experience: • Deep and strong experience with Veeva Vault configuration and implementation. • Must have clear understanding of Veeva Vault Architecture • Understanding of SaaS/Cloud solutions and technology, releases • Must have Java or Python experience • Proficient in grooming...


  • Summit, NJ, United States TCS USAAvance Consulting Full time

    Must Have Technical/Functional Skills • Proven experience in designing and deploying GenAI solutions in enterprise settings. • Strong understanding of LLMs (e.g., GPT, LLaMA, Claude), prompt engineering, and fine-tuning techniques. • Proficiency in Python and AI/ML frameworks (e.g., PyTorch, TensorFlow, Hugging Face). • Experience with cloud...


  • Summit, NJ, United States TCS USAAvance Consulting Full time

    Must Have Technical/Functional Skills • Proven experience in designing and deploying GenAI solutions in enterprise settings. • Strong understanding of LLMs (e.g., GPT, LLaMA, Claude), prompt engineering, and fine-tuning techniques. • Proficiency in Python and AI/ML frameworks (e.g., PyTorch, TensorFlow, Hugging Face). • Experience with cloud...