Data & Analytics Intern: Build Pipelines & Dashboards

Arch Capital Group Ltd.; Farmington (CT); Hybrid; USD 36,000 - 39,000; Full time

Benefits offered by this job

Arch benefits

Job summary

Arch Capital Group Ltd. in Farmington, CT offers an 8-week summer data analytics internship with a hybrid schedule (4 days onsite, 1 day remote).

You will collaborate with Data & Analytics to design ETL processes, build data pipelines, and develop Power BI reports, gaining hands-on experience in data warehousing and AI-assisted analytics. The role targets sophomores, juniors or seniors graduating between December 2027 and May 2029, with a minimum 3.0 GPA and a strong desire to learn.

Qualifications

• Actively pursuing a bachelor’s degree in data analytics or related field.
• Minimum 3.0 GPA.
• Graduation between Dec 2027 and May 2029.
• Strong curiosity and willingness to learn.

Responsibilities

• Collaborate with Data & Analytics on projects supporting business priorities.
• Design ETL processes and data pipelines with validation controls.
• Integrate data into the segment data warehouse from multiple sources.
• Support data quality through validation, profiling, and cleansing.
• Create Power BI reports and dashboards to provide insights.
• Troubleshoot data sources, ETL, and storage issues.
• Stay current with data warehousing, analytics, cloud tech, and AI-enabled tools.
• Apply AI-assisted analytics to improve productivity and insights.
• Recommend improvements and assist with new capabilities.

Education

Bachelor's degree

Tools

Power BI

Snowflake

Databricks

SQL

Python

Job description

Arch Capital Group Ltd. in Farmington, CT offers an 8-week summer data analytics internship with a hybrid schedule (4 days onsite, 1 day remote).

You will collaborate with Data & Analytics to design ETL processes, build data pipelines, and develop Power BI reports, gaining hands-on experience in data warehousing and AI-assisted analytics. The role targets sophomores, juniors or seniors graduating between December 2027 and May 2029, with a minimum 3.0 GPA and a strong desire to learn.