Data Modeler

The Intersect Group; Fort Worth, Arlington, Dallas (TX, TX, TX); Hybrid; USD 90,000 - 140,000; Full time

Job summary

The Intersect Group is seeking an experienced Data Modeler to design, develop, and maintain enterprise data models that support mission-critical initiatives and analytics platforms. You will work with data architects, DBAs, developers, and business stakeholders to ensure scalable, governed data assets.

You will lead conceptual, logical, and physical modeling using Erwin Data Modeler, optimize DDL, and perform forward/reverse engineering across Oracle and SQL Server.

Qualifications

• 3+ years of hands-on enterprise data modeling experience.
• Advanced Erwin Data Modeler expertise and DDL generation.
• Strong Oracle and SQL Server design and optimization.
• Experience with normalization, slowly changing dimensions, and dimensional modeling concepts.
• Excellent communication and collaboration across teams.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Develop, review, and optimize DDL scripts for tables, views, indexes, constraints, partitions, and other database objects.
• Perform forward and reverse engineering of data models across Oracle and SQL Server environments.
• Collaborate with architects, DBAs, ETL developers, and business stakeholders to define and refine data requirements.
• Ensure data models comply with normalization standards, referential integrity, and data governance requirements.
• Support data warehousing initiatives through dimensional modeling, including star and snowflake schemas.
• Conduct model reviews, impact assessments, and schema comparisons while maintaining version control standards.
• Assist with database migrations, environment synchronization, and optimization of existing enterprise data solutions.

Skills

Data modeling

Advanced SQL

Communication

Cross-functional collaboration

Tools

Erwin Data Modeler

Oracle

SQL Server

Git

Hadoop

MongoDB

Job description

Vendors marketing candidate will be blocked

This is a hybrid onsite role in Downtown Dallas, TX

Must be local to DFW - you will be rejected if you LinkedIn does not show you're local to DFW

Data Modeler

Must haves:

1. 2. Conceptual, logical, and physical data modeling (3+ years enterprise experience)
2. 3. Oracle and SQL Server with advanced SQL
3. 4. DDL and database internals
4. 5. Communication and cross-functional collaboration

About the Opportunity

The Intersect Group is partnering with a leading organization in the utilities and technology space that is focused on delivering reliable, data driven solutions that support critical business operations and long term growth. This organization values innovation, collaboration, data governance, and operational excellence, leveraging modern technologies to drive informed decision making across the enterprise. Team members are empowered to contribute meaningful solutions in a fast paced, results oriented environment while working alongside highly skilled professionals.

Role Summary

We are seeking an experienced Data Modeler to design, develop, and maintain enterprise data models that support mission critical business initiatives, analytics platforms, and operational systems. This role plays a key part in ensuring data assets are scalable, governed, high performing, and aligned with organizational objectives.

The Data Modeler will translate complex business requirements into conceptual, logical, and physical data models while partnering closely with data architects, database administrators, developers, and business stakeholders. Success in this position requires strong expertise in Erwin Data Modeler, Oracle and SQL Server databases, and enterprise data modeling best practices. This individual will help drive data quality, governance, optimization, and modernization initiatives across large scale environments.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models using Erwin Data Modeler
• Develop, review, and optimize DDL scripts for tables, views, indexes, constraints, partitions, and other database objects
• Perform forward and reverse engineering of data models across Oracle and SQL Server environments
• Collaborate with architects, DBAs, ETL developers, and business stakeholders to define and refine data requirements
• Ensure data models comply with normalization standards, referential integrity, and data governance requirements
• Support data warehousing initiatives through dimensional modeling, including star and snowflake schemas
• Conduct model reviews, impact assessments, and schema comparisons while maintaining version control standards
• Assist with database migrations, environment synchronization, and optimization of existing enterprise data solutions

Key Requirements

• 3+ years of hands on data modeling experience within enterprise environments
• Advanced expertise with Erwin Data Modeler, including subject areas, model templates, metadata management, and DDL generation
• Strong experience with Oracle databases and Microsoft SQL Server, including database design and optimization
• Advanced SQL skills with deep knowledge of DDL, indexing strategies, partitioning, query execution plans, and database performance tuning
• Solid understanding of normalization, denormalization, surrogate keys, slowly changing dimensions, and dimensional data modeling concepts
• Experience supporting data governance initiatives, metadata management, data lineage documentation, and naming standards
• Familiarity with Git, model comparison tools, database migration activities, and schema synchronization processes
• Experience with Hadoop and MongoDB is a plus
• Excellent communication and presentation skills with the ability to engage both technical and nontechnical audiences
• Self motivated, adaptable professional who can effectively manage multiple priorities in a fast paced environment
• Strong team oriented mindset with a commitment to delivering high quality results and continuous improvement

Team Culture

This team is fast paced, energetic, collaborative, and highly focused on delivering exceptional business outcomes. Team members are encouraged to take ownership, solve complex problems, and contribute innovative ideas while working in a supportive and results driven environment. Individuals who thrive on accountability, continuous learning, and achieving measurable results will be well positioned for success.