Unknown Company

DBT SME - Data Modeling, Analytics Engineer

workfromhome, ma • Posted 4 days ago
Remote Contract Database

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
Back to Job Search