Erwin Data Modeler

Job Title: Erwin Data Modeler (Star Schema Specialist)Duration: 06+ months contract with high possibility of extensionLocation: Camden, NJ 08103 (Remote)

OPPORTUNITY: ONLY ON W2

JOB DESCRIPTION:Company Overview:Our company is a leading player in the CPG sector, committed to leveraging data-driven insights for strategic decision-making. We are seeking an experienced Erwin Data Modeler to join our dynamic team.

Position Summary: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:1. Data Modeling:o Design and create logical and physical data models using Erwin.o Analyze existing data models and recommend improvements.o Develop and maintain data dictionaries and data models.2. Star Schema Design:o Implement star schema designs for our data warehouse.o Understand the characteristics of a star schema, including fact tables and dimension tables.o Optimize star schema structures for efficient querying and reporting.3. Collaboration:o Work closely with business analysts to understand data requirements.o Collaborate with data engineers to implement data models in our database systems.o Participate in cross-functional teams to align data modeling efforts with business goals.4. Documentation:o Document data models, including relationships, attributes, and constraints.o Maintain clear and concise documentation for future reference.5. Best Practices:o Stay updated on industry best practices related to data modeling and star schema design.o Ensure compliance with data governance standards.

Qualifications:Bachelor’s degree in Computer Science, Information Systems, or a related field.Minimum of 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 BIPython expertise

Looking forward to hearing from you soon!