IT - Data Modeler (Intermediate Level)

Indotronix Avani Group
The Woodlands, TX, United States
1 day ago
Apply on candidateportal.ceipal.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Working hours
Regular working hours

Tech stack

Github Python (Programming Language) Azure Data Factory Snowflake Powerquery

Job description

Join a dynamic enterprise team in Spring, Texas, as an Intermediate Data Modeler. In this hands-on position, your expertise in DBT, Snowflake, and dimensional modeling will directly influence the analytical foundation of a leading organization. You’ll collaborate closely with business and technical teams to design scalable data models and shape the future of enterprise analytics. This is an onsite, contract opportunity designed for professionals eager to contribute and grow within a collaborative, innovative environment., Design, develop, and maintain robust star-schema data models, including fact and dimension tables.

  • Build, test, and support DBT models to deliver analytics-ready datasets.
  • Optimize and troubleshoot SQL workloads within the Snowflake environment.
  • Apply best practices in data modeling, including normalization, denormalization, and dimensional design.
  • Partner with Data Engineers, BI Developers, Product Owners, and business stakeholders to translate requirements into scalable solutions.
  • Participate in design discussions, peer reviews, and knowledge sharing to ensure consistent modeling standards.
  • Support data delivery from ingestion and transformation to the semantic layer for reporting and analytics.
  • Document modeling decisions and contribute to improvements in data architecture and engineering practices.

Requirements

Proven hands-on experience with DBT development and testing.

  • Strong proficiency in Snowflake and SQL optimization.
  • Track record of designing and implementing star-schema dimensional models.
  • Deep understanding of analytical data warehouse concepts, fact and dimension modeling.
  • Effective communicator able to collaborate across cross-functional teams and explain technical concepts to both technical and non-technical audiences.
  • Experience with GitHub for version control.

Preferred Skills

  • Experience with Azure Data Factory.
  • Familiarity with Python or Power Query.
  • DP-203 or SnowPro certifications., * Top 3 skill sets/technologies required for qualification: o Strong hands-on experience with DBT development and testing o Strong experience with Snowflake and SQL optimization o GitHub

Benefits & conditions

Opportunity to work onsite with a forward-thinking team in a collaborative environment.

  • Career growth through direct exposure to enterprise-scale analytics projects.
  • Supportive culture focused on professional development and knowledge sharing.
  • Face-to-face interviews for a streamlined, personal hiring experience.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on candidateportal.ceipal.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff Matthias Niehoff · World Congress 2024

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · World Congress 2026 Europe

6:36 min

Funding open source through GitHub Accelerator and Sponsors

Stormy Peters · World Congress 2023

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

2:55 min

Configuring secrets for GitHub Actions Codespaces and Dependabot workflows

Marcel Lupo · LIVE

Videos

See all

Related articles

See all