NC
Data Modeler Engineer
NR Consulting LLC
πΊπΈ United States
On-site
3 months ago
- SQL
- SAS
- ETL
- Snowflake
- Vault
3 months ago
Location: Atlanta/Charlotte/Raleigh (No Remote)
Duration: 12+months (Long Term)
Employment Type: Contract
Required Skills
- Data Modelling, BIAN, FIBO, SnowflakeDB , SQL (Advanced), SAS (data analysis understanding), ETL Concepts, Data Warehousing, ER Modelling
Job Descriptions:
- 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 Modelling (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 modelling, 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)
Data Modeler Engineer Β· NR Consulting LLC