Data Modeler

INTech; United States; Remote; USD 96,000 - 152,000; Part time

Job summary

INTech is seeking a Senior Data Modeler to lead the design of scalable, well-structured data models for a modern enterprise data environment.

This remote contract role requires hands-on expertise in relational and dimensional modeling, including Medallion Architecture on cloud platforms. You will own end-to-end modeling and collaborate with clients and technical teams to ensure scalable, maintainable data models.

Qualifications

• Hands-on Data Modeler with strong relational and dimensional modeling experience.
• Experience modeling within Medallion Architecture on cloud data platforms.
• Proficiency with ER/Studio, Erwin, SQLDBM for data modeling.
• Ability to lead data modeling initiatives from requirements to final designs.
• Excellent communication, documentation, and stakeholder management skills.
• Experience working directly with clients in a consulting or client-facing capacity.
• Availability to work Eastern Time business hours.

Responsibilities

• Own end-to-end conceptual, logical, and physical data modeling.
• Design relational (3NF) and star schema models for enterprise environments.
• Develop data models aligned with Medallion Architecture (Bronze/Silver/Gold).
• Define entity relationships, keys, referential integrity, and business rules.
• Partner with clients and stakeholders to translate requirements into detailed models.
• Collaborate with technical teams to ensure scalable, maintainable models.

Skills

Data modeling

Relational modeling

Dimensional modeling

3NF

Medallion Architecture

ER/Studio

Erwin

SQLDBM

Stakeholder management

Client-facing

Documentation

Tools

ER/Studio

Erwin

SQLDBM

Job description

No 3rd Parties. Resumes sent directly to our team will be blocked and deleted.

Senior Data Modeler

Location: Remote | Must work Eastern Time (ET) hours

Employment Type: Contract

We're seeking a highly experienced, hands-on Senior Data Modeler to lead the design of scalable, well-structured data models for a modern enterprise data environment.

This is a dedicated data modeling role, not a data engineering or data architecture position. We're looking for someone whose primary expertise and professional focus is data modeling, with the ability to translate complex business requirements into effective conceptual, logical, and physical models.

Key Responsibilities

• Own end-to-end conceptual, logical, and physical data modeling.
• Design relational (3NF) and dimensional/star schema models for enterprise data environments.
• Develop data models aligned with Medallion Architecture (Bronze/Silver/Gold).
• Define entity relationships, primary and foreign keys, referential integrity, and business rules.
• Partner directly with clients and business stakeholders to gather requirements and translate them into detailed, documented data models.
• Collaborate with technical teams to ensure models are scalable, maintainable, and aligned with business needs.

Required Qualifications

• Extensive hands-on experience as a dedicated Data Modeler, with deep expertise in relational and dimensional modeling.
• Strong command of data modeling methodologies, normalization, 3NF, star schemas, and entity relationships.
• Experience modeling within Medallion Architecture on modern cloud data platforms.
• Proficiency with data modeling tools such as ER/Studio, Erwin, or SQLDBM.
• Demonstrated ability to independently lead data modeling initiatives from requirements through completed designs.
• Excellent communication, documentation, and stakeholder management skills.
• Proven experience working directly with clients in a consulting or client-facing capacity.
• Availability to work Eastern Time business hours.

Nice to Have

• Experience with Databricks and Delta Lake.
• Experience with Microsoft Azure.

Important: We're specifically seeking a data modeling specialist whose career has centered on hands-on data modeling, rather than a Data Engineer or Data Architect who performs modeling as one component of a broader role.