Automotive Data Engineer

OURISMAN AUTOMOTIVE GROUP; Bethesda (MD); Ibrido; USD 100.000 - 130.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401(k) with company match

Paid time off

Holiday leave

Professional development

Descrizione del lavoro

Ourisman Automotive Group is seeking a Data Engineer to join a small, talented development and product team, reporting directly to the Chief Technology Officer. You will recommend and help implement core architectural decisions for data ingestion, quality, auditability, and governance.

As we expand our data lake, your work will make clean, timely, and trustworthy data available to thousands of internal users through exports, reporting dashboards, and MCP.

Competenze

• 2–4 years in data engineering.
• Strong background in data and software architecture.
• Write, review, test, and maintain production code with AI coding agents.
• Detail-oriented and numerically strong.

Mansioni

• Data Management & Wrangling: Build, monitor, and maintain data ingestion pipelines; ensure data quality and governance.
• Data Analysis & Modeling: Develop, test, document, and maintain data transformation models using dbt; define data sets for reporting.
• Ad hoc analysis to support business needs and build dashboards.
• Load data into Snowflake and DOMO; expose data via MCP; establish governance of new data sets.

Conoscenze

SQL

Python

Data engineering

Data architecture

Dimensional modeling

Cloud data warehousing

ELT orchestration

Version control

Descrizione del lavoro

Ourisman, Trusted Tradition

Here’s to those who think differently. The ones who think that a car dealership's first priority should be the guest. Such a candid idea could only come from Ourisman. Because we're forward thinking, just like the communities we serve. Individuals who won't be constrained by how things "have always been done", but instead strive to do things "how they could be done" and "how they should be done." It is a philosophy we have infused into every fabric of our dealerships, from the bottom up, in every department, and in every Ourisman team member. Changing the way we all think about car buying is just the beginning.

Role Summary

Ourisman Automotive Group is seeking a Data Engineer to join a small, talented development and product team, reporting directly to the Chief Technology Officer. You will recommend and help implement core architectural decisions for data ingestion, quality, auditability, and governance. As we expand our data lake, your work will make clean, timely, and trustworthy data available to thousands of internal users through exports, reporting dashboards, and MCP.

Essential Duties

• Data Management & Wrangling

• Build, monitor, and maintain reliable data ingestion pipelines using Fivetran or Dagster.
• Implement data quality checks and monitoring to identify issues with accuracy, completeness, consistency, and timeliness.
• Join data sets from multiple sources to produce more insightful data products
• Load data into Snowflake and DOMO
• Expose data via MCP
• Establish and enforce governance of new data sets
• Maintain data dictionaries for all data

• Data Analysis & Modeling

• Develop, test, document, and maintain data transformation models using dbt.
• Define data sets for reporting and operational and financial systems
• Perform ad hoc analysis to support business needs
• Build and maintain dashboards

Qualifications, Background and/or Experience

• 2-4 years in data engineering
• Strong background in data and software architecture
• Ability to write, review, test, and maintain high-quality production code, including effective use of AI coding agents.
• Detail-oriented, strong with numbers

• Advanced SQL skills and proficiency in Python or a comparable programming language.
• Experience with dimensional data modeling, cloud data warehouses, ELT orchestration, automated testing, and version control.
• Experience designing observable, reliable data pipelines and troubleshooting production data issues.

Work Environment

• This is a hybrid role that requires regular, active engagement with stores across the platform, including rotational in-person visits and meetings. Frequent travel between stores in the DMV region is required.

Salary

• $100,000 - $130,000
• Salary is determined by skills, qualifications, depth of experience and location.

Benefits

• Health, dental, and vision insurance
• Life insurance options
• Short-term and Long-term disability insurance
• 401(k) plan with company match
• Paid time off and holiday leave
• Opportunities for professional development and growth

Ourisman Automotive Group is an equal opportunity employer. We believe in hiring a diverse workforce and sustaining an inclusive, people-first culture. We are committed to non-discrimination on any protected basis, such as disability and veteran status, or any other basis covered under applicable law. Should you require accommodation during the interview process, please advise the hiring manager when contacted for an interview.

Willing to submit to a pre-employment background check