Senior Data Engineer - Data Warehousing at American Auto Shield

Lakewood, Colorado, United States -

Full Time

Start Date

Immediate

Expiry Date

20 Apr, 26

Salary

150000.0

Posted On

20 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Engineering, Analytics Engineering, Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Power BI, Tableau, MicroStrategy, AWS, Snowflake, Spark, PySpark, SQL, Delta Lake, Data Governance, ETL

Industry

Motor Vehicle Manufacturing

Description

Description Founded in 2002, American Auto Shield (AAS) specializes in 3rd party home and vehicle service contract claims administration. AAS has a headquarters in Lakewood, Colorado, and we operate a satellite office in St. Peters, Missouri. For more than two decades, American Auto Shield has experienced tremendous growth, which equates to fantastic career opportunities for our employees. The American Auto Shield Senior Data Engineer is a full-time, on-site position at our Lakewood, CO office. We are seeking a Senior Data Engineer to play a critical role in our enterprise adoption of Microsoft Fabric. This is a high-impact, highly visible position focused on designing and delivering modern, scalable data platforms that power analytics, reporting, and strategic decision-making across the organization. The work performed in this role directly supports key business drivers and is expected to deliver material impact within the next two to three years. You will operate at the intersection of Lakehouse, Warehouse, OneLake, and multiple Analytics Platforms, partnering closely with architects, product managers, and business stakeholders to transform complex data into trusted, actionable insights. This role offers significant ownership, architectural influence, and the opportunity to establish best practices as we modernize and scale our data ecosystem. Job Location Lakewood, CO Salary The Senior Data Engineer earns competitive compensation from $110,000-150,000.* What You’ll Do 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 Requirements What You Need to Join Our Team Required Experience, Skills & Abilities: 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 Why This Role: Opportunity to shape and influence a strategic, enterprise-wide Microsoft Fabric implementation Work on modern data architecture with meaningful scale and long-term impact High degree of technical ownership and autonomy Collaborative engineering culture with strong executive sponsorship Clear pathway for technical growth, influence, and leadership Why work for us? We are excited to provide Competitive compensation from $110,000-150,000* 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 Satisfaction of work with a highly skilled team to make a company-wide impact

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Senior Data Engineer will design, build, and evolve end-to-end data pipelines using Microsoft Fabric and Azure Data Factory. This role will also ensure data warehousing solutions support enterprise capabilities and outcomes.