Data Engineer

Hendrick Autoguard - HIC

Location:

6030 East Independence Blvd, Charlotte, North Carolina 28212 Position Summary The Data Engineer is a mid-level individual contributor responsible for the systems and structures that make Hendrick Autoguard's data reliable, accessible, and useful. This role owns the design and operation of the ingestion pipelines, transformation logic, and data models that serve both business intelligence and AI initiatives. This is not a role that waits for requirements to arrive fully formed.

The Data Engineer is expected to develop a working understanding of how the business operates and to apply that knowledge when making technical decisions. A pipeline that runs on time but models the business incorrectly has not done its job. That distinction sits at the center of this role. The role works alongside the analysts and BI developers who build reporting on the data platform, the data science and AI teams who use curated data for model development, and the team that administers the underlying cloud infrastructure.

The Data Engineer makes sure the data layer serves each of these groups well, so that none of them has to rebuild it for their own use. What This Role Does The Data Engineer owns the movement of data from source systems into the Snowflake data platform. In practice that means designing, building, and maintaining ingestion pipelines; orchestrating workflows in Dagster so they are observable, reliable, and operationally sound;

and monitoring pipeline health and data availability. When a load fails or data arrives late, the Data Engineer investigates, fixes the underlying cause, and puts alerting in place so the same problem surfaces early next time rather than in a stakeholder's report. Once data lands, the Data Engineer develops and maintains the dbt transformation models that turn raw source data into clean, tested, and well-documented datasets.

That includes designing dimensional models and data marts that support both reporting and machine learning use cases, and implementing data quality checks and testing standards throughout the transformation layer. Downstream consumers should be able to trust a dataset without re-verifying it themselves. The Data Engineer also prepares data for AI. That work includes structuring feature datasets and training data pipelines, and collaborating with data science and AI teams to make sure the data meets their requirements for quality, freshness, and structure.

The Data Engineer contributes to the semantic layer that gives AI and analytics consumers consistent, well-defined access to business metrics and entities, and keeps data lineage and governance in view, since AI applications raise the stakes on knowing where data came from and how it may be used. The Data Engineer is also expected to advise on the strategic direction of the data engineering toolset, weighing in on platform and feature updates and evaluating new capabilities as they become available.

Staying current with best practices and industry advancements in data engineering, AI data preparation, and orchestration is part of the job, not a side interest, and that knowledge should inform how the team's tools and standards evolve over time. Across all of this work, the Data Engineer builds working knowledge of the Autoguard business processes it supports, including vehicle service contract and protection product sales through dealership partners, claims administration, and cancellations, along with the workflows and decisions that depend on data from those areas.

The Data Engineer engages directly with business stakeholders to understand their data needs, translates those needs into sound technical designs, and applies business context when weighing modeling…