American Auto Shield · 13 hours ago
Senior Data Engineer - Data Warehousing
Lakewood, CO
Full-time
Onsite
Mid, Senior Level
$110K/yr - $150K/yrAmerican Auto Shield is a leading provider of 3rd party home and vehicle service contract claims administration. They are seeking a Senior Data Engineer to design and deliver scalable data platforms that support analytics and strategic decision-making across the organization.
Automotive
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
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
Comprehensive benefits package
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
501-1000 employees
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)
Funding
Current Stage
Late StageLeadership Team
Jeff Junak
Chief Information Officer
Recent News
Company data provided by crunchbase