Junior Consultant - Data Engineering

3 weeks, 4 days ago
Junior
Software Development
Formativ Group

Formativ Group

We are focused on enabling dynamic workflows, implementing the right application solutions, and ensuring your data is available when and where it’s needed.

Internet Software & Services

Description

  • Develop and maintain dbt transformation pipelines under the direction of a senior technical lead.
  • Write and optimize SQL for transformation logic, data preparation, and warehouse-based development.
  • Work in Snowflake to query, transform, and manage data for production delivery.
  • Build and maintain dbt models, including staging and transformation layers.
  • Support data quality and validation through dbt tests and automated testing practices.
  • Follow established schemas, data models, naming standards, and delivery patterns set by the senior lead and enterprise architecture team.
  • Document models, transformations, and workflow logic as required.
  • Participate in Agile delivery processes and collaborate across time zones within a pod-based team structure.

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 with Snowflake or similar cloud data warehouse platforms 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 the ability 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 and 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.

Benefits

  • Equal opportunity employer with accommodations available for individuals with disabilities.
  • Opportunity to work within a cloud architecture, system integration, AI, and data strategy consulting environment.
  • Supportive team structure with senior technical lead guidance and cross-time-zone collaboration.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Engineer

INflow Federal 51-250 Aerospace & Defense

INflow Federal is seeking a fully remote Data Engineer to support a Department of Defense modernization initiative by building secure data pipelines and analytics infrastructure across cloud environments.

Agile AWS CI/CD DevSecOps DynamoDB Encryption JSON MongoDB PostgreSQL Power BI Python REST API SQL SQL Server Tableau XML
1 hour, 50 minutes ago

Data Engineer, Azure - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote Data Engineer, Azure to build and optimize data pipelines and warehousing solutions for client projects across Latin America.

Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL Tableau
2 hours, 20 minutes ago

Senior DataOps Engineer- Remote US

Smile Digital Health 251-1K IT Services

Smile Digital Health is hiring a Senior DataOps Engineer to own analytics infrastructure and data processing environments for its remote U.S. clinical intelligence product team.

Ansible Apache Airflow Apache Spark AWS Azure CI/CD Databricks GCP GitHub Actions GitLab CI Java Jenkins Kubernetes Linux Prefect Python Scala Terraform
2 hours, 35 minutes ago

Staff Data Engineer

CookUnity 251-1K Hotels, Restaurants & Leisure

CookUnity is hiring a Data Engineer to help rebuild and scale the company’s B2C data foundation by designing production-ready pipelines and data systems for a rapidly growing food marketplace.

Apache Spark Flink Java Kafka Kubernetes Python Scala Snowflake SQL
4 hours, 58 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers