Data Engineer

hendrick; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

Hendrick Autoguard - HIC, located in Charlotte, NC, seeks a mid-level Data Engineer to design and operate the data platform that powers BI and AI initiatives.

You will own ingestion pipelines, ensure reliable data movement into Snowflake, build dbt models, and orchestrate workflows with Dagster, collaborating closely with analysts and data science teams.

The role emphasizes understanding business processes and delivering clean, well-documented datasets with governance and data quality checks.

Qualifications

• 3–7 years of professional data engineering experience.
• Proficient in SQL and data modeling.
• Experience with Snowflake, dbt and Dagster.
• Familiar with AWS concepts.

Responsibilities

• Own data movement from source systems into Snowflake.
• Design, build, and maintain ingestion pipelines.
• Orchestrate workflows in Dagster for reliability.
• Develop dbt transformation models and data marts.
• Ensure data quality checks and governance for AI readiness.
• Collaborate with analysts, data science, and BI teams.

Skills

SQL

Data modeling

Data transformation

Workflow orchestration

Tools

Snowflake

dbt

Dagster

AWS

Job description

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 decisions, pipeline priorities, and data quality standards. That knowledge makes each new request faster to scope. It also makes the Data Engineer a useful partner when a team is still working out which question it needs to answer.

Adjacent Competencies

Dashboard and report preparation are not a routine part of this role, and primary ownership of that work belongs to analysts and BI developers. The Data Engineer may occasionally need to support that function, though, whether by building or troubleshooting a report in a pinch or by helping an analyst work through a modeling issue at the source. The Data Engineer's core job is to deliver the modeled, tested data those teams build on, and to work with them when a reporting need exposes a gap in the data layer.

Experience And Qualifications

A candidate for this role has 3-7 years of professional experience in data engineering or a closely related discipline. They are proficient in SQL and have hands-on experience with a cloud data warehouse, a data transformation and modeling framework, and a workflow orchestration tool. Experience with Snowflake, dbt, and Dagster is strongly preferred, as is familiarity with AWS, including storage, IAM, and basic networking concepts.Preferred expe