Senior Data Engineer: SSIS + Azure Synapse Expert

Sompo

Morristown (NJ)

On-site

USD 155,000 - 160,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Sompo is seeking a Senior Data Engineer to design, develop, and support enterprise-scale data integration and analytics solutions. The role emphasizes Microsoft SQL Server, SSIS, Azure Synapse Analytics, and Azure Data Factory to build reliable data pipelines and govern data across the organization.

Based in Morristown, NJ (with other U.S. office locations such as Conshohocken, PA, Purchase, NY, Charlotte, NC), you will collaborate with DBAs, analysts, and reporting teams, ensuring scalable data

Qualifications

  • Extensive experience with Microsoft SQL Server, SSIS, and Azure data platforms.
  • Proven ability to design, develop, and optimize enterprise data pipelines and data warehouses.
  • Strong understanding of data governance, quality checks, and production support.

Responsibilities

  • Design, develop, maintain, and optimize enterprise ETL/ELT pipelines using SSIS, Azure Data Factory, and Synapse Pipelines.
  • Migrate legacy SSIS workloads to cloud-native Azure solutions where appropriate.
  • Develop and support data solutions within Azure Synapse Analytics, including dedicated SQL pools and serverless workloads.
  • Design and maintain dimensional and relational data warehouse models and data marts.
  • Build data solutions that support enterprise reporting, BI, and analytics across the organization.
  • Implement data quality validations, logging, monitoring, and alerting frameworks.

Skills

SQL Server
SSIS
Azure Synapse
Azure Data Factory
ETL/ELT

Tools

SQL Server
SSIS
Azure Synapse Analytics
Azure Data Factory

Job description

Sompo is seeking a Senior Data Engineer to design, develop, and support enterprise-scale data integration and analytics solutions. The role emphasizes Microsoft SQL Server, SSIS, Azure Synapse Analytics, and Azure Data Factory to build reliable data pipelines and govern data across the organization.

Based in Morristown, NJ (with other U.S. office locations such as Conshohocken, PA, Purchase, NY, Charlotte, NC), you will collaborate with DBAs, analysts, and reporting teams, ensuring scalable data

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Hybrid Senior Data Engineer: Azure Synapse & SSIS
Hybrid Senior Data Engineer: Azure Synapse & SSIS

Sompo Holdings, Inc. • Conshohocken, Purchase (NY), Charlotte (NC), Morristown (NJ)

Hybrid
USD 155,000 - 160,000
Health benefits
401(k) plan
Paid time off
Senior Data Engineer - Azure Synapse & ETL Expert
Senior Data Engineer - Azure Synapse & ETL Expert

Sompo • Conshohocken

On-site
USD 155,000 - 160,000
Medical plans
Dental & Vision
401(k)
+3
Senior Data Engineer: Azure Data Platform & DW Pipelines
Senior Data Engineer: Azure Data Platform & DW Pipelines

Sompo • Purchase (NY)

On-site
USD 155,000 - 160,000
Medical plans
Dental & Vision benefits
401(k) Retirement Savings Plan
+1
Remote Senior Data Engineer- Azure Synapse & Data Warehouse
Remote Senior Data Engineer- Azure Synapse & Data Warehouse

Symfa Inc. • United States

Remote
USD 140,000 - 210,000
Senior Data Engineer - Azure Synapse & AI Pipelines
Senior Data Engineer - Azure Synapse & AI Pipelines

Suzega • United States

Remote
USD 120,000 - 170,000
Senior Data Engineer
Senior Data Engineer

InfoStride • Raleigh (NC)

Hybrid
USD 120,000 - 180,000
Senior Data Engineer — Azure Synapse, Data Mesh & Self-Service Analytics (Remote)
Senior Data Engineer — Azure Synapse, Data Mesh & Self-Service Analytics (Remote)

Node.Digital LLC • Washington

Remote
USD 140,000 - 190,000
Medical
Dental
Vision
+6
Senior Data Engineer: Azure Synapse Pipelines (Remote, EST)
Senior Data Engineer: Azure Synapse Pipelines (Remote, EST)

Health-eCommerce.com • Oregon

Hybrid
USD 130,000 - 165,000
Medical, Dental, Vision, and 401K with
Dependent Care, FSA & HSA accounts
Paid Parental & Bonding Leave
+4
Senior Data Engineer: Data Integration & Cloud Solutions
Senior Data Engineer: Data Integration & Cloud Solutions

Connection • Merrimack (NH)

Hybrid
USD 120,000 - 170,000
Free therapy visits
Mental health resources
Wellness time off
+1
Senior Data Engineer - US
Senior Data Engineer - US

Suzega • United States

Remote
USD 120,000 - 170,000