S

SpotOn

Payment processing and customer engagement platform

Senior Analytics Platform Engineer

Data EngineeringPosted on Nov 10
Full-timeChicago, IL, USA$130k - $173k /yr

About the Job

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 Snowflake or a comparable cloud warehouse.
  • Strong data modeling fundamentals, including dimensional modeling, grain, slowly changing dimensions, and designing models for many downstream consumers.
  • Experience building and operating production pipelines with orchestration such as Airflow, including monitoring, alerting, and on-call ownership.
  • Ability to build data quality checks and assess when data is reliable or requires further investigation.
  • Experience supporting product analytics, including event data, funnels, adoption, or retention, and/or financial analytics, including revenue, payments, or reconciliation.
  • Ability to communicate clearly with technical and non-technical stakeholders.
  • Work authorization in the United States is required.

Responsibilities

  • Build and operate reliable pipelines that ingest data from production databases using change data capture, SaaS tools, and third-party APIs into Snowflake.
  • Orchestrate batch and incremental workloads in Airflow, selecting the appropriate full, incremental, or change-data-capture load pattern for each source.
  • Onboard new sources quickly and 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, including legacy and next-generation point-of-sale systems, into consistent, well-documented models.
  • Build curated, analysis-ready marts for finance and product analytics, and enable self-service for power users through clean semantics and documentation.
  • Write reusable macros and conventions to keep the dbt project consistent and maintainable as it grows.
  • Define and enforce data tests for uniqueness, nulls, referential integrity, and metric reconciliation as part of every model.
  • Own monitoring and alerting for pipeline health, freshness, and volume anomalies; respond to incidents, conduct root-cause analysis, and fix underlying problems.
  • Reconcile financial data, including processing volume, fees, revenue, and billing, against source systems.
  • Tune Snowflake and dbt workloads, incremental strategies, clustering, materialization choices, and warehouse sizing to maintain performance and predictable costs.
  • Monitor platform spending and usage and recommend cost-effective changes.
  • Partner with analysts, finance, product, and engineering teams 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 review generated output rigorously.

Desired Qualifications

  • Experience in payments, fintech, point-of-sale, or SaaS businesses.
  • Experience with change data capture and streaming ingestion tools 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 role-based access control, cost governance, and warehouse management.
  • Experience with data observability tools, continuous integration and continuous delivery for dbt, and infrastructure as code.
  • Experience enabling business intelligence and semantic layers such as Metabase, Looker, or dbt Semantic Layer, or AI/agent access to warehouse data.

About the Company

SpotOn

Payment processing and customer engagement platform

SpotOn provides payment processing solutions and integrated customer engagement tools tailored for small businesses such as restaurants, retail stores, and service providers. It offers an end-to-end digital platform that helps businesses get paid faster, increase revenue, and improve efficiency by unifying payments, loyalty, booking, and ordering with operational tools into one system. Transactions generate revenue for SpotOn through processing fees and subscription fees for software services, while its consumer-facing app connects customers to merchants for deals, rewards, appointments, and orders. Compared with competitors, SpotOn combines payment processing with a wide suite of engagement and business-management tools in a single, easy-to-use platform backed by 24/7 customer support. The company’s goal is to help small businesses grow by simplifying payments, boosting customer engagement, and streamlining operations.

Company size
1,001-5,000
Company stage
Series F
Total funding
$915M
Headquarters
San Francisco, CA
Founded
2010

Recently Posted Jobs

Explore more opportunities at SpotOn

See more jobs