Apply on Employer Site

American Auto Shield · 14 hours ago

Senior Data Engineer - Data Warehousing

Lakewood,CO,US

Full-time

Onsite

Mid, Senior Level

$110K/yr - $150K/yr

American Auto Shield (AAS) specializes in 3rd party home and vehicle service contract claims administration. They are seeking a Senior Data Engineer to design and deliver modern, scalable data platforms that support analytics and strategic decision-making across the organization.

Automotive

H1B Sponsor Likely

Responsibilities

Design, build, and evolve end-to-end data pipelines using Microsoft Fabric, Azure Data Factory, and Spark

Serve as a key driver of measurable business impact, ensuring data warehousing solutions directly support enterprise capabilities and outcomes

Architect and maintain Lakehouse and Warehouse solutions leveraging Delta Lake for performance, reliability, and scalability

Implement and continuously improve Medallion architecture (Bronze / Silver / Gold) within OneLake

Develop resilient, scalable ETL/ELT frameworks supporting batch, dynamic, and incremental data ingestion

Drive performance optimization through partitioning strategies, schema and file design, caching, and query tuning

Enable analytics and reporting through semantic models and Direct Lake integration

Establish data quality, validation, observability, and monitoring to ensure trusted and governed data

Partner with product and business teams to translate requirements into robust, extensible data models

Contribute to data governance standards, documentation, and platform best practices

Provide technical leadership within a team of highly experienced engineers through design reviews, code reviews, and collaborative solution sessions

Qualification

Microsoft FabricAzure Data FactoryData EngineeringSQLSparkDelta LakeETL/ELT frameworksProblem-solvingTechnical leadership

Required

Senior-level experience in Data Engineering, Analytics Engineering, or a related discipline, with a track record of delivering enterprise-scale solutions

Deep, hands-on experience with Azure data services or comparable cloud ecosystems, including: Microsoft Fabric (Lakehouse, Warehouse, OneLake), Azure Data Factory, Azure Synapse Analytics, Power BI, Tableau, MicroStrategy, or similar

AWS or Snowflake-based data platforms

Strong experience with Spark (PySpark and/or Spark SQL)

Advanced SQL expertise (T-SQL and/or ANSI SQL)

Proven ability to design and operate large-scale, production-grade, high-performance data pipelines

Hands-on experience with Delta Lake and modern data lake architectures

Strong problem-solving skills and the ability to clearly communicate complex technical concepts to both technical and non-technical stakeholders

Benefits

Medical

Dental

Vision

Short/Long Term Disability

Life Insurance

Flex Spending Account

401 (k) **

PTO

Paid Sick/Wellbeing Time Off

Employee Assistance Program

Voluntary Benefits

Pet Insurance

Life Insurance

Company

American Auto Shield

The FIRST Choice for Service Contracts

Founded in 2002

Lakewood, Colorado, USA

501-1000 employees

https://americanautoshield.com

H1B Sponsorship

American Auto Shield 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

2022 (1)