Senior Data Platform Engineer

SpotOn•Chicago, IL
•$137,550 - $173,000•Remote

About The Position

SpotOn is hiring a hands-on, high-ownership engineer for its Data Platform team. The role owns the analytics platform end to end, from ingesting data from production systems and third-party tools through pipeline monitoring and job health to the core dbt models used by analysts, Finance, Product, and other company power users. The engineer will treat data as a product: understand its users, detect data issues proactively, and design models that make reliable answers easy to find. The work includes unifying data across multiple POS platforms, payment systems, and SaaS products, including sources that are similar but not identical. The position partners with analysts, Finance, Product, and Engineering to build durable data products, improve data practices, and support self-service analytics. The role is remote, with occasional availability to come into the Chicago office. Base pay starts at $130,000–$173,000 per year, with offers reflecting location and experience. The compensation package also includes a company stock plan.

Requirements

  • At least 5 years of experience in data engineering, analytics engineering, or a closely related role.
  • Expert SQL skills, including complex joins, window functions, incremental logic, and query performance tuning.
  • Strong Python skills for pipeline development, automation, and tooling.
  • Deep hands-on experience with dbt, including models, tests, macros, incremental materializations, and documentation, and with Snowflake or a comparable cloud warehouse.
  • Strong data modeling fundamentals, including dimensional modeling, grain, slowly changing dimensions, and designing models for multiple downstream consumers.
  • Experience building and operating production pipelines with orchestration such as Airflow or similar, including monitoring, alerting, and on-call ownership.
  • A testing mindset, including building data-quality checks into work from the start and evaluating whether data is trustworthy.
  • Experience supporting product analytics, such as event data, funnels, adoption, and retention, and/or financial analytics, such as revenue, payments, and reconciliation.
  • Clear communication with technical and non-technical stakeholders.
  • U.S. work authorization is required for U.S.-based roles; visa sponsorship is not available.

Nice To Haves

  • Experience in payments, fintech, POS, or SaaS businesses.
  • Experience with CDC and streaming ingestion (such as Debezium, Kafka, or Streamkap) or modern ingestion frameworks (such as dlt or Fivetran).
  • Experience unifying data across platform migrations or multiple product backends.
  • Snowflake administration experience, including RBAC, cost governance, and warehouse management.
  • Experience with data observability tools, dbt CI/CD, and infrastructure as code.
  • Experience enabling BI and semantic layers (such as Metabase, Looker, or dbt Semantic Layer) or AI/agent access to warehouse data.

Responsibilities

  • Build and operate reliable pipelines that ingest data from production databases using CDC, SaaS tools, and third-party APIs into Snowflake.
  • Orchestrate batch and incremental workloads in Airflow, selecting an appropriate full, incremental, or CDC load pattern for each source.
  • Onboard new data sources repeatably, with clear contracts for schema, freshness, and ownership.
  • Design and own core dbt models for merchants, orders, payments, revenue, and product usage.
  • Unify data across platforms and product lines into consistent, well-documented models.
  • Build curated, analysis-ready marts for Finance and Product analytics and enable self-service for power users through clear semantics and documentation.
  • Create reusable dbt macros and conventions to keep the project consistent and maintainable.
  • Define and enforce data tests, including uniqueness, null, referential-integrity, and metric-reconciliation checks.
  • Own monitoring and alerting for pipeline health, freshness, and volume anomalies; respond to incidents, perform root-cause analysis, and address underlying problems.
  • Reconcile financial data such as processing volume, fees, revenue, and billing against source systems.
  • Tune Snowflake and dbt workloads, incremental strategies, clustering, materializations, and warehouse sizing to improve speed and control costs.
  • Monitor platform spending and usage and recommend cost-effective changes.
  • Partner with analysts, Finance, Product, and Engineering to translate ambiguous business questions into durable data products.
  • Improve SQL, modeling, and testing practices through code review, documentation, and mentorship.
  • Use AI-assisted development tools thoughtfully and rigorously review their output.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • 401(k) 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 of up to $2,000 per calendar year
  • Company stock plan
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service