Senior Data Modeler – Snowflake
Job in
Indiana, Indiana County, Pennsylvania, 15705, USA
Listed on 2026-01-13
Listing for:
Relanto
Full Time
position Listed on 2026-01-13
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst, Data Warehousing, Data Science Manager
Job Description & How to Apply Below
Role Summary
We are seeking an experienced Data Modeler with strong expertise in Snowflake Data Cloud to design, optimize, and govern scalable data models that support analytics, reporting, and advanced data use cases.
Key Responsibilities- Design, develop, and maintain conceptual, logical, and physical data models optimized for Snowflake.
- Implement dimensional (Star/Snowflake schema) and normalized data models to support analytics and reporting.
- Translate business and functional requirements into scalable, high-performance data models.
- Optimize Snowflake schemas for query performance, cost efficiency, and scalability.
- Define and enforce data modeling standards, naming conventions, and best practices.
- Partner with Data Engineers to guide table design, clustering strategies, and data partitioning approaches.
- Support data governance, metadata management, and data lineage initiatives.
- Perform impact analysis for schema changes and manage versioning of data models.
- Work closely with BI and Analytics teams to ensure models meet reporting and dashboarding needs.
- Participate in design reviews and provide recommendations on data architecture improvements.
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
- Must have minimum 5+ years of relevant experience.
- Strong experience in data modeling (conceptual, logical, physical).
- Hands‑on expertise with Snowflake including:
- Schema design and optimization
- Clustering and performance tuning
- Understanding of micro‑partitioning
- Proficiency in SQL (advanced querying and optimization)
- Experience with dimensional modeling.
- Knowledge of Supply chain/Demand Planning.
- Familiarity with ETL/ELT pipelines and integration with Snowflake.
- Experience using data modeling tools such as Erwin, ER/Studio, Power Designer, Lucidchart, or similar.
- Understanding of data warehousing, data lakes, and modern cloud data platforms.
Mid‑Senior level
Employment TypeFull‑time
Job FunctionInformation Technology
IndustriesBusiness Consulting and Services
#J-18808-LjbffrPosition Requirements
10+ Years
work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×