What are the responsibilities and job description for the Data Modeler(Hybrid) position at ChaTeck,Inc?
Data Modeler
Location:Morristown, New Jersey, 07960
Duration:Long term
Key Responsibilities
• Design and develop conceptual, logical, and physical data models for relational, dimensional, and NoSQL data stores
• Build and maintain entity-relationship diagrams (ERDs) and data flow documentation aligned with enterprise data standards
• Partner with data platform engineers and architects to ensure data models support efficient ingestion, transformation, and reporting pipelines
• Translate business requirements and use cases into optimized database schemas, ensuring scalability and performance
• Conduct data model reviews, enforce modeling standards and best practices, and provide technical guidance to junior team members
• Develop and maintain comprehensive data dictionaries, metadata documentation, and lineage documentation
• Collaborate with reporting and analytics teams to design star/snowflake schemas for data warehouse and data mart environments
• Identify and resolve data quality, redundancy, and integrity issues through sound modeling practices
• Support data governance initiatives including data standardization, data cataloging efforts
• Participate in Agile delivery model, delivering modeling artifacts in iterative sprints
Required Qualifications
• 7 years of experience in data modeling, data architecture, or a closely related discipline
• Expert proficiency in data modeling tools such as Erwin, ER/Studio, dbt
• Deep experience with relational databases (SQL Server, Oracle, PostgreSQL) and cloud data platforms (Databricks, Snowflake, BigQuery, Redshift, Azure Synapse)
• Strong command of dimensional modeling techniques (Kimball, Inmon, Data Vault 2.0)
• Proficiency in SQL for schema design, query optimization, and data validation
• Demonstrated ability to work independently, manage competing priorities, and deliver in a contractor/consulting capacity
• Strong communication skills with the ability to present complex data concepts to both technical and non-technical audiences
Regards
Kevin
ChaTeck Inc.
972-597-5008 (D)
kevin@chateck.com
www.chateck.com
People .Consulting .Technology .Outsourcing