Sr. Snowflake Data Engineer - Semantic Layer
Location: Hybrid
We are seeking an experienced Snowflake Data Engineer with Semantic Layer expertise to design, develop, and optimize enterprise-scale data platforms. The ideal candidate will have strong experience in Snowflake Data Cloud, data modeling, semantic layer design, ELT/ETL development, and BI reporting integration. The role involves building governed, business-friendly data models that enable self-service analytics and consistent reporting across the organization.
Key Responsibilities
Snowflake Data Engineering
- Design, develop, and maintain scalable data pipelines on Snowflake.
- Implement ELT/ETL processes using Snowflake, SQL, Python, and cloud-native data integration tools.
- Optimize Snowflake performance through clustering, partitioning, query tuning, and warehouse sizing.
- Build and manage data ingestion frameworks for structured and semi-structured data.
- Implement data security, governance, and access control policies within Snowflake.
Semantic Layer Development
- Design and maintain enterprise semantic models that provide a single source of truth for business metrics.
- Build reusable business definitions, KPIs, metrics, dimensions, and hierarchies.
- Develop governed semantic layers supporting self-service analytics.
- Ensure consistency across reporting and analytics platforms.
- Collaborate with business stakeholders to translate business requirements into semantic models.
Data Modeling
- Design dimensional models (Star Schema and Snowflake Schema).
- Create fact and dimension tables optimized for analytics workloads.
- Develop data marts supporting multiple business domains.
- Apply data warehousing best practices and industry standards.
BI & Analytics Integration
- Integrate semantic models with BI tools such as Power BI, Tableau, Looker, Sigma, or ThoughtSpot.
- Support reporting, dashboards, and ad-hoc analytics requirements.
- Enable governed self-service reporting capabilities.
- Ensure data accuracy and consistency across analytical platforms.
Data Quality & Governance
- Implement data quality checks and validation frameworks.
- Create reconciliation processes and monitoring dashboards.
- Maintain metadata, lineage, cataloging, and documentation.
- Support data governance and compliance requirements.
Technical Skills
- Strong expertise in Snowflake Data Cloud.
- Advanced SQL development and optimization.
- Experience with Semantic Layer technologies such as:
- Snowflake Semantic Model
- dbt Semantic Layer
- AtScale
- Cube
- LookML (Looker)
- Power BI Semantic Models
- Data Warehousing and Dimensional Modeling.
- ETL/ELT development expertise.
- Python programming.
- Experience with cloud platforms:
Data Integration Tools
- Dbt, Fivetran, Matillion, Informatica, ADF (Azure Data Factory), Airflow
BI & Visualization Tools
- Power BI, Tableau, Looker, Sigma Computing, ThoughtSpot
Version Control & DevOps
- Git, GitHub / GitLab / Azure DevOps, CI/CD, Agile delivery methodologies
Preferred Qualifications
- Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
- Snowflake Certification:
- SnowPro Core Certification (Preferred)
- SnowPro Advanced Data Engineer (Preferred)
- Experience implementing enterprise semantic layer architecture.
- Experience working in large-scale cloud analytics environments.
Nice to Have
- Experience with Data Vault 2.0.
- Knowledge of AI/ML data preparation pipelines.
- Experience with Microsoft Fabric or Databricks.
- Exposure to data catalog and governance tools such as Collibra, Alation, or Microsoft Purview.
Key Competencies
- Strong stakeholder management skills.
- Business requirement analysis and translation.
- Problem-solving and analytical thinking.
- Data governance and quality mindset.
- Excellent communication and collaboration skills.
- Leadership and mentoring capabilities.
The successful candidate will
- Deliver a scalable and governed Snowflake data platform.
- Build robust semantic models that standardize business metrics.
- Enable self-service analytics across business functions.
- Improve reporting consistency, data quality, and query performance.
- Drive adoption of modern data engineering and semantic modeling best practices.