Data Analytics Engineer

SWICKARD SHARED SERVICES LLC•Las Vegas, NV
•$90,000 - $110,000•Onsite

About The Position

Swickard Auto Group is hiring an on-site Data Analytics Engineer for its Las Vegas Shared Services office. This hands-on role builds and operates production data pipelines, executive reporting, analytics, AI capabilities, and internal web applications used across the company’s dealership network. The role partners with colleagues to maintain daily reporting and reliable data refreshes, and independently manages multiple workstreams across data, AI, web, and reporting. The position requires at least 3 years of analytics engineering, data engineering, or related technical experience, including production SQL and Python. Work is in person Monday through Friday, with some nights and weekends as needed; remote and hybrid schedules are not available.

Requirements

  • Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or a related field, or equivalent experience.
  • At least 3 years of experience in analytics engineering, data engineering, or a related technical role.
  • Strong production SQL skills, including complex joins, window functions, CTEs, set-based logic, and building materialized or summary tables.
  • Python experience for data pipelines, transformation, and scheduled-job automation in a shared, config-driven codebase.
  • Azure SQL and Databricks/Spark (PySpark) experience at multi-million-row scale, including Databricks Jobs/Workflows orchestration.
  • Experience with pipeline patterns such as SCD Type 2, delta or materialized refresh, staging-and-promote, and idempotent reruns.
  • Browser automation or web scraping experience using Playwright or a similar tool.
  • Working ability with Next.js, React, TypeScript, and Tailwind.
  • Experience with Azure DevOps work items, branches, and pull requests.
  • Power BI and semantic modeling experience, 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 or marketing analytics, including GA4 and lead attribution.
  • Analytical modeling skills, including attribution, segmentation, and cohort or trend analysis.
  • Ability to turn open-ended leadership questions into repeatable models.
  • Ability to work with high autonomy and manage multiple workstreams.
  • Commitment to clean, reviewable code and durable documentation.
  • Ability to communicate results and caveats clearly to technical and non-technical audiences.

Nice To Haves

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

Responsibilities

  • Share responsibility for daily executive reporting and automated email delivery, including coverage during absences, for reports sent to general managers, platform directors, and leadership.
  • Monitor reporting refreshes, surface failures, provide daily summaries, and support prompt recovery.
  • Identify data anomalies and notify the responsible data-source or program owners.
  • Review report outputs before distribution, investigate unexpected variances, and explain them.
  • Build and operate production pipelines using the config-driven EDW framework, including configuration, DDL, refresh logic, and validation.
  • Own daily browser-automation ingestion of vendor and website data sources that do not provide APIs.
  • Contribute to change tracking and refresh optimization, including SCD Type 2, delta or materialized refreshes, indexing, and query tuning at multi-million-row scale.
  • Support orchestration through job scheduling, trigger chaining, and dependency management.
  • Extend SwickardBot’s schema-grounded knowledge base and improve classification and SQL-generation quality.
  • Build and maintain the AI assistant’s test and validation suite, including scenario coverage, confidence thresholds, anti-hallucination checks, and a registry of high-confidence examples.
  • Contribute to the AI Pricing Project, with the goal of becoming a primary contributor over time.
  • Contribute to internal web applications, turn analytics logic into self-service features, and reverse-engineer existing models into build-ready specifications.
  • Develop advanced analytics, including attribution modeling, segmentation, and cohort or trend analysis, and translate leadership questions into analytical models and AI-assistant capabilities.
  • Manage multiple workstreams independently and deliver through Azure DevOps using clear scoping, pull requests, and durable documentation.
  • Perform other duties as assigned.

Benefits

  • Medical, dental, and vision insurance
  • Life insurance and supplemental coverage options
  • Paid time off
  • Paid holidays
  • Career growth within a high-growth dealer group
  • Employee vehicle purchase and service discounts
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service