Data Engineer (In Person Interview must)

Hiring,
Greetings from Modern Agilte Technologies.

Position: Data Engineer
Location: Dallas,TX (Locals only who can go onsite interview.)

Type: Contract (W2)

Job Description:

Required skills:
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 (e.g., 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

Nice to have skills:
Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance requirements.
Familiarity with additional modeling or metadata tools (e.g., ER/Studio, PowerDesigner, Collibra, Alation).
Exposure to cloud data platforms (e.g., Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on-prem/cloud modeling scenarios.
Working knowledge of ETL/ELT tools and data integration patterns.
Experience supporting master data management (MDM) or data governance initiatives.
Experience working with Microsoft SQL Server
Experience working with PostGres
Data vault experience
Experience with Hadoop/MongoDB