Data Modeler

Dallas, TX, US • Posted 1 hour ago • Updated 1 hour ago
Full Time
On-site
Company Branding Image
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • Collaboration
  • Reverse Engineering
  • Extract
  • Transform
  • Load
  • Data Integrity
  • Meta-data Management
  • Dimensional Modeling
  • Warehouse
  • Analytics
  • Snow Flake Schema
  • Documentation
  • Database Migration
  • Data Governance
  • Data Architecture
  • Data Modeling
  • ERwin
  • SQL
  • Oracle
  • Microsoft SQL Server
  • DDL
  • Database
  • Clustering
  • Normalization
  • Slowly Changing Dimensions
  • Management
  • Modeling
  • Git
  • Version Control
  • Apache Hadoop
  • MongoDB
  • Presentations
  • Artificial Intelligence

Summary

Join a dynamic team as a Data Modeler focused on building enterprise-grade data models that support analytics, operations, and critical business initiatives. This role offers the opportunity to work with modern data modeling tools and collaborate across architecture, development, and governance functions in a hybrid onsite environment.
Responsibilities
  • Design conceptual, logical, and physical data models using Erwin Data Modeler.
  • Create, review, and refine DDL for database objects such as tables, views, indexes, constraints, partitions, and related structures.
  • Perform forward and reverse engineering of data models from Oracle and Microsoft SQL Server environments.
  • Partner with data architects, DBAs, ETL developers, and business stakeholders to gather, interpret, and translate requirements into scalable solutions.
  • Apply normalization principles and ensure data integrity, referential integrity, and strong metadata standards.
  • Support dimensional modeling efforts for warehousing and analytics needs, including star and snowflake schemas.
  • Participate in model reviews, impact assessments, comparisons, and version control activities.
  • Contribute to data governance practices, including naming standards, documentation, and lineage tracking.
  • Help improve existing data solutions and support database migration and synchronization efforts across environments.
  • Follow established data governance and information protection guidelines while collaborating with the broader data architecture team.
Skills
  • 3+ years of hands-on data modeling experience in an enterprise environment.
  • Strong expertise in Erwin Data Modeler, including subject areas, templates, and DDL generation.
  • Advanced SQL skills and deep experience with Oracle and Microsoft SQL Server.
  • Solid understanding of DDL and database object design, including tables, indexes, constraints, sequences, synonyms, and materialized views.
  • Knowledge of database fundamentals such as indexing, partitioning, clustering, and query execution plans.
  • Experience with normalization, denormalization, surrogate keys, and slowly changing dimensions.
  • Ability to document models clearly and communicate effectively with both technical and non-technical audiences.
  • Comfort working independently, managing multiple priorities, and contributing in a team environment.
Preferred Skills
  • Experience with data vault modeling concepts.
  • Familiarity with Git or similar version control tools.
  • Experience with model comparison and synchronization tools.
  • Exposure to Hadoop or MongoDB.
  • Experience presenting design concepts and recommendations to a range of stakeholders.

Horizontal is committed to creating an inclusive environment where diverse perspectives are valued and every team member can contribute meaningfully. We welcome applicants from all backgrounds and encourage anyone who meets the qualifications to apply.

By applying for this position, you acknowledge and agree that Horizontal Talent may contact you regarding your application using automated technology, including phone calls, SMS/text messages, or email, which may be delivered by our virtual AI recruiter, Alex.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10123528
  • Position Id: 75616
  • Posted 1 hour ago

Company Info

About Horizontal Talent

Horizontal Integration offers two service lines. Our staffing agency places IT, digital and creative talent in both contract and permanent roles. Our digital agency provides digital marketing strategy and technology consulting on a project basis. Many of our clients take advantage of both service lines.

We are a certified Minority Business Enterprise, with more than 200 employees across our offices in Minneapolis, Denver, Dallas and Vadodara, India. We ve been consistently growing and profitable since the company was founded in 2003.

Honors:
Recognized as a "2009 Best Place to Work" by Minneapolis/St.Paul Business Journal.

Fact:
Our people and our organization are deeply rooted in IT and interactive marketing.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact us. All applicants applying must be legally authorized to work in the country of employment.

About_Company_OneAbout_Company_Two
Contact the job poster
MF

Mohammed Faisal Alam N

Recruiter @ Horizontal Talent
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Dallas, Texas

Today

Full-time

Houston, Texas

Today

Full-time

Chicago, Illinois

Today

Full-time

USD 51.00 - 89.00 per hour

San Francisco, California

Today

Full-time

Compensation information provided in the description

Search all similar jobs