Data Modeler

Overview

Data Architecture & Analytics

Dallas-Fort Worth, TX - Hybrid (mandatory in office on Thursdays)

This position requires a hybrid work arrangement with regular on-site collaboration.

Data Modeler

Data Architecture & Analytics

Dallas-Fort Worth, TX - Hybrid (mandatory in office on Thursdays)

This position requires a hybrid work arrangement with regular on-site collaboration.

Our client is one of the largest regulated electric transmission and distribution utilities in the United States, serving over 10 million consumers across North Central Texas. With more than a century of operational excellence, they deliver electricity to homes and businesses through a robust infrastructure spanning 140,000+ miles of transmission and distribution lines. As a critical component of Texas  energy infrastructure, they are committed to reliability, innovation, and safety while investing heavily in grid modernization and smart technology solutions.

Their mission centers on powering quality of life through safe, reliable energy delivery and cutting-edge infrastructure development.

We re seeking an experienced Data Modeler to join a dynamic data architecture team supporting critical energy infrastructure and business operations. In this role, you ll be at the forefront of designing enterprise-grade data models that power analytics, operational systems, and strategic business initiatives for one of Texas  most essential utility providers.

Your day-to-day will involve collaborating with data architects, DBAs, ETL developers, and business stakeholders to translate complex requirements into scalable, normalized data models using erwin Data Modeler. You ll work across both Oracle and SQL Server environments, performing forward and reverse engineering, optimizing DDL scripts, and ensuring alignment with data governance standards. This position offers the opportunity to make a tangible impact on systems that serve millions of consumers while working within a fast-paced, results-driven culture that values innovation and technical excellence.

The ideal candidate is passionate about data architecture, thrives in collaborative environments, and is excited about contributing to large-scale infrastructure projects that power communities across Texas. You ll report to the Data Architecture leadership team and work closely with cross-functional technology teams.

• Design and develop conceptual, logical, and physical data models using erwin Data Modeler for enterprise systems.
• Generate, review, and optimize DDL scripts for database objects including tables, views, indexes, constraints, and partitions.
• Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
• Collaborate with cross-functional teams to gather, analyze, and refine complex business and technical requirements.
• Ensure data models adhere to normalization standards (3NF/BCNF), data integrity, and referential integrity principles.
• Support dimensional modeling using star and snowflake schemas for data warehousing and analytics initiatives.
• Conduct thorough model reviews, impact analysis, and maintain version control using erwin or comparable tools.
• Participate actively in data governance initiatives including metadata management, naming standards, and lineage documentation.
• Optimize data models for performance, scalability, and maintainability across large-scale enterprise environments.
• Assist in database migrations, schema comparisons, and synchronization activities across Dev/QA/Prod environments.
• Contribute to the optimization and enhancement of existing data solutions and infrastructure.
• Participate in design reviews and collaborate with Data Architecture team members for guidance and best practices.

• 3+ years of hands-on data modeling experience in large-scale enterprise environments.
• Expert proficiency with erwin Data Modeler (version 9.x or higher preferred) including subject areas, model templates, and DDL generation.
• Advanced SQL skills with deep understanding of Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
• Strong command of DDL for creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
• Solid grasp of database internals including indexing strategies, partitioning, clustering, and query execution plans.
• Experience with data modeling best practices: normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD).
• Excellent written and verbal communication skills with ability to present technical concepts to diverse audiences.
• Self-motivated with strong ability to multitask and manage multiple priorities effectively.
• Proven ability to work collaboratively in team environments and build relationships across functions.
• Experience with version control systems (e.g., Git) and model comparison/diff tools.

• Personal interest in energy, utilities, or critical infrastructure sectors.
• Experience…