Data and Analytics Intern

Arch Insurance Group Inc.•Farmington, CT

2d•$26 - $28•Hybrid

About The Position

Arch’s 8-week summer internship program provides hands-on experience in the insurance industry through challenging learning experiences, professional development, collaboration with specialty insurance professionals, and ongoing feedback. The Data and Analytics Intern collaborates with the Data and Analytics team and business partners on projects supporting critical business priorities. The role supports data warehousing, integration, quality, analytics, and reporting initiatives, including the responsible use of AI-enabled tools. The internship runs from June 2, 2027, through July 23, 2027. It is hybrid, with four onsite days and one work-from-home day each week, and is located in Farmington, Connecticut. Relocation and housing assistance are not provided. The hourly pay range is $26–$28 for individuals assigned to or hired to work in Farmington, CT. The intern position is eligible for select Arch benefits.

Requirements

Actively completing a bachelor’s degree in Data Analytics, Data Science, Computer Engineering, Computer Science, Information Systems, Mathematics, Statistics, or a related program.
Minimum GPA of 3.0.
Sophomore, junior, or senior college student with a graduation date between December 2027 and May 2029.
Basic understanding of data warehousing, ETL concepts, business intelligence, and data integration patterns.
Curiosity and foundational knowledge of AI, machine learning, prompt engineering, or AI-assisted analytics tools.
Familiarity with CI/CD concepts and software development lifecycle practices.
Proficiency or strong coursework experience in SQL.
Ability to use AI-assisted tools responsibly to improve development, analysis, and problem-solving outcomes.
Effective collaboration as a team player.
Ability to work independently and manage multiple tasks and priorities in a fast-paced environment.
Entrepreneurial spirit and desire to be a continuous learner.

Nice To Haves

Exposure to Snowflake, Databricks, Power BI, or similar database, ETL, and reporting tools.
Python or Spark skills.

Responsibilities

Collaborate with the Data and Analytics team and business partners on projects that support critical business priorities.
Design ETL processes, develop data pipelines, and support implementation of validation controls to help ensure data accuracy and reliability.
Integrate data from source systems, databases, APIs, and third-party applications into the segment data warehouse based on business needs.
Support data quality activities using validation, profiling, and cleansing techniques.
Design and develop Power BI reports and dashboards that provide insights into business operations.
Troubleshoot and help resolve issues related to data sources, ETL processes, data pipelines, and data storage.
Stay current with technologies, trends, and best practices in data warehousing, analytics, cloud platforms, and responsible AI-assisted development.
Explore and apply AI-enabled tools to improve productivity, automate repeatable tasks, support data quality analysis, and accelerate insight generation.
Recommend improvements to existing data warehouse and analytics solutions and support implementation of new capabilities using modern technologies.