Azure Data Engineer

AmTrust Financial
US - Connecticut - Southington
July 1, 2024

Azure Data Engineer

Job Locations

US-United States

Requisition ID

2024-16929

Category

Information Technology

Position Type

Regular Full-Time

Overview

As an AmTrust Data Engineer you will participate in the design, analysis, and development of Data Warehouse, Business Intelligence, and Data Science (AI/ML) initiatives. This includes modeling, building, and populating Modern MPP Warehouse & Lakehouse architectures to resolve complex business problems.

Responsibilities

Partner with the business, document requirements, and advise solutions from a data and architecture perspective. Define and lead the data lifecycle strategy across data acquisition, data ingestion, data cleansing, normalization, and linkage.
Assess business rules; perform source to target data mapping; design, review, implement and optimize ETL processes.
Provide data analysis and identify data-related issues within the Data Warehouse environment, as well as source systems as needed.
Create, optimize, and maintain the logical and physical dimensional data models.
Work in a fast-paced agile development environment
Participate in peer code reviews

Qualifications

Hands-on experience designing and implementing large-scale data warehouse solutions and complex data models
3 years of experience in designing, developing, and tuning modern Azure data warehouses including in-depth knowledge of slowly changing dimensions and advanced performance tuning techniques
3 years of hands-on experience designing and implementing large-scale data pipelines including Change Data
Capture (CDC) solutions for structured, semi-structured, and unstructured data in batch and real-time environments
Strong knowledge of cloud native data platform architectures, data engineering and data management
Experience with Data Lake technologies including ADLS Gen. 2
2 years of experience with Azure Data Factory and PowerBI.
5 years of hands-on experience with TSQL, Python, and Pyspark (Spark SQL)
Broad experience in Microsoft SQL technologies, SSIS, SSRS, etc.
Experience using Azure DevOps and CI/CD
Ability to work in a fast-paced, collaborative team environment.
Excellent written and verbal communication skills and ability to express ideas clearly and concisely.
Education and Experience
Proven enterprise experience implementing and supporting large-scale data warehouse and data pipelines
Bachelor's degree in information technology, computer science, or related field; proven industry experience will be acceptable in lieu of degree
Industry certifications are a plus in addition to work experience e.g., Certified Azure Data Engineer.
8+ years of relevant experience with data pipelines, data warehouses, and business intelligence
Experience working with methodologies and techniques such as Agile, Scrum, and Kanban.

What We Offer

AmTrust Financial Services offers a competitive compensation package and excellent career advancement opportunities. Our benefits include: 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.

Connect With Us!

Not ready to apply? Connect with us for general consideration.
•

Read the full job description and apply online on the recuiter's web-site

Related Job Postings

CDL A Drivers - Top 50% of OTR drivers avg 90,518 per year

Crete Carrier Corporation

United States - CT - CT - Suffield
July 8, 2024

TRUCK DRIVING JOBS: WE ARE HIRING DRIVERS! We're a Certified Top Pay Carrier and • the top 50 percent of our drivers • average$90,518 per year. STRONGER TOGETHER • It s part of the American fabric. Good people getting a job done. Customers facing deadlines. Drivers delivering safely and on time. And...

Find Jobs Hiring Now Near You!

Get Jobilize Job Search Mobile App Now