Analytics Engineer III: AI-Driven Data & Pipelines

Motion Recruitment; Boston (MA); Hybrid; USD 120,000 - 165,000; Full time

Job summary

Motion Recruitment is seeking an Analytics Engineer III for a contract-to-hire role in a hybrid environment in the Boston area. The candidate will design analytics-ready data models, semantic layers, and data pipelines using SQL, Python, dbt, Dagster, and AWS.

Collaboration across data engineers, AI engineers, analysts, and business stakeholders is essential to deliver reporting, ML, and AI-powered applications.

Qualifications

• 5+ years of experience in analytics engineering, data engineering, BI development, or related field.
• Advanced SQL and Python skills.
• Experience building data models and transformations with dbt or similar tools.
• Strong understanding of data modeling, architecture, and analytics engineering principles.
• Experience with Git, code reviews, automated testing, and CI/CD.
• Experience building, maintaining, and troubleshooting data pipelines.
• Experience with cloud-based data platforms or lakehouse environments.
• Understanding of data quality, governance, privacy, and security best practices.
• Ability to independently deliver complex technical solutions.
• Strong communication and cross-functional collaboration skills.

Responsibilities

• 60% Hands-On Engineering: Build, test, and optimize data models, SQL transformations, semantic layers, and data pipelines.
• 25% AI & Data Enablement: Develop curated datasets, metadata, and structured context to support AI agents, LLMs, RAG workflows, and ML apps.
• 15% Collaboration & Engineering Standards: Define requirements, improve data quality, maintain docs, and follow software engineering best practices.
• Support the design of analytics-ready data products and secure data governance practices.

Skills

Advanced SQL

Python

dbt

Dagster

AWS

Data modeling

Data pipelines

CI/CD

Data governance

Cross‑functional collaboration

Education

Bachelor's degree in CS/IS/Data Science or related field

Tools

Git

Dagster

Trino

Apache Iceberg

AWS S3

Job description

Motion Recruitment is seeking an Analytics Engineer III for a contract-to-hire role in a hybrid environment in the Boston area. The candidate will design analytics-ready data models, semantic layers, and data pipelines using SQL, Python, dbt, Dagster, and AWS.

Collaboration across data engineers, AI engineers, analysts, and business stakeholders is essential to deliver reporting, ML, and AI-powered applications.