We are seeking an experienced ETL Developer with strong expertise in DBT, Snowflake, and modern Data Warehouse (DWH) practices. The ideal candidate will design, develop, and optimize data pipelines, manage Snowflake assets (dynamic tables, semantic models, tasks, streams), and ensure high‑performance scalable datasets for analytics and reporting.
Key Responsibilities
1. ETL / ELT Development
- Design, build, and maintain ETL/ELT pipelines using DBT and other modern tools.
- Develop modular, testable DBT models (staging, intermediate, marts).
- Implement CI/CD pipelines for DBT job deployments.
- Monitor pipeline performance and ensure high data quality.
2. Snowflake Development
- Build and manage:
- Dynamic Tables
- Semantic Views
- Stored Procedures (SP)
- Tasks and scheduling workflows
- Streams for change data capture (CDC)
- Implement Snowflake resource optimization including clustering, partitioning, caching, and warehouse sizing.
- Use Query Profile for performance tuning and troubleshooting.
- Manage Snowflake security (RBAC), data governance, and cost optimization.
3. Data Warehousing
- Design and enhance DWH structures using dimensional modeling (Star/Snowflake schema).
- Work with business stakeholders to translate requirements into scalable data models.
- Ensure reliability, data quality, lineage, and metadata documentation.
4. Performance Tuning
- Optimize SQL queries, DBT models, and Snowflake compute usage.
- Identify performance bottlenecks using Snowflake Query Profile and DBT artifacts.
- Implement best practices for incremental loads and materializations.
Required Skills & Experience
Technical Skills
- Strong SQL (complex joins, window functions, query optimization)
- Hands‑on expertise with DBT Core / DBT Cloud
- Advanced experience with Snowflake:
- Dynamic Tables
- Semantic Views
- Streams & Tasks
- Stored Procedures (JavaScript/Python)
- Snowflake Performance Tuning
- Query Profile analysis
- Experience with ETL/ELT pipeline design
- Familiarity with Airflow or similar orchestration tools (preferred)
- Understanding of CDC frameworks
- Strong understanding of data warehousing concepts (Kimball/Inmon)
Soft Skills
- Strong analytical and problem‑solving skills
- Excellent communication and documentation abilities
- Ability to work in Agile environments
Ownership mindset with attention to detail
