Apply on Employer Site

AmTrust Financial Services, Inc. · 20 hours ago

Senior Microsoft Data Warehouse Developer

Greater Cleveland

Full-time

Hybrid

Senior Level, Lead/Staff

$88K/yr - $145K/yr

8+ years exp

AmTrust Financial Services, Inc. is seeking a highly skilled Senior Microsoft Data Warehouse Developer to lead the modernization of their data ecosystem. This role will focus on migrating on-premise systems to the cloud, consolidating data warehouses, and designing scalable architecture to support advanced analytics and reporting.

FinanceProperty & Casualty InsuranceFinancial ServicesInsurance

H1B Sponsor Likely

Hiring Manager

Isabella Thompson

Responsibilities

Migrate current on-premise systems to the cloud

Consolidate data warehouse and processes

Design new architecture models for specialty risk

Improve pipeline logic and automation

Implement reporting solutions

SQL Server migration to cloud

Use Databricks to consolidate pipelines

Participate in infrastructure and pipeline testing

Qualification

AzureData migrationsData warehouse designSSISSQL ServerDatabricksData Modeling toolsCI/CD practicesProgramming languagesCommunication skills

Required

Bachelor's or Master's degree in Computer Science, Engineering or equivalent work experience

SSIS Experience is a MUST

8+ years of hands-on experience in data engineering with on-premise and cloud data platforms

Highly effective in communicating complex information to non-technical stakeholders

Develop and improve existing data models to accurately represent end-to-end business processes, ensuring they're scalable and fully integrate with the extensive data architecture

Proven experience designing and building large-scale data platforms

Implement best practices in data modeling, DevOps, ETL/ELT processes

Drive automation and CI/CD practice in data engineering workflows

Experience in Data Modeling tools such as Idera, ERWin

Preferred

Expert level (hands-on) knowledge and understanding of recent versions of Microsoft SQL Server 2016, SSIS, Stored Procedures

Strong expertise with Azure Data Factory, Databricks, PySpark, Synapse Analytics

Data Modelling - dimensional/reporting, data warehousing and transactional use cases (Physical and Logical modelling)

Proficiency in programming languages such as C#, Python, Java, or equivalent

Benefits

Medical & Dental Plans

Life Insurance, including eligible spouses & children

Health Care Flexible Spending

Dependent Care

401k Savings Plans

Paid Time Off

Company

AmTrust Financial Services, Inc.

Glassdoor3.4

AmTrust Financial Services, Inc., through its subsidiaries, operates as a multinational property and casualty insurance company.

Founded in 1998

New York, New York, USA

5001-10000 employees

https://amtrustfinancial.com/

H1B Sponsorship

AmTrust Financial Services, Inc. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (3)

2023 (3)

2022 (5)

Funding

Current Stage

Public Company

Total Funding

unknown

2006-11-13IPO

Leadership Team

Daniel Pacicco

Executive Vice President, Chief Financial Officer

Carl Canales

Executive Vice President - North American Field Operations

Recent News

PR Newswire

Millennial Shift Technologies Announces Partnership with AmTrust to Bring Small Commercial Products to the mShift Marketplace; Cyber Insurance Available First

2025-12-04

Business Wire

AmTrust Announces Quarterly Cash Dividends on Preferred Stock

2025-11-07

PR Newswire

Kestrel Group Reports Third Quarter 2025 Financial Results

2025-11-05

Company data provided by crunchbase