Description

Role Overview
The Data Warehouse Engineer is responsible for developing and supporting Snowflake-based data warehousing solutions. The role partners with Data Engineering, Analytics, and Reporting teams to build scalable data models, develop transformations, optimize performance, and support reporting requirements. The engineer contributes to platform stability, security, and operational support while following established architecture, governance, and development standards.
 
This role is primarily responsible for hands-on development, administration, and support activities and is not intended to serve as an enterprise architecture, strategy, or advisory role.
Key Responsibilities
Data Modeling & Architecture
Build enterprise‑level Snowflake models including conformed dimensions, fact tables, and semantic views.
Document ERDs, modeling assumptions, and physical/logical architectures.
Adhere to established data modeling standards, naming conventions, and performance optimization best practices.
Transformation & Automation
Develop, test, and support SQL transformations across Snowflake data warehouse layers using Snowflake SQL and dbt.
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

Key Skills

Education

Any Graduate