Job Title: Enterprise Data Modeler – Snowflake Specialist
Location: [Remote ]Experience Required: 6+ YearsEmployment Type: [Contract]Start Date: ImmediateRole OverviewWe are seeking a highly skilled Enterprise Data Modeler with deep expertise in Snowflake and modern data modeling techniques. This role requires end-to-end experience in designing scalable, robust, and production-ready data models that align with complex business requirements and support analytics, reporting, and KPI logic. The ideal candidate has practical, hands-on experience—not just theoretical knowledge—of enterprise-level data modeling in real client projects.Key Responsibilities
- Lead the design and development of conceptual, logical, and physical data models using Snowflake.
- Collaborate with business and technical stakeholders to understand KPIs, metrics, and data flows to drive appropriate data architecture.
- Create technically sound, scalable data models using best-practice design patterns (e.g., Dimensional, Data Vault, Normalized).
- Translate complex and ambiguous business problems into structured Snowflake-ready models, including schema, table, and column-level specs.
- Develop schema objects such as views, constraints, partitions, clustering, and leverage Snowflake features like Time Travel, Zero-Copy Cloning, etc.
- Support downstream Power BI and data mart readiness, ensuring models are optimized for semantic and reporting layers.
- Design for historical and incremental loading (e.g., SCDs, CDC, audit columns, soft deletes).
- Produce clear and concise documentation including data flow diagrams, ER diagrams, lineage maps, and model architecture visuals.
- Collaborate closely with data architects and engineers to ensure model fitment within the larger data warehouse architecture.
- Ensure models support governance, metadata frameworks, and comply with enterprise data standards.
Required Skills And Qualifications
- 6+ years of enterprise-level experience in data modeling across client-facing or production projects.
- Deep hands-on expertise with Snowflake SQL and schema design, including performance optimization.
- Strong understanding of data warehousing concepts, including:
- Dimensions, Facts, Surrogate Keys
- Star vs Snowflake Schema
- Normalization, Fact Grains, SCD Types
- ELT vs ETL, Semantic Layers, Data Vault
- Proficiency in using tools like Lucidchart, SQLDBM, dbt docs, or similar to create ERDs and architecture visuals.
- Ability to confidently present and defend data model decisions in technical review and stakeholder walkthroughs.
- Strong verbal and written communication skills in English.
- Ability to work independently, lead discussions with minimal handholding, and resolve ambiguity in business requirements.
Nice to Have
- Experience with metadata-driven modeling and data governance initiatives.
- Exposure to modeling strategies that support Power BI, KPI tracking, and cross-platform analytics.
- Knowledge of data lineage mapping, version control of models, and model lifecycle management.
Skills: data warehousing,snowflake,modeling,elt,enterprise data,enterprise,snowflake sql,dimensional modeling,sqldbm,performance optimization,metadata frameworks,data vault,models,data,normalization,lucidchart,data governance,dbt docs,etl,architecture,data modeling
