Data & Analytics Intern: BI Dashboards & ETL (Hybrid)

McNeil & Co.; Farmington (CT); Hybrid; USD 36,000 - 39,000; Full time

Benefits offered by this job

Arch benefits

Job summary

Arch Capital Services LLC offers an 8‑week summer internship in Farmington, CT, delivering hands‑on experience in the insurance data domain. You will join the Data and Analytics team to design ETL processes, build data pipelines, and create Power BI dashboards that reveal operational insights.

The program runs June 2, 2027 – July 23, 2027, in a hybrid setup (4 days onsite, 1 day from home). The hourly rate is $26–$28, and interns are eligible for select Arch benefits.

Qualifications

• Pursuing a bachelor’s degree in data Analytics, Data Science, Computer Engineering, Computer Science, Information Systems, Mathematics, Statistics, or related field.
• Minimum 3.0 GPA or higher.
• College level – Sophomore, Junior or Senior with graduation between Dec 2027 and May 2029.
• Proficiency in SQL; Python/Spark preferred; familiarity with AI-assisted analytics tools.

Responsibilities

• Collaborate with Data and Analytics on projects that support critical business priorities.
• Design ETL processes, develop data pipelines, and implement validation controls.
• Integrate data from source systems, databases, and APIs into the segment data warehouse.
• Support data quality with validation, profiling and cleansing techniques.
• Design and develop Power BI reports and dashboards for meaningful insights.
• Troubleshoot data sources, ETL processes, data pipelines and storage issues.
• Stay current with data warehousing, analytics, cloud platforms and responsible AI practices.
• Explore and apply AI-enabled tools to improve productivity and insight generation.
• Recommend improvements to data warehouse and analytics solutions.

Skills

SQL

Python

Power BI

Data warehousing

ETL concepts

Education

Bachelor’s degree in data Analytics/Data Science/CS

Tools

Snowflake

Databricks

Power BI

Job description

Arch Capital Services LLC offers an 8‑week summer internship in Farmington, CT, delivering hands‑on experience in the insurance data domain. You will join the Data and Analytics team to design ETL processes, build data pipelines, and create Power BI dashboards that reveal operational insights.

The program runs June 2, 2027 – July 23, 2027, in a hybrid setup (4 days onsite, 1 day from home). The hourly rate is $26–$28, and interns are eligible for select Arch benefits.