DBT SME - Data Modeling, Analytics Engineer

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.

• 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.

• 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 Big Query 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.

• Primary Data Warehouse:
  Big Query (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

• Mid‑Senior level

• Contract

• Information Technology
• IT Services and IT Consulting