Senior Data Modeler

Title : Senior Data Modeler
Location : Hybrid-Richardson, TX
Duration : 4+ Months Contract

Job Summary
We are looking for a skilled and detail-oriented Senior Data Modeler to lead the design and development of advanced, enterprise-level data models. In this role, you will create conceptual, logical, and physical data models to support business intelligence, analytics, and operational workflows. You will collaborate across teams to ensure our data architecture aligns with business needs and industry standards.
Key Responsibilities
Design and maintain conceptual, logical, and physical data models for both structured and unstructured data.
Work closely with business stakeholders to collect requirements and translate them into scalable data structures.
Develop and manage data dictionaries, metadata repositories, and ER diagrams using tools such as ERwin and SQL Workbench.
Demonstrate hands-on experience in developing scalable data models for structured and unstructured data.
Ensure modeling consistency across transactional and analytical systems.
Partner with data governance teams to apply masking policies, validate data quality, and ensure regulatory compliance.
Implement data validation and reconciliation processes to maintain data accuracy through ingestion pipelines and reporting layers.
Collaborate with engineering teams on integrating models into ETL/ELT pipelines with tools such as Apache Airflow, IICS, and Snowflake.
Support migration projects by validating legacy models and transforming them for cloud-based platforms.
Contribute to model versioning, traceability, and auditing practices to ensure reproducibility and accountability.
Demonstrated ability to work in a distributed team environment, coordinating with stakeholders and team members located in different regions and time zones to ensure seamless communication and project alignment
Required Qualifications
Bachelor s degree in Information Systems, Computer Science, Mathematics, or a related field.
At least 5 years of experience in data modeling and database design.
Proficiency in data modeling tools such as ERwin, SQL Workbench, and DBT.
Strong knowledge of relational and dimensional modeling techniques.
Experience with metadata management and data governance frameworks.
Excellent communication and analytical skills with a proven ability to collaborate effectively.
Preferred Skills
Experience with cloud platforms such as AWS, Azure, or Snowflake.
Familiarity with data orchestration tools like Apache Airflow.
Knowledge of machine learning workflows and model deployment.
Experience with BI platforms and data visualization tools.
Understanding of CI/CD pipelines and DevOps principles.

Resource's typical working day:
Brand new initiative
Analyzing data and modeling to store into snowflake
Data mapping
Candidate will need to be able to understand and clean the incoming data

Must Have Skills:
Database and Metadata management skills
Good communication skills

Nice to have skills:
Devops
Business intelligence
Data visualization
Mission learning workflows

Years of Experience: 5-6 years

Education: Bachelor's in computer science

Software skills:
Snowflake
Apache airflow