Data Modeler
Job description
- Home
- About
- Adaptive AI
- Industries
- Consulting
- Jobs Portal
- Contact Us
- Home
- About
- Adaptive AI
- Industries
- Consulting
- Jobs Portal
- Contact Us
- Job ID:
- Job Title:
- Location:
- Duration:
- Domain Exposure:
- Client:
- Employment Type:
- Work Authorization:
View All Jobs
Similar Jobs
- Data Product Solution Engin...
- Boston, MA
- Technical Project Manager –...
- Santa Clara, CA
- Data Scientist - Houston, TX
- GIS Cloud Data Engineer - Spring, TX
- Azure Data Engineer - Raleigh, NC
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 Oncor’s 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.
Capable of presenting to all levels of audiences Experience with Hadoop/MongoDB a plus
Apply Now
Equal Opportunity Employer
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.- Home
- About
- Adaptive AI
- Industries
- Consulting
- Contact Us
Interested in this role?