Analytics Engineer III: AI-Ready Data Pipelines

Sigma Systems, Inc.; Boston (MA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Sigma Inc. is seeking an Analytics Engineer III to design, develop, and maintain analytics-ready data models, semantic layers, and data pipelines that support reporting, advanced analytics, and AI-enabled solutions.

This role sits at the intersection of analytics engineering, data engineering, and artificial intelligence, applying software engineering principles to transform raw data into trusted, well-documented, reusable data products.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 5+ years of professional analytics engineering or data engineering experience.
• Advanced SQL and Python skills.
• Hands-on experience with data models and transformations using dbt or similar tools.
• Experience with software engineering practices: Git, code reviews, automated testing, CI/CD.
• Experience with data modeling and data architecture.
• Experience implementing semantic layers in lakehouse environments.
• Knowledge of data governance, privacy, and security best practices.

Responsibilities

• Design, build, test, and maintain analytics-ready data models and transformations using dbt, SQL, and Python.
• Implement metrics and business logic within a semantic layer for consistent definitions across reporting and AI apps.
• Develop metadata and documentation to enable AI agents to query data accurately.
• Build and support orchestrated data pipelines.
• Develop datasets, features, and embeddings for ML/AI analytics.
• Apply data quality testing, data contracts, and observability processes.
• Collaborate with stakeholders to translate requirements into scalable data solutions.
• Contribute to data architecture, modeling, and solution design.

Skills

SQL

Python

dbt

Data modeling

Data governance

Communication

Collaboration

Cloud lakehouse

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, Data Analytics

Tools

Git

CI/CD

dbt or similar data transformation tools

Amazon S3

Apache Iceberg

Trino

Job description

Sigma Inc. is seeking an Analytics Engineer III to design, develop, and maintain analytics-ready data models, semantic layers, and data pipelines that support reporting, advanced analytics, and AI-enabled solutions.

This role sits at the intersection of analytics engineering, data engineering, and artificial intelligence, applying software engineering principles to transform raw data into trusted, well-documented, reusable data products.