2,328,473open jobs
146,610companies
277,684added this week
Browse all
Salary
$155k – $160k per year
Location
Hybrid (Conshohocken, Charlotte, New York, United States)
Seniority
Senior · 10+ years exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 17, 2026. First seen by Alion on Nov 16, 2026. Sompo International scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Sompo International is the global property and casualty insurance and reinsurance arm of Japan's Sompo Holdings, headquartered in Hamilton, Bermuda, writing commercial, specialty, crop and reinsurance business. Built on the former Endurance Specialty, acquired by Sompo in 2017, it has more than 9,500 employees with major underwriting hubs in New York, London, Charlotte, Alpharetta, Paris, Cologne, Munich and Madrid, and runs the AgriSompo crop insurance unit. It hires underwriters across casualty, property, marine, construction and political violence lines, claims specialists, actuaries, crop adjusters, auditors and IT staff.

Job Description

Are you looking for your next opportunity?

Sompo has a unique opportunity for a Senior Data Engineer (SSIS & Azure Synapse) in ourIT team.

We are seeking an experienced Senior Data Engineer to design, develop, and support enterprise-scale data integration and analytics solutions. The ideal candidate will have strong expertise in Microsoft SQL Server, SSIS, Azure Synapse Analytics, Azure Data Factory, and modern cloud-based data engineering practices. This role will be responsible for building reliable data pipelines, optimizing ETL/ELT processes, supporting data warehouse initiatives, and enabling business intelligence and analytics across the organization. The candidate will work closely with DBAs, application teams, business analysts, reporting teams, and other stakeholders to deliver scalable, reliable, and governed data solutions.

Location: This position will be based out of our Conshohocken, PA, Purchase, NY, Charlotte, NC or Morristown, NJ office. We strive for collaboration which is why we offer a work environment where our employees thrive and develop long lasting careers.

Our business, your impact, our opportunity:

What you’ll be doing:

  • Design, develop, maintain, and optimize enterprise ETL/ELT pipelines using SQL Server Integration Services, Azure Data Factory, and Synapse Pipelines for batch and near real-time data ingestion from internal and external systems.
  • Migrate legacy SSIS workloads to cloud-native Azure solutions where appropriate, ensuring scalable, reliable, and supportable data integration patterns.
  • Develop and support data solutions within Azure Synapse Analytics, including dedicated SQL pools, serverless SQL workloads, orchestration processes, workload optimization, and integration with Azure Data Lake Storage Gen2.
  • Design, implement, and maintain dimensional and relational data warehouse models, including fact tables, dimension tables, Star/Snowflake schemas, data marts, stored procedures, views, functions, and SQL scripts.
  • Build data solutions that support enterprise reporting, business intelligence, analytics, and downstream data consumption needs across the organization.
  • Implement data quality validations, reconciliation processes, exception handling, logging, monitoring, and alerting frameworks to improve pipeline reliability and operational transparency.
  • Optimize SQL queries, indexing, data models, partitioning strategies, pipeline performance, and data warehouse workloads to meet scalability and performance requirements.· Troubleshoot production data pipeline failures, SQL performance issues, data quality issues, and data pipeline bottlenecks; perform root cause analysis and implement corrective and preventive solutions.
  • Collaborate with DBAs, application teams, business analysts, reporting teams, and other stakeholders to resolve data-related issues and deliver scalable, reliable, and governed data solutions.
  • Support enterprise data governance, metadata management, documentation, data lineage, operational procedures, knowledge sharing, and process discipline across data engineering initiatives.
  • Manage source control using Azure DevOps or Git, participate in CI/CD deployment processes, support release and environment migration activities, and automate recurring operational, deployment, and validation tasks.

What you’ll bring:

  • 10+ years of experience in data engineering, ETL/ELT development, and enterprise data warehousing, with strong hands-on expertise in Microsoft SQL Server, advanced T-SQL, SSIS, Azure Data Factory, Synapse Pipelines, performance tuning, query optimization, indexing, and production troubleshooting.
  • Proven experience designing, developing, optimizing, and supporting scalable Azure-based data platforms, including Azure Synapse Analytics, dedicated and serverless SQL workloads, Azure Data Lake Storage Gen2, cloud data ingestion, pipeline orchestration, and migration of legacy data workloads to cloud-native Azure solutions.
  • Strong background in dimensional and relational data modeling, including Star Schema, Snowflake Schema, fact and dimension tables, data marts, stored procedures, views, functions, SQL scripts, and data warehouse solutions supporting enterprise reporting, BI, and analytics.
  • Demonstrated ability to build and support reliable production data pipelines with data quality checks, validation, reconciliation, exception handling, logging, monitoring, alerting, root cause analysis, and operational support best practices.
  • Experience with Azure DevOps or Git, including source control, branching, code management, release management, CI/CD deployment processes, environment migrations, documentation, metadata management, data governance, and data lineage practices.
  • Strong analytical, problem-solving, communication, stakeholder management, and collaboration skills, with the ability to work independently, manage competing priorities, translate business requirements into scalable technical solutions, and partner effectively with technical teams, business stakeholders, and leadership.
  • Experience working in the insurance industry, preferably Property & Casualty, commercial lines; preferred experience with Python, PySpark, Azure Databricks, Delta Lake, Power BI semantic models, Microsoft Fabric, Synapse Spark Pools, REST API integrations, event-driven architectures, Master Data Management, and Microsoft Azure Data Engineer certification such as DP-203.

Salary Range: $155,000 - $160,000. Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience.

At Sompo, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.

Our compensation program is built on a foundation that promotes a pay-for-performance culture, resulting in higher incentive awards, on average, when the Company does well and lower incentive awards when the Company underperforms. The total compensation opportunity for all regular, full-time employees is a combination of base salary and incentives that gets adjusted upfront based on overall Company performance with final awards based on individual performance.

We continuously evaluate and update our benefit programs to ensure that our plans remain competitive and meet the needs of our employees and their dependents. Below is a summary of our current comprehensive U.S. benefit programs:

  • Two medical plans to choose from, including a Traditional PPO & a Consumer Driven Health Plan with a Health Savings account providing a competitive employer contribution
  • Pharmacy benefits with mail order options
  • Dental benefits including orthodontia benefits for adults and children
  • Vision benefits
  • Health Care & Dependent Care Flexible Spending Accounts
  • Company-paid Life & AD&D benefits, including the option to purchase Supplemental life coverage for employee, spouse & children
  • Company-paid Disability benefits with very competitive salary continuation payments
  • 401(k) Retirement Savings Plan with competitive employer contributions
  • Competitive paid-time-off programs, including company-paid holidays
  • Competitive Parental Leave Benefits & Adoption Assistance program
  • Employee Assistance Program
  • Tax-Free Commuter Benefit
  • Tuition Reimbursement & Professional Qualification benefits

Who we are and what we stand for:

At Sompo, our shared purpose is to create meaningful value for clients, communities, and each other. We strive to foster a workplace where everyone feels respected, included, and empowered to excel. As a global organization, we embrace diversity and champion equal opportunity. Guided by our core values-Accountability, Agility, Collaboration, Development, and Integrity-we build trust and support one another to achieve our goals worldwide. Life at Sompo page

Our values come to life in how we hire and grow talent. Employment decisions are based on qualifications, merit, and organizational need, and we strive to ensure equitable access to opportunities so everyone can do their best work. If you need an accommodation for any part of the application process, please contact the recruiter in charge.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,328,473 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Remote, many countries
Similar stack
Same company
Conshohocken
Senior Data Engineer 2 hours ago
In office · Full-Time · Winter Park
Python
SQL
Databases
MS SQL
Apache Kafka
Amazon Redshift
Azure SQL Database
Microsoft Fabric
AI/ML
dbt
DevOps
Terraform
Azure DevOps
GitHub Actions
Azure
CI/CD
Git
AWS
Docker
Bicep
Amazon EC2
GitHub
Amazon S3
Amazon Kinesis
Analytics
Power BI
ETL/ELT
Azure Data Factory
Dimensional Modeling
Management
Scrum
Apply
Data Engineer IV 1 day ago
$132k – $224k per year · Remote (United States) · Full-Time · 8+ years exp · High School Diploma · Portland
Python
PowerShell
Databases
Databricks
DevOps
Terraform
Ansible
Datadog
Azure
CI/CD
Docker
Kubernetes
Incident Management
Analytics
Fivetran
Management
Agile
Apply
Sr. AI Data Engineer 1 month ago
In office · Contractor · United States
Python
SQL
Python
pySpark
Databases
Snowflake
Weaviate
Databricks
Chroma
Pinecone
FAISS
Apache Kafka
Google BigQuery
Amazon Redshift
AI/ML
LangChain
Spark
Airflow
LlamaIndex
Embeddings
RAG
Feature Store
Machine Learning
DevOps
GCP
Azure
CI/CD
Git
AWS
Docker
Analytics
ETL/ELT
Azure Data Factory
AWS Glue
Apply
In office · Contractor · Rockville
Python
SQL
AI/ML
Unstructured.io
Streamlit
DevOps
Rest API
Splunk
Jenkins
Grafana
Bitbucket
GitLab
Analytics
Power BI
Plotly
ETL/ELT
Management
Jira
Apply
Remote (United States, Canada) · United States
Python
SQL
AI/ML
Spark
Machine Learning
Analytics
Tableau
Metabase
Apply
$200k – $260k per year · Hybrid · Full-Time · 8+ years exp · Seattle
Databases
Databricks
ClickHouse
Apache Kafka
Google BigQuery
AI/ML
dbt
AI Agents
DevOps
GCP
Kubernetes
Analytics
ETL/ELT
Apply
Data Engineer 1 day ago
Remote (LATAM, United States) · 5+ years exp · Bachelor's Degree
Python
SQL
Python
pySpark
Databases
Databricks
AI/ML
Spark
Dagster
dbt
Prompt Engineering
Knowledge Graph
Machine Learning
DevOps
CI/CD
Analytics
ETL/ELT
Apply
Remote (LATAM, United States) · Full-Time · 5+ years exp
Python
SQL
Scala
Databases
Apache Iceberg
Delta Lake
Presto
Apache Hudi
Trino
AI/ML
Spark
Airflow
DevOps
Azure
CI/CD
Git
Amazon S3
Cybersecurity
Open Policy Agent
HIPAA
Analytics
Power BI
ETL/ELT
Apache NiFi
Looker
Superset
Apply
Remote (LATAM) · Full-Time · 4+ years exp
Python
SQL
Databases
Snowflake
Databricks
Amazon Redshift
AI/ML
Spark
Airflow
DevOps
Terraform
Git
AWS
Amazon S3
Amazon Kinesis
Analytics
AWS Glue
Dimensional Modeling
Apply
In office · Full-Time · 5+ years exp · Bachelor's Degree · Conshohocken · Philadelphia
Java
Java
Spring Boot
Databases
Apache Kafka
DevOps
Rest API
GCP
Azure
CI/CD
AWS
Kubernetes
Service Mesh
Management
Agile
Apply
Remote (United States) · Full-Time · 8+ years exp · Bachelor's Degree · Conshohocken
Apply
$180k – $220k per year · In office · Full-Time · 8+ years exp · Bachelor's Degree · Conshohocken · Waltham
SQL
Databases
Snowflake
Databricks
AI/ML
Tokenization
Cybersecurity
HIPAA
Analytics
Tableau
Power BI
ETL/ELT
Life Sciences
Veeva
Apply
≈ $41k – $69k per year (Estimated) · In office · High School Diploma · Conshohocken
Apply
≈ $93k – $176k per year (Estimated) · In office · Full-Time · 4+ years exp · Bachelor's Degree · Conshohocken
Python
JavaScript
PowerShell
AI/ML
Machine Learning
DevOps
Rest API
Terraform
GCP
Azure
AWS
Platform Engineering
IAM
Cybersecurity
Okta
CyberArk
Zero Trust
Microsoft Entra ID
Ping Identity
BeyondTrust
LDAP
Management
Agile
Apply
See all jobs
This is one of many
2,328,473 more open roles from verified company boards, updated every day.