Junior Consultant - Data Engineering - DBT / SQL / Snowflake

Job Summary We are seeking a Junior Consultant to support a modern cloud data stack engagement focused on dbt-based transformation work. In this role, you will work under the direction of a senior technical lead, contributing to SQL-driven transformation logic, dbt model development, and Snowflake-based data work. The ideal candidate brings hands-on dbt transformation experience, strong foundational SQL, and working exposure to Snowflake or a comparable cloud warehouse. This is not a pure analytics or reporting role; the work is centered on transformation, loading logic, testing, and reliable delivery within an Agile environment. Key Responsibilities Develop and maintain dbt transformation pipelines under the direction of a senior technical lead. Write and optimize SQL used for transformation logic, data preparation, and warehouse-based development work. Work in Snowflake to query, transform, and manage data in support of production delivery. Build and maintain dbt models, including staging and transformation layers. Support data quality and validation activities, including dbt tests and automated testing practices. Follow established schemas, data models, naming standards, and delivery patterns defined by the senior lead and enterprise architecture team. Document models, transformations, and workflow logic as required. Participate in Agile delivery processes and collaborate effectively across time zones within a pod-based team structure. Required Qualifications 2+ years of experience in data engineering, analytics engineering, or closely related transformation-focused work. Hands-on experience using dbt for data transformations in a practical project or production environment. Strong SQL foundation, including joins, aggregations, and transformation logic. Experience working with Snowflake or transferable experience with a similar cloud data warehou