> Markdown version of [/jobs/ext/163587-data-modeler](https://www.wearedevelopers.com/jobs/ext/163587-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Modeler - **Company:** HMG America - **Location:** Plano, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Microsoft Azure, Big Data, Information Systems, Databases, Data as a Services, Data Architecture, Data Cleansing, Data Dictionary, Information Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Systems, Data Warehousing, Database Applications, Relational Databases, Database Schema, Dimensional Modeling, Entity Relationship Models, JAD, Metadata, Meta-Data Management, Online Analytical Processing, Online Transaction Processing, Performance Tuning, Reverse Engineering, SQL Stored Procedures, PL-SQL, SQL Databases, Systems Integration, Unstructured Data, Data Lakes, Information Technology, Star Schema, Physical Design, Databricks - **Published:** May 15, 2026 - **Apply:** https://www.dice.com/job-detail/2609a997-7513-43d3-8f0f-65b63252e6e7 ## About the Role We are seeking a highly skilled Data Modeler to join our team, with expertise in designing, developing, and implementing data models and architectures using Azure Cloud technologies and Databricks. The ideal candidate will have extensive experience in creating relational, dimensional, and multidimensional models, along with a strong understanding of OLTP/OLAP systems. As a Data Modeler, you will play a critical role in transforming business needs into actionable data models that support key business processes and advanced analytics., * Extensive experience in OLTP/OLAP System and E-R Modeling (Entity-Relationship), designing database schemas like Star Schema and Snowflake Schema for relational and dimensional modeling. * Proficiency in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, and ER Diagrams. * Strong understanding of SQL and relational databases, with hands-on experience in forward and reverse engineering database schemas. * Expertise in Azure Cloud data and analytics services, and Databricks for scalable data engineering and analytics. * Hands-on experience in data modeling tools such as ER Studio, Erwin, and SQL DBM for creating and publishing diagrams, as well as analyzing data sources. * In-depth knowledge of data dictionaries and metadata management to ensure data integrity and consistency across models. * Experience with developing Data Dictionaries and maintaining metadata for data models. * Familiarity with ETL processes and data integration workflows, including documentation and specification creation. * Knowledge of the CPG is a plus, with an understanding of relevant data challenges and solutions. * Proven ability to create and maintain documentation for data models, ETL processes, and business requirements., * Bachelor's degree in computer science, Information Systems, or a related field. * 8+ years of experience in data modeling, architecture, and working with data warehouses and data lakes. * Hands-on experience with Azure Cloud technologies, Databricks, and related data services. * Strong analytical, problem-solving, and critical-thinking skills, with the ability to transform business needs into effective data models. * Excellent communication skills, with the ability to interact with technical and non-technical stakeholders. * Experience in ETL processes, data integration, and large-scale data management programs. ## Description * Collaborate with business stakeholders to gather and analyze user requirements through JAD sessions and other interactive methods. * Design and implement enterprise-wide data architecture for both structured and unstructured data. * Develop and maintain data models, including ER Diagrams, Star Schema, for OLTP and OLAP systems. * Provide architecture and consulting services for Business Intelligence initiatives and data-driven applications. * Create detailed ETL specification documents, flowcharts, and data flow diagrams for data migration and integration processes. * Perform data cleansing, transformation, and auditing to ensure data accuracy and consistency. * Develop database objects such as PL/SQL packages, stored procedures, and triggers in alignment with business objectives. * Design end-to-end data solutions using Azure Cloud technologies and Databricks, integrating multiple data sources such as files, databases, and real-time APIs. * Participate in the development of database schema design and performance optimization. * Work closely with cross-functional teams to ensure data architecture aligns with project timelines and business goals. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [WeAreDevelopers LIVE - Streaming HTML](https://www.wearedevelopers.com/videos/2135-wearedevelopers-live-streaming-html) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Scaling Bitcoin for global adoption](https://www.wearedevelopers.com/videos/153-scaling-bitcoin-for-global-adoption) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)