Senior Data Modeler / Data Architect – Erwin & Oracle
- Location
- Dallas, Texas, United States
- Salary
- Not specified
- Company
- akash pawar
Job description
### Role & Company / Project Overview Drunix Solutions is hiring an experienced Senior Data Modeler / Data Architect with strong hands-on expertise in Erwin Data Modeler, Oracle databases, SQL, and enterprise data modeling. The position requires a self-motivated professional with strong analytical and communication skills who can work independently and collaborate with technical and business stakeholders. Eligible visa statuses include USC, TN, and H4. ### Key Responsibilities & Daily Duties • Architect, design, and maintain enterprise transactional and dimensional data models. • Work extensively with subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and model comparison. • Develop and optimize advanced SQL and PL/SQL queries, schemas, and database performance tuning. • Construct normalized (3NF) transactional models and dimensional models (Star/Snowflake schema). • Execute hands-on DDL creation, including tables, indexes, constraints, sequences, synonyms, and materialized views. • Maintain data dictionaries, metadata, and comprehensive data lineage documentation. • Handle surrogate keys, denormalization, and Slowly Changing Dimensions (SCD). ### Required Qualifications, Skills & Experience • 5+ years of experience in Data Modeling, Data Architecture, or Database Design. • Expert-level proficiency in Erwin Data Modeler (Version 9.x or higher). • Advanced SQL and Oracle expertise across 11g, 12c, 19c, and 21c versions. • In-depth knowledge of SQL, PL/SQL, schema design, and database performance tuning. • Deep understanding of ER modeling, normalization, cardinality, keys, and referential integrity. • Solid knowledge of indexing, partitioning, clustering, and query execution plans. • Strong familiarity with Git, version control, and model comparison tools. ### Nice-to-Have Skills • Experience in regulated industries such as Utilities, Banking, Insurance, or Healthcare. • Exposure to ER/Studio, PowerDesigner, Collibra, or Alation. • Experience with Snowflake, Databricks, AWS, Azure, or Oracle Cloud. • Knowledge of ETL/ELT and data integration patterns. • Experience with Master Data Management (MDM) and Data Governance. • Working knowledge of SQL Server and PostgreSQL. • Data Vault modeling experience. • Exposure to Hadoop and MongoDB. ### Working Hours, Shifts & Location Details • Location: Dallas, TX, United States. ### Compensation & Benefits • Not specified. ### Application Instructions • Interested candidates should share their updated resume with the recruitment team.