Junior Analytics Engineer III

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

$60 - $80

We are seeking an experienced Analytics Engineer III for a contract-to-hire opportunity with a large, well-established organization in the higher education space. This role will focus on building and maintaining analytics-ready data models, semantic layers, and data pipelines using SQL, Python, dbt, Dagster, and AWS. The position combines analytics engineering, data engineering, and AI to transform raw data into trusted, reusable data products.

This is an opportunity to work with modern data technologies and help shape how AI and analytics are used across a complex organization. You will collaborate with data engineers, AI engineers, analysts, and business stakeholders to build the foundation for reporting, machine learning, and AI-powered applications. The ideal candidate enjoys hands-on engineering, solving complex data challenges, and exploring emerging technologies like LLMs, RAG, embeddings, and AI agents. This hybrid opportunity also offers professional development and the potential for long-term growth.

Contract Duration: Contract-to-hire

Required Skills & Experience

• 5+ years of experience in analytics engineering, data engineering, business intelligence development, or a related technical field.


• Advanced SQL and Python skills.


• Experience building data models and transformations using dbt or similar tools.


• Strong understanding of data modeling, data 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, documentation, governance, privacy, and security best practices.


• Ability to independently deliver complex technical solutions.


• Strong communication and cross-functional collaboration skills.

Desired Skills & Experience

• Experience with AWS, particularly S3.


• Familiarity with Apache Iceberg and Trino.


• Experience with Dagster or similar orchestration tools.


• Experience building semantic layers and standardized business metrics.


• Exposure to LLMs, RAG, embeddings, AI agents, or AI-driven analytics.


• Experience with metadata, data lineage, and context engineering for AI applications.


• Familiarity with machine learning pipelines and feature engineering.


• Experience with data contracts, observability, and automated data quality testing.


• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent experience.

What You Will Be Doing

Tech Breakdown

• SQL, Python, and dbt


• AWS, S3, Apache Iceberg, and Trino


• Dagster and data pipeline orchestration


• Semantic layers, LLMs, RAG, and AI-enabled analytics

Daily 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 machine learning applications.


• 15% Collaboration & Engineering Standards: Work with technical and business teams to define requirements, improve data quality, maintain documentation, and follow software engineering best practices.

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP's Employment Accommodation policy. Applicants need to make their needs known in advance.