Job Description
Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise-grade data models that support critical business initiatives, analytics, and operational systems. The ideal candidate is proficient in industry-standard data modeling tools (with hands-on expertise in erwin Data Modeler) and has deep experience with Oracle and SQL Server databases. The candidate will also translate complex business requirements into robust, scalable, and normalized data models while ensuring alignment with data governance, performance, and integration standards.
Responsibilities
Qualifications
Responsibilities
- Design and develop conceptual, logical, and physical data models using erwin Data Modeler (required).
- Generate, review, and optimize DDL (Data Definition Language) scripts for database objects (tables, views, indexes, constraints, partitions, etc.).
- Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
- Collaborate with data architects, DBAs, ETL developers, and business stakeholders to gather and refine requirements.
- Ensure data models adhere to normalization standards (3NF/BCNF), data integrity, and referential integrity.
- Support dimensional modeling (star/snowflake schemas) for data warehousing and analytics use cases.
- Conduct model reviews, impact analysis, and version control using erwin or comparable tools.
- Participate in data governance initiatives, including metadata management, naming standards, and lineage documentation.
- Optimize models for performance, scalability, and maintainability across large-scale environments.
- Assist in database migrations, schema comparisons, and synchronization between environments (Dev/QA/Prod).
- Assist in optimizing existing Data Solutions
- Follow Oncors Data Governance Policy and Information Classification and Protection Policy.
- Participate in design reviews and take guidance from the Data Architecture team members.
Qualifications
- 3+ years of hands-on data modeling experience in 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 and deep understanding of Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016+).
- Strong command of DDL creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
- Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans.
- Experience with data modeling best practices: normalization, denormalization, surrogate keys, slowly changing dimensions (SCD), and data vault (a plus).
- Familiarity with version control (e.G., Git) and model comparison/diff tools.
- Excellent communication skills ability to document models clearly and present to technical and non-technical audiences.
- Self-Motivated, with an ability to multi-task
- Capable of presenting to all levels of audiences
- Works well in a team environment
- Experience with Hadoop/MongoDB a plus
Numbers & Facts
| Location | Dallas, TX |
| Industry | Staffing/Employment Agencies |
| Company Size | 100 to 499 employees |
| Website | https://www.prg-usa.com/ |
About Company
Established in 2001, Peyton Resource Group is a solution-based staffing company that matches businesses with top talent for short-term, long-term or permanent needs.
People are a business’s most valuable asset. Peyton Resource Group is dedicated to helping companies find the best talent, matching professionals with jobs where they will thrive.
With locations in Dallas/Fort Worth, San Antonio and Austin, we are available to serve your staffing needs throughout Texas and across the country.
Skills
- Analysis Skillsunmatched
- Apache Hadoopunmatched
- Best Practicesunmatched
- Business Supportunmatched
- Communication Skillsunmatched
- Data Analysisunmatched
- Data Description Language (DDL)unmatched
- Data Modelingunmatched
- Data Modeling Toolsunmatched
- Data Qualityunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Technologyunmatched
- Dimensional Modelingunmatched
- Documentationunmatched
- Documentation Modelsunmatched
- Gitunmatched
- Industry Standardsunmatched
- Information/Data Security (InfoSec)unmatched
- Metadataunmatched
- Microsoft SQL Serverunmatched
- Model Reviewunmatched
- MongoDBunmatched
- Multitaskingunmatched
- Operational Auditunmatched
- Oracle 11iunmatched
- Oracle Databaseunmatched
- Performance Modelingunmatched
- Performance Tuning/Optimizationunmatched
- Quality Assuranceunmatched
- Requirements Managementunmatched
- Reverse Engineeringunmatched
- SQL (Structured Query Language)unmatched
- Scripting (Scripting Languages)unmatched
- Snowflake Schemaunmatched
- Source Code/Configuration Management (SCM)unmatched
- Star Schemaunmatched
- Team Playerunmatched
- Technical Presentationunmatched
- Use Casesunmatched
- erwin Data Modelerunmatched
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder