Data Engineering Intern

Transverse Insurance Group; New York (NY); Sur place; USD 110 000 - 160 000; Plein temps

Résumé du poste

MS Transverse is seeking a data engineering professional to design, develop, and maintain data pipelines on Azure Databricks using PySpark and SQL. You will contribute to Kimball-style dimensional models supporting actuarial, underwriting, claims, and reinsurance teams.

The role requires pursuing a Master’s in Data Science or related field and Databricks Data Engineer certification, with research experience preferred. Collaboration with cross-functional teams will be essential.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Familiarity with Databricks platform and PySpark.
• Knowledge of Kimball-style dimensional modeling.
• Working knowledge of Claude Code and the Claude ecosystem.
• Git and version-controlled development workflows.

Responsabilités

• Support the design, development, and maintenance of Bronze, Silver, and Gold layer pipelines in Azure Databricks using PySpark and SQL
• Contribute to Kimball-style dimensional models (fact and dimension tables) for internal MST teams
• Build data quality checks and validation logic to keep Lakehouse data accurate and timely
• Contribute to internal automation tooling and Claude skills with a human-in-the-loop approach
• Document technical work clearly for technical and non-technical stakeholders
• Utilize Git and GitHub for version control and SCRUM-based collaborative development

Connaissances

Analytical thinking

Problem solving

Formation

Bachelor's degree in Computer Science or related field

Master's degree in Data Science or related field (in progress)

Outils

Python

SQL

PySpark

Databricks

Kimball dimensional modeling

Claude Code

Git/GitHub

Description du poste

Company Overview

MS Transverse is a subsidiary of MSIG USA and part of MS&AD Insurance Group Holdings, one of the 10 largest P&C insurance companies in the world.

MS Transverse Continues to Grow!

Company Overview

MS Transverse is a subsidiary of MSIG USA and part of MS&AD Insurance Group Holdings, one of the 10 largest P&C insurance companies in the world.

MS Transverse is dedicated to the global program market and partners with MGAs, program administrators, and general agents to offer a full suite of insurance services.

We believe that by aligning the interests of all parties involved in our programs – distribution partners, MS Transverse, and the reinsurance community – we can deliver outsized results to a market in need of responsible actors with experience and expertise.

Job Description

WHAT YOU'LL DO

• Support the design, development, and maintenance of Bronze, Silver, and Gold layer pipelines in Azure Databricks using PySpark and SQL
• Contribute to Kimball-style dimensional models (fact and dimension tables) that serve internal MST teams, including actuarial, underwriting, claims, and reinsurance
• Build data quality checks and validation logic that keep Lakehouse data accurate, timely, and trustworthy
• Contribute to internal automation tooling and Claude skills that speed up recurring data engineering workflows, always with a human-in-the-loop approach
• Document technical work clearly for both technical and non-technical stakeholders
• Utilize Git and GitHub for version control, code review, and collaborative development under the SCRUM framework

Required Qualifications

• Bachelor's degree (completed or in progress) in Computer Science or a related field
• Proficiency in Python, SQL, and PySpark
• Familiarity with the Databricks platform
• Familiarity with Kimball-style dimensional modeling
• Hands-on familiarity with Claude Code and the broader Claude ecosystem
• Familiarity with Git and version-controlled development workflows
• Strong analytical and problem-solving skills, with the ability to translate ambiguous business questions into technical solutions

Job Requirements/Qualifications

• Currently pursuing a Master's degree in Data Science or a closely related field
• Databricks certification: Data Engineer Associate or higher
• Research experience, preferably with publications

NICE TO HAVE

• Azure Fundamentals (AZ-900)
• Azure Data Fundamentals (DP-900)
• Experience with a BI tool
• Exposure to the insurance industry. Not required, as you'll pick up the business side through the data itself
• Familiarity with Agile methodologies, specifically SCRUM

It's an exciting time for our company and a great opportunity to join a financially sound and growing global insurance group!

It is the policy of MS Transverse to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, MS Transverse will provide reasonable accommodations for qualified individuals with disabilities.