Senior Analytics Engineer – dbt/SQL/Python – Boston, Ma

Motion Recruitment; Boston (MA); Hybrid; USD 140,000 - 210,000; Full time

Benefits offered by this job

Hybrid work environment

Professional development

Competitive salary

401(k)

Job summary

Motion Recruitment seeks a Senior Analytics Engineer to drive data, analytics, and AI capabilities. You will design analytics data architecture, semantic models, and scalable pipelines enabling enterprise reporting and AI solutions.

You will collaborate with engineers, analysts, researchers, and stakeholders while mentoring teams and setting engineering standards for data platforms.

Qualifications

• Bachelor’s degree or equivalent experience in a technical field.
• 8+ years of analytics/data engineering experience.
• Strong SQL and Python development skills.
• Experience with dbt or similar data transformation tools.
• Experience in data modeling and semantic layer design.

Responsibilities

• Architect scalable analytics-ready data models and enterprise data products.
• Lead lakehouse architectures using cloud-native tech.
• Define semantic layers, metrics, and business logic.
• Build AI-ready data interfaces and context frameworks.
• Oversee batch and event-driven data pipelines.
• Mentor engineers and drive cross-functional projects.
• Enforce testing, CI/CD, and code quality standards.
• Establish data quality, lineage, and governance practices.

Skills

Advanced SQL

Python development

dbt experience

Data modeling

Data architecture

Semantic layer design

Cloud data platforms

Git / CI/CD

Code reviews

Stakeholder communication

Education

Bachelor’s degree in CS / Data Science / IS / Analytics

Tools

dbt

Airflow

Trino/ Iceberg

AWS / Azure / GCP

Dagster

Job description

Job Description A leading higher education and research institution is seeking a Senior Analytics Engineer to help drive the next generation of data, analytics, and AI capabilities. This role will lead the design and development of analytics data architecture, semantic models, and scalable data pipelines that enable enterprise reporting, advanced analytics, and AI-powered solutions.

Working across analytics engineering, data engineering, architecture, and artificial intelligence, you will establish trusted, reusable data products and create the semantic foundation needed for AI agents, machine learning workflows, and business intelligence initiatives. This is a highly visible technical leadership role focused on solving complex data challenges, defining engineering standards, and shaping the future of data and AI platforms.

You will collaborate closely with engineers, architects, analysts, researchers, and business stakeholders while serving as a technical mentor and subject matter expert on strategic initiatives.

Required Skills & Experience

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Analytics, or a related field, or equivalent experience
• 8+ years of experience in analytics engineering, data engineering, or a related technical discipline
• Advanced SQL and Python development skills
• Extensive experience with dbt or similar data transformation frameworks
• Strong expertise in data modeling, data architecture, and semantic layer design
• Experience building scalable cloud-based data platforms and lakehouse architectures
• Hands-on experience with software engineering best practices including Git, testing, CI/CD, and code reviews
• Experience designing and supporting production data pipelines and orchestration frameworks
• Knowledge of data governance, privacy, security, and compliance practices
• Proven ability to lead complex technical initiatives and collaborate across technical and non-technical teams
• Excellent communication, mentorship, and stakeholder management skills

Desired Skills & Experience

• Advanced degree in a related technical field
• Experience with Apache Iceberg, Trino, AWS, or similar cloud data technologies
• Knowledge of Dagster or other workflow orchestration platforms
• Experience supporting AI and machine learning use cases through data engineering
• Familiarity with large language models (LLMs), Retrieval-Augmented Generation (RAG), embeddings, or text-to-SQL solutions
• Exposure to semantic knowledge models, metadata management, or knowledge graph technologies
• Familiarity with emerging AI integration standards and frameworks

What You Will Be Doing Daily Responsibilities

• 100% Hands-On Technical Leadership
• Architect and develop scalable analytics-ready data models and enterprise data products
• Design and implement modern lakehouse architectures using cloud-native technologies
• Establish and govern semantic layers, business metrics, and enterprise business logic
• Build AI-ready data interfaces and context frameworks that enable trusted analytics and AI applications
• Design and optimize batch and event-driven data pipelines
• Develop feature engineering, model scoring, and embedding pipelines to support analytics and machine learning initiatives
• Establish engineering standards for testing, source control, CI/CD, documentation, and code quality
• Implement data quality monitoring, lineage, observability, and governance frameworks
• Lead technical planning and execution of cross-functional projects
• Mentor engineers through architecture reviews, design guidance, and code reviews
• Evaluate emerging technologies and contribute to the long-term analytics and AI data strategy

The Offer

• Competitive salary and comprehensive benefits package
• Hybrid work environment
• Opportunity to influence enterprise-wide data and AI strategy
• Professional development and continuing education opportunities
• Collaborative and mission-driven culture
• Exposure to cutting-edge analytics, cloud, and AI technologies

You will receive the following benefits

• Medical Insurance
• Dental Benefits
• Vision Benefits
• Paid Time Off (PTO)
• 401(k)

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.