Description

You will design, build, and maintain analytics-ready data models using DBT and Snowflake, ensuring scalable and high-performance data processing.

This role is on-site.

Responsibilities

• Design and develop analytics layers using fact and dimension tables with star and snowflake schemas.
• Refactor complex SQL logic into modular, reusable, and versioned DBT models.
• Establish and enforce DBT best practices including naming conventions, testing, and documentation.
• Own data quality and testing strategies using built-in and custom dbt tests.
• Optimize SQL and Snowflake performance through efficient query design and tuning.

Required Skills

• Expert-level Snowflake SQL skills (joins, CTEs, window functions, query optimization).
• Strong understanding of relational databases and large-scale data processing.
• Proven experience in performance tuning and scalable data model design.
• Strong hands-on experience with DBT Core: models, sources, seeds, snapshots, and incremental materializations.
• Proficiency in Jinja templating (macros, variables, conditional logic).
• Experience with DBT testing (not null, unique, accepted values) and schema.yml documentation.
• Version control using GitHub.
• Familiarity with Fivetran or Airflow for job orchestration.
• Working knowledge of Unix/Linux commands.

Preferred Skills

• Exposure to cloud data platforms and cost optimization strategies.
• Working knowledge of Power BI and Python.

Referral Bonus: ₹50,000

Key Skills

Education

Bachelor's degree