Snowflake Engineer

ole Overview

The Data Warehouse Engineer serves as the primary technical lead for the Snowflake data warehousing ecosystem. This role is responsible for designing scalable data models, managing Snowflake environments, optimizing performance and cost, enforcing security policies, and supporting analytics and enterprise reporting platforms, including Business Objects (BIC), across the organization. The DW Engineer ensures that Snowflake is stable, secure, and aligned with enterprise architecture standards, and collaborates with Platform Administrators and third‑party vendors to ensure reporting platform uptime and timely escalation of issues impacting reporting availability.

Key Responsibilities

Data Modeling & Architecture

• Design enterprise‑level Snowflake models including conformed dimensions, fact tables, and semantic views.
• Document ERDs, modeling assumptions, and physical/logical architectures.
• Establish and enforce modeling standards, naming conventions, and performance optimization patterns.

Transformation & Automation

• Build advanced SQL transformations across all Snowflake layers.
• Implement automated workflows using Tasks, Streams, procedures, and time‑based orchestration.
• Support schema evolution and large‑scale data integration patterns.

Environment & Release Management

• Coordinate Snowflake schema and object deployments via Git or CI/CD pipelines.
• Own release readiness for Snowflake across Dev, Test, and Prod.
• Ensure new models, views, RBAC changes, and stored procedures are validated prior to promotion.

Performance Optimization

• Conduct performance tuning through micro‑partition analysis, clustering, query plan reviews, and caching strategies.
• Implement Resource Monitors, usage alerts, and proactive performance dashboards.
• Review warehouse utilization to ensure compute resources are right‑sized and cost‑optimized.

Security, RBAC & Controls

• Design and maintain Snowflake role hierarchies, object privileges, row‑level security, and masking policies.
• Support audit requests, compliance checks, and evidence gathering for reviews.
• Govern secure internal and external data sharing.

Cost Management

• Produce recurring consumption reports to support conduct cost optimization analysis.
• Recommend improvements in warehouse sizing, retention policies, storage optimization, and compute scheduling.

Cross‑Functional Collaboration

• Work with Data Engineers to coordinate ingestion design, transformation logic, and schema updates.
• Partner with BI teams to optimize datasets for Power BI, Qlik, and analytical tools.
• Align with Platform Administrators on environment setup, migrations, and operational readiness.

Documentation & Governance

• Maintain transformation specifications, lineage, and architectural diagrams.
• Ensure models and pipelines comply with governance policies and development standards.

Enterprise Operational Reporting Platform (Web Intelligence)

• Collaborate with Platform Administrators and the vendor to ensure reporting platform uptime and timely escalation of reporting issues.

Skills & Tools Requirements

• Snowflake SQL : 5+ years of advanced SQL development experience, including complex query optimization, data modeling, performance tuning, and ETL/ELT development within Snowflake environments.
• Snowflake Administration : 3+ years of hands-on experience administering Snowflake platforms, including security, role-based access control (RBAC), warehouse management, monitoring, performance optimization, and cost governance.
• dbt (Data Build Tool) : 4+ years of experience designing, developing, and maintaining scalable data transformation frameworks using dbt, including testing, documentation, and CI/CD integration.
• Git / Version Control : 5+ years of experience using Git-based source control systems (GitHub, GitLab, or Bitbucket) for collaborative development, branching strategies, code reviews, and release management.
• CI/CD Pipelines & Deployment Automation : 5+ years of experience implementing and supporting CI/CD pipelines for data warehouse and analytics deployments, including automated testing, code promotion, release management, and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or equivalent platforms
• Financial services experience : Preferred.
• Business Objects (SAP BO/Web Intelligence) : Preferred.