Junior Consultant - Data Engineering
New
Remote / PAN-IndiaContractJunior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 2+ years
- Required Skills
- SQLAgileETLSCRUMSnowflakeAirflowCI/CDdbtRedshift
Requirements
- 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 warehouse such as Redshift.
- Understanding of ETL / ELT and how raw data is transformed into usable downstream data sets.
- Experience with or exposure to dbt testing and validation practices.
- Ability to work within established schemas and modeling patterns rather than owning warehouse design from scratch.
- Clear communication skills and enough polish to work effectively with a senior lead and distributed team.
- Exposure to dbt Cloud and dbt Core, with preference for dbt Cloud familiarity.
- Experience with automated testing, CI/CD workflows, or slim CI in a dbt context.
- Exposure to Airflow, Fivetran, Airbyte, or similar orchestration / ingestion tools.
- Basic awareness of data modeling concepts such as dimensional models or star schema patterns.
- Exposure to Agile or Scrum delivery environments.
- Relevant dbt or Snowflake certifications.
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.
View Full Description & ApplyYou'll be redirected to the employer's site