Data Modeler

4 weeks ago

Dallas TX, United States Mastech Digital Full time

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 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

  • Data Modellers

    3 weeks ago

    Dallas, TX, United States MathCo Full time

    About Us: TheMathCompany or MathCo® is a global Enterprise AI and Analytics company trusted by leading Fortune 500 and Global 2000 enterprises for data-driven decisionmaking. Founded in 2016, MathCo builds custom AI and advanced analytics solutions to solve enterprise challenges through its hybrid model. NucliOS, MathCo’s proprietary platform, enables...

  • Data Modeler

    2 weeks ago

    Dallas, TX, United States Anblicks Full time

    Lead design and delivery of end-to-end data analytics solutions. Conduct technical POCs on data analytics and AI/ML technologies. Work with data visualization team within the Data Analytics Centre of Excellence. Design business intelligence reports, interactive dashboards and KPI scorecards using Power BI. Use data architecture, data management, data...

  • Data Modeling Architect

    4 weeks ago

    Dallas, TX, United States MathCo Full time

    About Us: TheMathCompany or MathCo® is a global Enterprise AI and Analytics company trusted by leading Fortune 500 and Global 2000 enterprises for data-driven decisionmaking. Founded in 2016, MathCo builds custom AI and advanced analytics solutions to solve enterprise challenges through its hybrid model. NucliOS, MathCo’s proprietary platform, enables...

  • Data Modeler

    4 weeks ago

    Dallas, United States Mastech Digital Full time

    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...

  • Data Modeler

    8 hours ago

    Dallas, United States Government Tactical Solutions, LLC Full time

    Join to apply for the Data Modeler role at Government Tactical Solutions, LLC Salary: $135,000 – 175,000Contract Length: 6 monthLocation: Dallas, TX – Hybrid, 2 or 3 days a week (Thursday in office) This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other...

  • Data Modeler

    7 hours ago

    Dallas, United States The Amatriot Group Full time

    Join to apply for the Data Modeler role at The Amatriot Group 1 week ago Be among the first 25 applicants Salary: $135,000 – 175,000 Contract Length: 6 month Location: Dallas, TX – Hybrid, 2 or 3 days a week (Thursday in office) This represents the potential salary range for this position depending on education level, years of experience and/or...

  • Data Modellers

    3 weeks ago

    Houston, TX, United States Axelon Services Corporation Full time

    Title: Logical Data Modeler Remember to check your CV before applying Also, ensure you read through all the requirements related to this role. Location: Houston, TX Key Responsibilities: Design and maintain logical data models that reflect business requirements and support enterprise data architecture. Collaborate with business...

  • Data Modellers

    3 weeks ago

    Houston, TX, United States Dynamics Door Full time

    We are seeking a Senior Data Architect to play a strategic, business-facing role in shaping how data is used across the organization. This role will be a key partner to Operations, Supply Chain, and Executive Leadership, helping the business fully leverage Power BI and Dynamics 365 F&O to drive insight, decision-making, and performance. The ideal...

  • Sr Data Modeler

    4 weeks ago

    Dallas, United States InterSources Full time

    Job Title: Sr Data Modeler Role: Dallas, USA (Onsite) Must Skill: Data Vault exp Type: CWR Job Overview: Designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional Responsible for the development of the conceptual, logical, and physical data models Implementation of RDBMS, operational...

  • Sr Data Modeler

    2 weeks ago

    Dallas, TX, United States InterSources Full time

    Job Title: Sr Data Modeler Role: Dallas, USA (Onsite) Must Skill: Data Vault exp Type: CWR Job Overview: Designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional Responsible for the development of the conceptual, logical, and physical data models Implementation of RDBMS, operational...