What are the responsibilities and job description for the Data Modeler position at CloudIngest?
Role: Data Modeler Engineer
Location: Atlanta, GA / Charlotte, NC / Raleigh, NC (On-Site)
Duration: 6-12 months with multiple extensions
Rate: $44/hr on W2 (NO C2C)
Required Skills
- Data Modeling
- Snowflake
- SQL (Advanced)
- SAS (data analysis understanding)
- ETL Concepts
- Data Warehousing
- ER Modeling
Job Description
- Design and implement enterprise-grade data models (logical & physical), define standards, support Snowflake architecture, and optimize data structures for performance and scalability.
- Conduct impact analysis and ensure model alignment with business needs.
- Engineered scalable ER models (Conceptual, Logical, Physical) for enterprise-grade data platforms.
- Designed high-performance Data Warehouse schemas (Star & Snowflake) for analytics optimization.
- Specialized in Dimensional Modeling (Kimball) and Data Vault 2.0 architecture.
- Developed optimized Fact & Dimension tables to support large-scale reporting and BI workloads.
- Leveraged Snowflake expertise for data modeling, clustering, and performance tuning.
- Utilized advanced SQL for complex transformations, validations, and query optimization.
- Partnered with ETL teams to architect efficient, scalable data pipelines.
- Ensured data integrity, governance, quality, and robust metadata management.
- Translated complex business requirements into scalable, future-ready data models.
- Built end-to-end Data Warehouse architecture (Staging → Core → Presentation/BI layers).
Salary : $44