Junior Consultant - Data Engineering

14 hours, 15 minutes 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

Senior Data Platform Engineer

Upstart 1K-5K Banks

Upstart is hiring a Senior Data Platform Engineer to design and operate the data platform that makes Lakehouse data accessible, reliable, and usable across the company.

Apache Airflow Apache Spark AWS Databricks Java JavaScript Kafka Kotlin Machine Learning Python Scala
15 minutes ago

Senior Data Engineer, Air Dominance & Strike

Anduril Industries 1K-5K Aerospace & Defense

Anduril Industries is hiring an operations-focused engineer to build and scale internal software and data systems for its Air Dominance and Strike division, supporting production, field operations, and test workflows for advanced defense products.

Computer Vision dbt Looker Python React SQL Tableau TypeScript
1 hour ago

(1349) Finance Transformation Automation Associate

Nortal 251-1K Internet Software & Services

Nortal is hiring a Finance Transformation Automation Associate to support a LATAM remote team by automating financial and operational reconciliations and improving close efficiency for client-facing finance operations.

Agile JIRA JSON Python SFTP SQL
1 hour, 15 minutes ago

Database Analyst - Fuze Care Services

Fuze Health Health Care Providers & Services

Fuze Health is hiring a Database Analyst to manage and optimize the database infrastructure supporting hospice care providers with real-time pharmacy analytics, medication management, and cloud-connected healthcare services.

AWS EC2 HIPAA PowerShell SQL Server Windows Server
1 hour, 30 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