Salary
$155k – $160k per year
Location
Hybrid (Conshohocken, United States)
Seniority
Senior
Employment
Full-Time
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.
Sompo is seeking a Senior Data Engineer to design, develop, and support enterprise-scale data integration and analytics solutions. The role focuses on building and optimizing data pipelines, supporting Azure data warehouse initiatives, and enabling business intelligence and analytics across the organization.
Responsibilities
- 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
Skills
- 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
Benefits
- 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
- Incentive awards for regular, full-time employees, adjusted based on overall Company performance, with final awards based on individual performance
- Hybrid work environment
Company Overview
Company H1B Sponsorship
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,322,220 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.
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 Oracle Database Administrator
6 days ago
In office · Secret · 5+ years exp · Arlington
SQL
Databases
PostgreSQL
Oracle
MS SQL
MariaDB
DevOps
AWS
Linux
Apply
Oliver Wyman - Data & Analytics Recruiter
4 days ago
Hybrid · Full-Time · 3+ years exp · Raleigh · Atlanta
AI/ML
Machine Learning
Apply
Data Scientist
4 hours ago
In office · 5+ years exp · Tysons
Python
SQL
Databases
Databricks
AI/ML
Fine-tuning
Embeddings
Scikit-learn
Prompt Engineering
NLP
PyTorch
LLM
RAG
Hugging Face
Semantic Search
Knowledge Graph
LLM Guardrails
Machine Learning
DevOps
GCP
Azure
CI/CD
Git
AWS
Analytics
A/B Testing
Management
Agile
Scrum
Apply
$147k – $196k per year · Equity · In office · Top Secret · 3+ years exp · Costa Mesa
Python
SQL
Python
pySpark
AI/ML
Polars
Spark
Computer Vision
AI Agents
Pandas
Streamlit
DevOps
Rest API
Terraform
Platform Engineering
Robotics
Sensor Fusion
Apply
Data Integration Engineer
2 hours ago
In office · 3+ years exp · Bachelor's Degree · Brookfield
SQL
Apex
Apex
MuleSoft
Databases
Snowflake
AI/ML
Copilot
Model Context Protocol
AI Agents
Copilot Studio
DevOps
Rest API
Git
Analytics
Power BI
ETL/ELT
Informatica
SSIS
Matillion
Fivetran
Azure Data Factory
Dimensional Modeling
Apply
$200k – $260k per year · Remote (EMEA, APAC, United States) · 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
Data Engineer – Lakehouse / Spark / NiFi
1 hour ago
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
Mid Data Engineer – Python Spark
1 hour ago
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
Senior Engineer, Full-Stack Engineering
4 hours ago
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
In office · Full-Time · 8+ years exp · Bachelor's Degree · Conshohocken
Apply
Associate Director, Data Enablement
5 hours ago
$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
Store Manager Trainee - Colliflower Inc
5 hours ago
≈ $41k – $69k per year (Estimated) · In office · High School Diploma · Conshohocken
Apply
Senior Engineer, IAM Platform Engineering
7 hours ago
≈ $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
This is one of many
2,322,220 more open roles from verified company boards, updated every day.

