Data Engineer Intern: Cloud Pipelines & ML Prep

Plymouth Rock Assurance; Boston (MA); On-site; USD 34,000 - 41,000; Part time

Job summary

Plymouth Rock Assurance is seeking an enthusiastic Data Engineer intern/co-op to help modernize data pipelines and build cloud-native workflows. You will work with a team of data scientists to prepare data for SageMaker and support scalable ingestion from on-prem and cloud sources.

You will document workflows, contribute Python modules, and ensure robust data quality and monitoring across pipelines. Boston-based, hybrid collaboration with the analytics team.

Qualifications

• Pursuing or completed Master's in CS/IS/Data Engineering or related field.
• Experience building Python + SQL data pipelines or data-intensive workflows.
• Hands-on with AWS data platforms: S3, Glue, Step Functions (preferably).
• Experience with SQL Server and writing performant SQL.
• Comfort with Linux and bash; able to debug jobs and inspect logs.
• Familiarity with CI/CD, Git, and basic testing practices.
• Exposure to hybrid connectivity patterns (VPN/Direct Connect, hosted agents).
• Familiarity with data lake formats (Parquet) and schema evolution.
• Exposure to monitoring/alerting (CloudWatch, Datadog) and data quality patterns.
• Interest in ML data prep / feature pipelines for SageMaker.

Responsibilities

• Assist in modernizing legacy data pipelines into Python-based, cloud-native workflows using AWS Step Functions, AWS Glue, and S3.
• Build and improve ingestion pipelines moving data from SQL Server and other sources into AWS data lake.
• Improve pipeline performance, efficiency, and scalability with partitioning and incremental loads.
• Implement data quality checks and safeguards for repeatable, idempotent runs.
• Contribute to reusable Python modules for ingestion, transformations, and logging.
• Partner with data scientists/ML engineers to prepare curated datasets for SageMaker training/inference.
• Document code, workflows, and runbooks; keep documentation current as pipelines evolve.

Skills

Python

SQL

AWS

Data pipelines

Linux

CI/CD

SageMaker

SQL Server

CloudWatch

Parquet

Education

Master's in Computer Science

Tools

AWS Glue

AWS Step Functions

Amazon S3

Job description

Plymouth Rock Assurance is seeking an enthusiastic Data Engineer intern/co-op to help modernize data pipelines and build cloud-native workflows. You will work with a team of data scientists to prepare data for SageMaker and support scalable ingestion from on-prem and cloud sources.

You will document workflows, contribute Python modules, and ensure robust data quality and monitoring across pipelines. Boston-based, hybrid collaboration with the analytics team.