DBT SME - Data Modeling, Analytics Engineer

Gardner Resources Consulting, LLC
Boston, US
Hybrid

Job Description

Lead Analytics Engineer

We're seeking a Lead Analytics Engineer to help design, model, and scale a modern data environment for a global software organization. This role will play a key part in organizing and maturing that landscape as part of a multi-year strategic roadmap. This position is ideal for a senior-level analytics engineer who can architect data solutions, build robust models, and stay hands-on with development.

  • This is a remote role with occasional onsite meetings. Candidates must currently be local to the Boston area and reside in MA/CT/RI/NH/ME.
  • Long term contract. W2 or c2c.

Highlights

  • Architect and build new data models using dbt and modern modeling techniques.
  • Partner closely with leadership and business teams to translate complex requirements into technical solutions.
  • Drive structure and clarity within a growing analytics ecosystem.

Qualifications

  • Bachelor's degree in Economics, Mathematics, Computer Science, or related field.
  • 10+ years of experience in an Analytics Engineering role.
  • Expert in SQL and dbt with demonstrated modeling experience
  • Data Modeling & Transformation: Design and implement robust, reusable data models within the warehouse. Develop and maintain SQL transformations in dbt.
  • Data Pipeline & Orchestration: Build and maintain reliable data pipelines in collaboration with data engineering. Utilize orchestration tools (Airflow) to manage and monitor workflows. Manage and support dbt environments and transformations.
  • Hands-on experience with BigQuery or other cloud data warehouses.
  • Proficiency in Python and Docker.
  • Experience with Airflow (Composer), Git, and CI/CD pipelines.
  • Strong attention to detail and communication skills; able to interact with both technical and business stakeholders.

Technical Requirements

  • Primary Data Warehouse: BigQuery (mandatory)
  • Nice to Have: Snowflake, Redshift
  • Orchestration: Airflow (GCP Composer)
  • Languages: Expert-level SQL / dbt; strong Python required
  • Other Tools: GCP or AWS, Fivetran, Apache Beam, Looker or Preset, Docker
  • Version Control: Git / CI-CD
  • Quality Tools: dbt-Elementary, dbt-Osmosis, or Great Expectations preferred

Seniority level

  • Mid-Senior level

Employment type

  • Contract

Job function

  • Information Technology
  • IT Services and IT Consulting

J-18808-Ljbffr

Skills & Requirements

Technical Skills

SqlDbtPythonDockerAirflowGitCi/cdCommunicationFinance

Employment Type

CONTRACT

Level

mid

Posted

4/26/2026

Apply Now

You will be redirected to Gardner Resources Consulting, LLC's application portal.