Job Description


Job Title: Snowflake Architect – Snowflake & DBT Modernization
Location: Jersey City, NY – - Days onsite
Long Term Project

Key Responsibilities:
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.
  • Gu...

    • Apply for this Position

    Ready to join HAN? Click the button below to submit your application.

    Submit Application