Spoton

Senior Analytics Platform Engineer

Chicago, IL. Posted 3 days ago

The role

You will own the analytics platform end to end by building and operating data pipelines. You will design core dbt models and unify data across multiple platforms to serve analysts, finance, and product teams.

What you will do

  • Build and operate reliable pipelines that land data into Snowflake
  • Orchestrate batch and incremental workloads in Airflow
  • Onboard new sources with clear contracts for schema and freshness
  • Design and own core dbt models for merchants, orders, payments, revenue, and product usage
  • Unify data across platforms and product lines into consistent models
  • Build curated, analysis-ready marts for finance and product analytics
  • Write reusable macros and conventions for dbt
  • Define and enforce data tests for uniqueness, nulls, and referential integrity
  • Own monitoring and alerting for pipeline health and volume anomalies
  • Reconcile financial data against source systems

Required qualifications

  • 5+ years of experience in data engineering, analytics engineering, or a closely related role
  • Expert SQL: complex joins, window functions, incremental logic, and query performance tuning
  • Strong Python for pipeline development, automation, and tooling
  • Deep hands-on experience with dbt and Snowflake or a comparable cloud warehouse
  • Strong data modeling fundamentals: dimensional modeling, grain, slowly changing dimensions
  • Experience building and operating production pipelines with orchestration like Airflow
  • A testing mindset
  • Experience supporting product analytics or financial analytics
  • Clear communication with both technical and non-technical stakeholders
  • Work authorization in the U.S. is required

Nice to have

  • Experience in payments, fintech, POS, or SaaS businesses
  • CDC and streaming ingestion (e.g., Debezium, Kafka, Streamkap) or modern ingestion frameworks (e.g., dlt, Fivetran)
  • Unifying data across platform migrations or multiple product backends
  • Snowflake administration: RBAC, cost governance, warehouse management
  • Data observability tools, CI/CD for dbt, and infrastructure as code
  • Experience enabling BI and semantic layers or AI/agent access to warehouse data

Benefits

  • Medical, Dental and Vision Insurance
  • 401k with company match
  • RSUs
  • Paid vacation
  • 10 company holidays
  • Sick time
  • Volunteer time off
  • Employee Resource Groups
  • Monthly cell phone and internet stipend
  • Tuition reimbursement for up to $2,000 per calendar year

Before you apply

  • Work authorization in the U.S. is required
  • Visa sponsorship is not available for this role

About the company

SpotOn provides independent restaurants with tools like point-of-sale and AI-powered profit tools to compete and win. They are a multi-year award winner for being a Great Place to Work.

Senior Analytics Platform Engineer at Spoton | JobZoey