Senior Data Engineer

AmTrust Financial Services•Dallas, TX

1d•Hybrid

About The Position

We are seeking a highly skilled Senior Data Engineer to join our team and lead the modernization of our 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. The ideal candidate will have deep expertise in Azure , data migrations , and modern data warehouse design , along with strong communication skills to collaborate effectively with technical teams and business stakeholders.

Requirements

Bachelor’s or Master’s degree in Computer Science, Engineering or equivalent work experience.
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
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

Nice To Haves

Hands-on expertise with Snowflake and related technologies in the Snowflake ecosystem (dbt/Fivetran etc.) for both batch & streaming use cases.
Experience in test automation tools & frameworks: Selenium, WebdriverIO, Appium, BrowserStack

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

Benefits

Medical & Dental Plans
Life Insurance, including eligible spouses & children
Health Care Flexible Spending
Dependent Care
401k Savings Plans
Paid Time Off
AmTrust strives to create a diverse and inclusive culture where thoughts and ideas of all employees are appreciated and respected.
This concept encompasses but is not limited to human differences with regard to race, ethnicity, gender, sexual orientation, culture, religion or disabilities.
AmTrust values excellence and recognizes that by embracing the diverse backgrounds, skills, and perspectives of its workforce, it will sustain a competitive advantage and remain an employer of choice.
Diversity is a business imperative, enabling us to attract, retain and develop the best talent available.
We see diversity as more than just policies and practices.
It is an integral part of who we are as a company, how we operate and how we see our future.