DBT Analytics Engineer

Responsibility

Job Position: DBT Analytics Engineer
Domain: Data Warehousing / Analytics Engineering
Work Mode: Remote
Experience: 5–7 Years
Primary Technologies: dbt, Snowflake, SQL
Certification: dbt Analytics Engineering Certification – Mandatory

Role Summary

We are looking for an experienced DBT Analytics Engineer with strong expertise in data modelling, dbt, and Snowflake. The ideal candidate should have hands-on experience with Kimball dimensional modelling and the ability to transform complex legacy data into reliable, scalable, and business-friendly analytical models.

• Design and develop dimensional data models using the Kimball methodology, including fact tables, dimension tables, and star/snowflake schemas.

• Build, maintain, and optimize scalable dbt models in Snowflake.

• Transform complex, unnormalized legacy data into a reliable single source of truth.

• Implement data quality tests, documentation, and data lineage to ensure data reliability and transparency.

• Optimize SQL queries and analytical models for performance and scalability.

• Collaborate with reporting analysts and business stakeholders to translate requirements into effective data models.

• Communicate modelling decisions, code changes, and downstream impacts clearly to relevant stakeholders.

• 5–7 years of experience in data warehousing, analytics engineering, or data modelling.

• Strong expertise in Kimball dimensional modelling, including:

  • Star and snowflake schemas

  • Fact and dimension tables

  • Slowly Changing Dimensions (SCD) Types 1 and 2

• Hands-on experience with dbt Core and/or dbt Cloud, including models, tests, incremental models, documentation, and Jinja.

• Active dbt Analytics Engineering Certification from dbt Labs is mandatory.

• Strong experience with Snowflake, advanced SQL, query optimization, and performance tuning.

• Experience handling complex business logic, unnormalized datasets, and cross-system data integration.

• Strong technical communication, analytical thinking, and problem-solving skills.

• Experience working with ERP, financial, accounting, payroll, or HCM data.

• Familiarity with enterprise platforms such as SAP, Oracle, Deltek, or CMiC.

DBT | Analytics Engineering | Snowflake | Advanced SQL | Kimball Methodology | Dimensional Modelling | Star Schema | Snowflake Schema | Fact & Dimension Tables | SCD Type 1 & 2 | dbt Core | dbt Cloud | Jinja | Data Warehousing | Data Quality | Data Lineage | Query Optimization | Legacy Data Transformation | ERP | HCM