2,322,220open jobs
146,483companies
272,820added this week
Browse all
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

  • We are Sompo, a global provider of commercial and consumer property, casualty, and specialty insurance and reinsurance. It was founded in 2001, and is headquartered in Hamilton, Hamilton, BMU, with a workforce of 5001-10000 employees. Its website is https://www.sompo-intl.com/.

  • Company H1B Sponsorship

  • Sompo has a track record of offering H1B sponsorships, with 3 in 2026, 12 in 2025, 13 in 2024, 19 in 2023, 28 in 2022, 5 in 2021, 12 in 2020. Please note that this does not guarantee sponsorship for this specific role.

  • 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.
    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
    In office · Secret · 5+ years exp · Arlington
    SQL
    Databases
    PostgreSQL
    Oracle
    MS SQL
    MariaDB
    DevOps
    AWS
    Linux
    Apply
    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
    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
    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
    In office · 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,322,220 more open roles from verified company boards, updated every day.