Overview
On Site
$70 - $75
Contract - W2
Contract - 12 Month(s)
Skills
Snowflake
DBT
SnowSQL
Job Details
- Architecture Review & Optimization
- Assess the current Snowflake-based data platform architecture.
- Identify bottlenecks and inefficiencies in data transformation and processing.
- Recommend architectural improvements for scalability, performance, and cost-efficiency.
- Code & SQL Review
- Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic.
- Validate adherence to best practices in modularity, reusability, and performance tuning.
- Suggest improvements for query optimization and resource utilization.
- Performance Tuning
- Analyze slow-running queries and transformation pipelines.
- Implement strategies for warehouse sizing, clustering, caching, and materialization.
- Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
- Best Practices & Governance
- Establish coding standards and naming conventions for DBT and SnowSQL.
- Define data governance, lineage, and documentation practices.
- Recommend monitoring and alerting mechanisms for data pipeline health.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.