DBT SME - Data Modeling, 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 • Modeling Techniques: Vault 2.0, 3NF, Dimensional Modeling, etc. • Version Control: Git / CI-CD • Quality Tools: dbt-Elementary, dbt-Osmosis, or Great Expectations preferred