Senior Data Modeler
- Prudent Consulting
20 Days Ago
NA
NA
Richardson-TX
8-12 Years
Required Skills: AWS, Azure, Snowflake, Apache Airflow, machine learning workflows, model deployment, Bi platforms, data visualization tools, Ci/CD pipelines, DevOps principles, Data modeling and database design, ERwin, SQL Workbench, DBT, metadata management, data governance frameworks
Job Description
Must work onsite mon-tues-wed at the Client Richardson office.
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.
