Jobs · Accounting · Nevada

Data Analytics Engineer

Swickard Auto Group · Las Vegas, NV · 2 days ago
On-siteAccounting$90k–$110k/yrFull-time

About the role

This is a hands-on technical role based in our Las Vegas Shared Services office. You will build and operate production data pipelines, reporting, and AI-powered tools that leadership across 40+ dealerships relies on daily. The position is on-site only, Monday through Friday, with some nights and weekends as needed; remote or hybrid schedules are not available.

Who We Are: Swickard Auto Group is a hospitality company in the retail automotive space built on one idea — be the favorite of our guests, our employees, and our manufacturing partners. We operate 40+ dealerships across the West Coast, Alaska, and Hawaii, and whether you're in Las Vegas or anywhere else in our network, the standard is the same: do right by people, every time.

Why Swickard Auto Group — Shared Services: Your work reaches every rooftop: the daily executive reports, KPI models, AI data assistant, and internal web apps you build are used by GMs, platform directors, and leadership across our network. High ownership and variety, from production data pipelines and analytics to AI and web applications, in one role. You'll work in person with the Shared Services team, close to the people who use what you build. Swickard is one of the fastest-growing dealer groups in the country — ranked Top 5 in North America for reputation in the automotive industry. Our HEART values — Honor every guest, Engage sincerely, Anticipate needs, Respond graciously, Thank intentionally — shape how we support our internal teams as much as our guests.

Responsibilities

  • Partner with team members to share responsibility for daily executive reporting and automated email delivery, providing coverage during absences to keep scheduled report bots delivering sales, service, appointment, trade-in, and KPI summaries to GMs, platform directors, and leadership every morning.
  • Support reporting-lane monitoring, making a best effort to keep refreshes reliable through clear failure signals, daily summaries, and prompt recovery so issues are caught before they reach leadership.
  • Identify anomalies in the data and notify the responsible data source or program owners so issues can be investigated and corrected.
  • Review output data before distribution to ensure today's report is consistent with yesterday's report, investigating and explaining any unexpected variances.
  • Build and operate production data pipelines on the config-driven EDW framework (Databricks/PySpark to Azure SQL), authoring configs, DDL, refresh logic, and validation that extend the shared framework rather than one-off scripts.
  • Own web-data ingestion via browser automation (Playwright), bringing vendor and website sources that have no API into the warehouse on a reliable daily schedule.
  • Contribute to change tracking and refresh optimization, including SCD Type 2, delta/materialized refreshes, indexing, and query tuning at multi-million-row scale, with server-side, idempotent, re-runnable loads.
  • Partner on orchestration, including job scheduling, trigger chaining, and dependency management across the daily job estate.
  • Develop the company's AI data assistant ("SwickardBot"), extending the schema-grounded knowledge base with new tables and question types and tuning classification and SQL-generation quality.
  • Build and maintain the assistant's test and validation suite, including scenario coverage, confidence thresholds, and anti-hallucination checks, and curate the example registry from high-confidence answers.
  • Contribute to the AI Pricing Project, Swickard's automated used-car pricing engine, with the goal of becoming a primary contributor over time.
  • Contribute across the internal web-application portfolio (reporting portal, AI portal, and supporting tools), converting analytics logic into self-service features and reverse-engineering existing models into build-ready specifications.
  • Develop advanced analytics beyond standard reporting, including attribution modeling, segmentation, and cohort/trend analysis, and translate leadership's business questions into analytical models and AI-assistant capabilities.
  • Manage multiple workstreams independently across data, AI, web, and reporting, delivering through Azure DevOps with clear scoping, pull requests, and durable documentation.
  • Other duties as assigned.

Requirements

  • Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent experience)
  • 3+ years of experience in analytics engineering, data engineering, or a related technical role
  • Strong production SQL, including complex joins, window functions, CTEs, set-based logic, and building materialized/summary (silver to gold) tables
  • Python for data pipelines, transformation, and scheduled-job automation in a shared, config-driven codebase
  • Azure SQL and Databricks/Spark (PySpark) at multi-million-row scale, including Databricks Jobs/Workflows orchestration
  • Pipeline patterns such as SCD Type 2, delta/materialized refresh, staging-and-promote, and idempotent re-runs
  • Browser automation or web scraping with Playwright or a similar tool
  • Working ability in Next.js, React, TypeScript, and Tailwind
  • Azure DevOps work items, branches, and pull requests
  • Power BI and semantic modeling, including DAX, Power Query/M, and dataset management
  • Ability to translate business definitions into durable, correct metric and KPI logic
  • Strong data-correctness discipline and attention to grain, filters, and edge cases
  • Knowledge of executive reporting and web/marketing analytics (GA4, lead attribution)
  • Analytical modeling skills, including attribution, segmentation, and cohort/trend analysis
  • Ability to turn open-ended leadership questions into repeatable models
  • Ability to work with high autonomy and own multiple workstreams at once
  • Commitment to clean, reviewable code and durable documentation
  • Clear communication of results and caveats to technical and non-technical audiences

Preferred Qualifications

  • LLM product experience, including natural-language-to-SQL, RAG few-shot curation, confidence thresholds, and anti-hallucination patterns
  • Python/FastAPI or Java/Spring REST APIs over Azure SQL with Azure AD/Entra (MSAL) authentication
  • Azure App Service, Static Web Apps, Container Apps, and Key Vault

Benefits

  • Medical, dental, and vision insurance
  • Life insurance and supplemental coverage options
  • Paid time off and paid holidays
  • Career growth within a high-growth dealer group
  • Employee vehicle purchase and service discounts

Pay

$90,000 - $110,000 per year

Schedule

On-site only at the Las Vegas Shared Services office, Monday through Friday, with some nights and weekends as needed. Remote or hybrid schedules are not available.

Similar jobs

Data Analytics Engineer

Dunhill Professional Search & Government SolutionsUnited States· 4 days ago
RemoteAnalyst$130k–$180k/yrapply on recruiterflow.com

Data Analytics Engineer

State of Wisconsin Investment BoardMadison, WI· 2 mo ago
$178/hrapply on swib.wd12.myworkdayjobs.com

Data Analytics Engineer

Lakeview Household Insurance SolutionsCoral Gables, FL· 2 mo ago
RemoteInformation Technology$118k–$130k/yrapply on careers.bayview.com

Data Analytics Engineer

Systems Planning & AnalysisGreater Indianapolis· 2 mo ago
Information Technologyapply on careers-spa.icims.com

Data Analytics Engineer

SkanskaCharlotte, NC· 2 mo ago
Information Technology$15.9/hrapply on careers.usa.skanska.com

Data Analytics Engineer

Heritage Vet PartnersOverland Park, KS· 2 mo ago
Information Technologyapply on nvs-vet-partners-llc.prismhr-hire.com