Senior Data Modeler

Job Title: Senior Data Modeler

Job Location: Dallas, TX

Job Type: Contract

Pay Range: $60.00hr - $65.00hr

Job Overview:

The candidate should possess 5+ years of hands-on experience in data modeling, data architecture, or database design roles.

Responsibilities and Requirements:

• Demonstrate 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.
• Utilize advanced SQL skills and a 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.
• Build both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.
• Demonstrate strong command of DDL, including creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.
• Apply solid understanding of data modeling theory, including entity-relationship modeling, normalization/denormalization, cardinality, keys, and referential integrity.
• Apply a solid grasp of database internals, including indexing strategies, partitioning, clustering, and query execution plans.
• Utilize data modeling best practices, including normalization, denormalization, surrogate keys, and slowly changing dimensions (SCD).
• Produce and maintain data dictionaries, metadata, and data lineage documentation.
• Demonstrate familiarity with version control (e.g., Git) and model comparison/diff tools.
• Demonstrate excellent communication skills with the ability to clearly explain modeling decisions to both technical and non-technical audiences.
• Demonstrate self-motivation with an ability to multitask.
• Work effectively in a team environment.

Preferred Qualifications:

• 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 PostgreSQL.
• Data vault experience.
• Experience with Hadoop/MongoDB.

====

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities