Analytics Engineer III — AI-Driven Data Modeling

Kelly Services; Boston (MA); Hybrid; USD 83,000 - 110,000; Full time

Job summary

Motion Recruitment Partners is seeking an Analytics Engineer III for a contract-to-hire opportunity. The role focuses on building analytics-ready data models, semantic layers, and data pipelines using SQL, Python, dbt, Dagster, and AWS.

It blends analytics engineering with data engineering and AI to transform raw data into trusted data products. The position involves collaboration with data engineers, AI engineers, analysts, and stakeholders to support reporting, machine learning, and AI-powered

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 using dbt or similar tools.
• Strong data modeling and analytics engineering understanding.
• Experience with Git, code reviews, CI/CD, and data pipelines.
• Experience with cloud-based data platforms or lakehouse environments.
• Knowledge 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 pipelines.
• 25% AI & Data Enablement: develop curated datasets, metadata, and context for AI agents and ML applications.
• 15% Collaboration & Engineering Standards: define requirements, improve data quality, maintain documentation, and follow best practices.

Skills

SQL

Python

Dagster

dbt

AWS

Education

Bachelor's degree or equivalent

Tools

dbt

Dagster

AWS

Job description

Motion Recruitment Partners is seeking an Analytics Engineer III for a contract-to-hire opportunity. The role focuses on building analytics-ready data models, semantic layers, and data pipelines using SQL, Python, dbt, Dagster, and AWS.

It blends analytics engineering with data engineering and AI to transform raw data into trusted data products. The position involves collaboration with data engineers, AI engineers, analysts, and stakeholders to support reporting, machine learning, and AI-powered