Plymouth Rock Assurance · 18 hours ago
Data Engineer Intern
Boston, MA
Internship
Onsite
Intern
$25/hr - $30/hrPlymouth Rock Assurance is a fast-growing, analytics-driven insurer, and they are seeking a Data Engineer Intern to join their Enterprise Advanced Analytics team. The role involves working with data scientists to architect and manage data pipelines that connect various sources and support strategic research initiatives.
Auto InsuranceFinancial ServicesInsurance
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
Qualification
Required
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
Company
Plymouth Rock Assurance
If you’ve found your way to our LinkedIn page, you’re likely here for one of two reasons: You’re reviewing insurance companies or you’re browsing new career opportunities.
Founded in 2001
1001-5000 employees
H1B Sponsorship
Plymouth Rock Assurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (11)
2024 (12)
2023 (6)
2022 (7)
2021 (5)
2020 (12)
Funding
Current Stage
Late StageLeadership Team
Bill Martin
President and CEO of Home Assurance
Max Malaret
Vice President of Claims - Independent Agency Auto Group
Recent News
Plymouth Rock
2025-10-14
2025-08-13
Company data provided by crunchbase