Description Las Vegas, NV | Analytics engineering | Data engineering | SQL | Python | Databricks | PySpark | Azure SQL | Power BI | Azure DevOps | Playwright | React | Next.js | TypeScript | AI | LLM | KPI reporting | Automotive retail | On-site only | In-person | No remote | No hybrid | Shared services | Veterans encouraged to apply | $90,000 - $110,000/yr
**Work is in person at our Las Vegas Shared Services office, Monday through Friday, with some nights and weekends as needed. This role is on-site only, and remote or hybrid schedules are not available.**
IS THIS YOU?
- You're equally comfortable writing production SQL, Python, and application code, and you care about getting the data right
- You want to build the data leadership relies on and the software that delivers it, working in person with our Las Vegas team -- this role is on-site only, with no remote or hybrid option
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.
WHAT YOU'LL DO
- Own daily executive reporting and automated email delivery, including scheduled report bots that deliver sales, service, appointment, trade-in, and KPI summaries to GMs, platform directors, and leadership every morning.
- Design and maintain KPI and attribution models, including pre-owned KPIs, lead attribution (including GA4 web analytics), offer conversion, and financial/trial-balance rollups, ensuring accuracy and consistency organization-wide.
- Own reporting-lane monitoring, ensuring the reliability of every refresh with clear failure signals, daily summaries, and fast recovery before issues 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.
WHAT WE'RE LOOKING FOR
- Bachelor's degree in Computer Science, Data Science, Information Systems, Statistics, or a related field (or equivalent experience) -- required
- 3+ years of experience in analytics engineering, data engineering, or a related technical role -- required
- Strong production SQL, including complex joins, window functions, CTEs, set-based logic, and building materialized/summary (silver to gold) tables -- required
- Python for data pipelines, transformation, and scheduled-job automation in a shared, config-driven codebase -- required
- Azure SQL and Databricks/Spark (PySpark) at multi-million-row scale, including Databricks Jobs/Workflows orchestration -- required
- Pipeline patterns such as SCD Type 2, delta/materialized refresh, staging-and-promote, and idempotent re-runs -- required
- Browser automation or web scraping with Playwright or a similar tool -- required
- Working ability in Next.js, React, TypeScript, and Tailwind -- required
- Azure DevOps work items, branches, and pull requests -- required
- Power BI and semantic modeling, including DAX, Power Query/M, and dataset management -- required
- LLM product experience, including natural-language-to-SQL, RAG few-shot curation, confidence thresholds, and anti-hallucination patterns -- preferred
- Python/FastAPI or Java/Spring REST APIs over Azure SQL with Azure AD/Entra (MSAL) authentication -- preferred
- Azure App Service, Static Web Apps, Container Apps, and Key Vault -- preferred
- 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.
WHAT WE OFFER
- $90,000 - $110,000/yr
- 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
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
If you build data systems and software with care and want to do that work in person with our Las Vegas team -- apply.