Data Modeler
Mastech Digital, Inc.
Addison, TX, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.nettemps.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
Tech stack
Third Normal Form
Adobe InDesign
Data Analysis
Databases
Data Architecture
Data Definition Language
Data Dictionary
Data Governance
Data Integrity
Extract Transform Load (ETL)
Data Systems
Data Warehousing
+22 more
Database Design
Dimensional Modeling
Metadata
Meta-Data Management
Microsoft SQL Server
Oracle Databases
Oracle (Applications)
Performance Tuning
Reverse Engineering
PL-SQL
SQL Databases
Data Classification
Sql Optimization
Snowflake
Database Optimization
Git
Database Migration
Data Lineage
Modeling and Simulation
Operational Systems
Physical Data Models
Software Version Control
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., * 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 Oncor’s Data Governance Policy and Information Classification and Protection Policy.
- Participate in design reviews and take guidance from the Data Architecture team members.
Requirements
- 5 or more years of hands-on experience in data modeling, data architecture, or database design roles.
- Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) - including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality.
- Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design.
- Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
- Strong command of DDL - creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
- Solid understanding of data modeling theory: entity-relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity.
- Solid grasp of database internals: indexing strategies, partitioning, clustering, and query execution plans.
- Experience with data modeling best practices: normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD)
- Experience producing and maintaining data dictionaries, metadata, and data lineage documentation.
- Familiarity with version control (eg, Git) and model comparison/diff tools.
- Excellent communication skills with the ability to clearly explain modeling decisions to both technical and non-technical audiences.
- Self-Motivated, with an ability to multi-task
- Works well in a team environment
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.nettemps.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…