Erwin Data Modeler,

100% Remote, must be from EST or CST

Need valid LinkedIn

possible CTH role

Must have Erwin, strong and recent CPG industry and data bricks experience

As an Erwin Data Modeler, you will be responsible for designing and maintaining logical and physical data models using Erwin. Your expertise in star schema design will be crucial in optimizing our data warehouse for efficient querying and reporting. You’ll collaborate closely with business analysts, data engineers, and other stakeholders to ensure data accuracy, consistency, and performance.

Key Responsibilities

Data Modeling:

• Design and create logical and physical data models using Erwin.
• Analyze existing data models and recommend improvements.
• Develop and maintain data dictionaries and data models.
  
  

Star Schema Design

• Implement star schema designs for our data warehouse.
• Understand the characteristics of a star schema, including fact tables and dimension tables.
• Optimize star schema structures for efficient querying and reporting.
  
  

Collaboration

• Work closely with business analysts to understand data requirements.
• Collaborate with data engineers to implement data models in our database systems.
• Participate in cross-functional teams to align data modeling efforts with business goals.
  
  

Documentation

• Document data models, including relationships, attributes, and constraints.
• Maintain clear and concise documentation for future reference.
  
  

Best Practices

• Stay updated on industry best practices related to data modeling and star schema design.
• Ensure compliance with data governance standards.
  
  

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Minimum of 7 years of experience as an Erwin Data Modeler.
• Proficiency in designing star schemas for data warehouses.
• Familiarity with CPG industry data and business processes.
• Strong SQL skills for querying and performance tuning.
• Excellent communication and teamwork abilities.
  
  

Preferred Skills

• Experience with other data modeling tools (e.g., ER/Studio).
• Knowledge of Kimball and Inmon methodologies.
• Understanding of 3NF database normalization.
• Exposure to Databricks and Power BI
• Python expertise