Data Modeler
Not available for C2C engagements Vendors marketing candidate will be blocked This is a hybrid onsite role in Downtown Dallas, TXMust be local to DFW - you will be rejected if you LinkedIn does not show you're local to DFWData Modeler
Must haves:
1. Erwin Data Modeler (expert level)2. Conceptual, logical, and physical data modeling (3+ years enterprise experience)3. Oracle and SQL Server with advanced SQL4. DDL and database internals5. 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.
Apply TodayIf you are an experienced Data Modeler looking for an opportunity to make a meaningful impact within a dynamic enterprise environment, we encourage you to apply today. Please submit your resume along with your contact information, and a member of The Intersect Group team will be in touch to discuss the opportunity.