CPT Data Architect Jobs
Data Architect roles on CPT require your school to certify the position directly integrates with your degree program, so your DSO authorization letter must name the role and employer before you start. Most programs authorize CPT for database design, cloud architecture, and enterprise data modeling work tied to coursework in data engineering or computer science.
Find CPT Data Architect JobsOverview
Showing 4 of 15+ Data Architect jobs
See all Data Architect Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new Data Architect roles.
Get Access To All JobsINTRODUCTION
At Plymouth Rock, a fast-growing, analytics-driven insurer, we believe data science can redefine how insurance operates. As a Data Engineer Intern/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.
BASIC 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.
COMPENSATION
- 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”
INTRODUCTION
At Plymouth Rock, a fast-growing, analytics-driven insurer, we believe data science can redefine how insurance operates. As a Data Engineer Intern/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.
BASIC 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.
COMPENSATION
- 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”
See all CPT Data Architect Jobs
Sign up for free to unlock all listings, filter by visa type, and get alerts for new CPT Data Architect Jobs.
Get Access To All JobsData Architect CPT: Frequently Asked Questions
Does a Data Architect role qualify for CPT authorization?
Yes, if your school's curriculum includes coursework in data engineering, database systems, cloud architecture, or enterprise information management, a Data Architect role is typically approvable for CPT. Your DSO will assess whether the specific duties, such as designing data models, building ETL pipelines, or managing cloud data warehouses, integrate directly with your academic program.
Can I do CPT part-time as a Data Architect while finishing coursework?
Part-time CPT, defined as 20 hours per week or fewer, is available without affecting your OPT eligibility. Full-time CPT of 12 months or more eliminates your OPT benefit entirely. Most students working as Data Architects during the school year choose part-time authorization to preserve their post-graduation OPT window.
How do I find Data Architect employers who accept CPT students?
Search Migrate Mate for Data Architect roles filtered to employers with documented visa filing history in technical occupations. Employers already familiar with Labor Condition Application filings and international student work authorization are more likely to have an onboarding process that handles CPT documentation without delays or last-minute offer rescissions.
What job duties must my CPT authorization letter specify for this role?
Your DSO authorization letter should list the specific technical duties, not just the title. For Data Architect roles, that means naming tasks like dimensional data modeling, cloud schema design, data governance framework implementation, or ETL architecture work. Generic language like 'data work' may not satisfy your school's CPT curriculum integration requirement and could create issues at I-9 verification.
Does CPT work as a Data Architect count toward H-1B specialty occupation evidence?
It can. CPT experience in a role requiring a specific degree field, which Data Architect typically does under computer science or information systems, helps establish the specialty occupation connection for a future H-1B visa petition. Keep your offer letter, job description, and any performance documentation. USCIS may request this when evaluating whether your prior work matches the petitioned position's degree requirement.