Erwin Data Modeler- Star Schema Specialist

DATA MODELER-ERWIN-CONTRACT TO CONVERT TO FULL TIME -REMOTE

Our client has a Contract opportunity for an Erwin Data Modeler to design Star Schemas for data warehouses. Consultant must have previous experience in the Consumer Package Industry: the Manufacturing of products- food, pharmaceuticals etc. A JR Architect experienced with SAP Datawarehouse Solutions on THE CLOUD (DSP) AND /OR DATABRICKS is preferred or a Data Modeler with at least 6-10 years experience. This person will be responsible for designing and maintaining logical and physical data models using Erwin. Expertise in star schema design will be crucial in optimizing the data warehouse for efficient querying and reporting. Must have experience collaborating closely with business analysts, data engineers, and other stakeholders to ensure data accuracy, consistency, and performance.

PLEASE NO Financial Services experience WILL BE ACCEPTED. THIS IS A CONTRACT TO CONVERT TO FULL TIME- NO H1 TRANSFERS- REMOTE ROLE ON EASTERN OR CENTRAL TIME ONLY.

Qualifications:

• Bachelor s degree in Computer Science, Information Systems, or a related field.
• Minimum of 5-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.

Key Responsibilities:

1. 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.
2. 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.
3. 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.
4. Documentation:
• Document data models, including relationships, attributes, and constraints.
• Maintain clear and concise documentation for future reference.
5. Best Practices:
• Stay updated on industry best practices related to data modeling and star schema design.
• Ensure compliance with data governance standards.

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