Data Engineer Intern/Co-op

re-zoo-me; Boston (MA); On-site; USD 34,000 - 41,000; Part time

Job summary

Plymouth Rock is seeking a Data Engineer inter/Co-op to join the Enterprise Advanced Analytics team in Boston. You’ll help modernize data pipelines, move data from on-prem to AWS, and collaborate with data scientists to prepare SageMaker-ready datasets.

The role focuses on building scalable, reliable, cloud-native workflows and maintaining robust documentation. Qualifications include a Master’s in CS/IS/Data Eng and hands-on experience with Python+SQL pipelines, AWS services (S3/Glue/Step

Qualifications

• Pursuing or completed Master’s in CS/Information Systems/Data Engineering or related field.
• Experience building Python + SQL data pipelines or data-intensive workflows.
• Familiarity with AWS services for data platforms (S3, Glue, Step Functions).
• 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 on-prem data extraction and hybrid connectivity patterns.
• Familiarity with data lake formats (Parquet, partitioning, schema evolution).
• Exposure to monitoring/alerting (CloudWatch, Datadog) and data quality patterns.
• Interest in ML data prep / SageMaker workflows.

Responsibilities

• Assist in modernizing legacy data pipelines into Python-based, cloud-native workflows on AWS.
• Build and improve ingestion pipelines from SQL Server/on-prem to AWS data lake.
• Improve pipeline performance, efficiency, and scalability.
• Implement data quality checks and safeguards for reliable runs.
• Contribute to reusable Python modules for ingestion, transformations, and logging.
• Collaborate with data scientists/ML engineers to prepare datasets for SageMaker.
• Document code, workflows, and runbooks; keep docs updated as pipelines evolve.

Skills

Python + SQL pipelines

AWS data services

SQL Server

Linux bash

CI/CD

Git

Testing practices

Data lake formats

Monitoring/alerts

SageMaker prep/ML data prep

Education

Master’s in CS/IS/Data Engineering

Tools

AWS S3

AWS Glue

AWS Step Functions

Job description

At Plymouth Rock, a fast-growing, analytics-driven insurer, we believe data science can redefine how insurance operates. As a Data Engineer inter/Co-op with our Enterprise Advanced Analytics team, you will work with a team of top-tier data scientists to generate breakthrough insights that drive profitable growth, operational excellence, and competitive advantage. You will work with the team to help architect and manage the data pipelines that connect internal systems, third-party sources, and advanced analytical platforms, directly enabling our most strategic research initiatives.

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 that move data from SQL Server and other on-prem + cloud sources into AWS (e.g., S3-backed data lake).
• Improve pipeline performance, efficiency, and scalability (e.g., partitioning strategies, incremental loads, reduced runtime/cost).
• Implement data quality checks and operational safeguards to support reliable, repeatable (idempotent) runs (e.g., validation rules, anomaly checks, retry-safe processing).
• Contribute to reusable Python modules for ingestion, transformations, quality checks, logging, and alerting.
• Partner with data scientists/ML engineers to prepare curated datasets for SageMaker training/inference workflows.
• Document code, workflows, and runbooks; keep documentation current as pipelines evolve.

Qualifications

• Currently pursuing or have completed a Master’s in Computer Science, Information Systems, Data Engineering (or related).
• Experience (projects, internships, or coursework) building Python + SQL data pipelines or data-intensive workflows.
• Familiarity with AWS services commonly used in data platforms, including S3, Glue, Step Functions (hands-on experience preferred).
• Experience working with SQL Server (or similar relational databases) 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 (e.g., VPN/Direct Connect, hosted agents, secure credential management) or tools for extracting from on-prem sources.
• Familiarity with data lake formats and practices (Parquet, partitioning, schema evolution).
• Exposure to monitoring/alerting (CloudWatch, Datadog) and data quality frameworks/patterns.
• Interest in ML data prep / feature pipelines for SageMaker.

Salary Range: $25/hr - $30/hr. Actual compensation will vary based on multiple factors, including employee knowledge and experience, role scope, business needs, geographical location, and internal equity.

About The Company

The Plymouth Rock Company and its affiliated group of companies write and manage over $2 billion in personal and commercial auto and homeowner’s insurance throughout the Northeast and mid-Atlantic, where we have built an unparalleled reputation for service. We continuously invest in technology, our employees thrive in our empowering environment, and our customers are among the most loyal in the industry. The Plymouth Rock group of companies employs more than 1,900 people and is headquartered in Boston, Massachusetts.Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”