Data ModelerMastech Digital • Dallas, TX, US
[error_messages.no_longer_accepting]
Data Modeler
Mastech Digital • Dallas, TX, US
[job_card.variable_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]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. Excellent communication skills – ability to document models clearly and present to technical and non-technical audiences. Self-Motivated, with an ability to multi-task Capable of presenting to all levels of audiences Works well in a team environment Experience with Hadoop / MongoDB a plus
Job Description
Only for Local candidates of Dallas, Tx (W2 Only)
Job Summary :
Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise-grade data models that support critical business initiatives, analytics, and operational systems. The ideal candidate is proficient in industry-standard data modeling tools (with hands-on expertise in erwin Data Modeler) and has deep experience with Oracle and SQL Server databases. The candidate will also translate complex business requirements into robust, scalable, and normalized data models while ensuring alignment with data governance, performance, and integration standards.
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 company’s Data Governance Policy and Information Classification and Protection Policy.
- Participate in design reviews and take guidance from the Data Architecture team members.
Qualifications
[job_alerts.create_a_job]
Data Modeler • Dallas, TX, US
[internal_linking.similar_jobs]
A company is looking for a Data Modeler to support enterprise architecture and data syndication activities.Key Responsibilities : Design and implement logical and physical data models for healthca...[show_more]
Need a Mule leader who has SAP Master Data experience.Experience in SAP Master Data integration with experience in Material Master, Customer Master, and Vendor Master with at least one of them.Must...[show_more]
Zone IT Solutions is seeking a Teradata and Hadoop Developer to enhance our data solutions team.In this role, you will be responsible for developing and managing large-scale data processing systems...[show_more]
England is Now Hiring Local CDL-A Drivers in Haslet, TX!.Drivers Average $80,000 Annually • - Home Daily •.Valid CDL-A and 3+ months of current experience required.
This lane is not suitable for stude...[show_more]
Since opening our first self-storage facility in 1972,.Europe, and more than 170 million net rentable square feet of real estate, we're also one of the largest landlords.And, our employees have...[show_more]
Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world's leading organizations in a broad range of industries.In this quickly ch...[show_more]
The ideal candidate must have strong expertise in the Hadoop ecosystem and RDBMS, with a solid understanding of data processing, storage, and analysis.
The rate may be negotiable based on experience...[show_more]
Job Title : Solution Architect - Data Model Design.Note : Client interview In-person needed.Architect end-to-end enterprise data solutions.
Design data models and integration frameworks that support d...[show_more]
At Royal Electric Company we provide expert electrical design, construction, and service with builders, contractors and facility owners who value relationships, trust, expertise, and a commitment t...[show_more]
PLEASE GO THROUGH THE BELOW NOTES AND JOB DESCRIPTION BEFORE SENDING OUT THE RESUME.STRICTLY EXPERIENCED RESOURCES WHO CAN WORK ON W2 AND ONLY LOCAL TO DALLAS WHO CAN ATTEND FACE TO FACE WITH...[show_more]
We are looking for a passionate certified Data Engineer.The successful candidate will turn data into information, information into insight and insight into business decisions.Data analyst responsib...[show_more]
Join a locally owned Great Clips® salon, the world's largest salon brand, and be one of the GREATS! Whether you're new to the industry or have years behind the chair…great opportunities await!!.Our...[show_more]
Earn at least $1685 driving with Uber when you complete your first 143 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...[show_more]
Windsor Healthcare Recruitment Group, Inc.AlliedTravelCareers is working with Windsor Healthcare Recruitment Group, Inc.Physical Therapist (PT) in Ennis, Texas, 75119!.
PT is needed for a 13-week as...[show_more]
SAP Snowflake TechnoFunctional Consultant.The SAP Snowflake TechnoFunctional Consultant acts as a bridge between business stakeholders and technical teams delivering endtoend solutions across SAP E...[show_more]
Strong Background in Enterprise Data Warehouse (EDW) concepts, dimensional modelling & performance tuning.Proficiency in Teradata tools & utilities –.
Advanced SQL skills and Experienc...[show_more]
Job Type : Contract; 3 months contract.Data Vault, Data modelling, AWS, Terraform.Implement business and IT data requirements through new data strategies and designs across all data platforms (relat...[show_more]
Title : Data Engineer or Data Architect.Data Engineer or Data Architect with Azure.[show_more]
Data Modeler
VirtualVocations • Dallas, Texas, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Mulesoft Lead with SAP Master Data experience
Omni Inclusive • Dallas, TX, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Teradata and Hadoop Developer
Zone IT Solutions • Plano, TX, US
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_hours] • [new]
CDL-A Truck Driver - Home Daily - Average $80,000 / Year - 3 Months Exp.
C.R. England • Ennis, TX, US
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Sr. AI / ML Data Engineer
Public Storage • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Data Consultant
Tekfortune Inc • Dallas, TX, United States
[job_card.permanent]
[last_updated.last_updated_variable_days] • [promoted]
Big Data Engineer
Akkodis • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Solution Architect - Data Model Design
Tek Spikes • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Virtual Construction Modeler III
Royal Electric • Dallas, TX, US
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
AI / ML Engineer - LOCAL TO DALLAS ONLY / W2 CONTRACT ROLE
FIRSTNET GLOBAL LLC • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Data Engineer
Forhyre • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Licensed Hair Stylist - Ennis Walmart
Great Clips • ENNIS, Texas, United States
[job_card.full_time] +1
[last_updated.last_updated_30] • [promoted]
Earn At Least $1685 For Your First 143 Trips, Guaranteed.
Uber • Ennis, TX, US
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Travel Physical Therapist (PT) - $2,290 per week in Ennis, TX
AlliedTravelCareers • Ennis, TX, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
SAP Snowflake TechnoFunctional Consultant - Plano,TX - 5 days onsite
JGA • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Teradata Architect
Ventures Unlimited Inc • Plano, TX, US
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Data Architect
eTeam Inc • Plano, Texas, United States
[job_card.temporary]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Need Data Engineer or Data Architect - Remote
IT Vision Group • Dallas, TX, US
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]