1 day ago
Base Salary
$138k - $173k/yr
Responsibilities
- Build and operate reliable pipelines that ingest production database, SaaS, and third-party API data into Snowflake.
- Orchestrate batch, incremental, and CDC workloads in Airflow and onboard new sources with clear schema, freshness, and ownership contracts.
- Design and own dbt models for merchants, orders, payments, revenue, and product usage, including reusable macros and documentation.
- Unify data across legacy and next-generation POS platforms and create curated marts for Finance and Product analytics.
- Define data quality tests, monitor pipeline health and freshness, respond to incidents, perform root-cause analysis, and reconcile financial data against source systems.
- Tune Snowflake and dbt workloads, manage incremental strategies and warehouse sizing, and monitor platform spend and usage.
- Partner with analysts, Finance, Product, and Engineering to create durable data products and mentor teammates through code review and documentation.
Requirements
- 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 and Snowflake or a comparable cloud warehouse.
- Strong data modeling knowledge including dimensional modeling, grain, slowly changing dimensions, and models for downstream consumers.
- Experience operating production pipelines with orchestration, monitoring, alerting, and on-call ownership.
- Experience building data quality checks and supporting product analytics or financial analytics.
- Clear communication with technical and non-technical stakeholders.
- Preferred experience includes payments, fintech, POS, SaaS, CDC or streaming ingestion, platform migrations, Snowflake administration, data observability, infrastructure as code, BI or semantic layers, and AI or agent access to warehouse data.
Benefits
- Remote work with occasional availability to come into the Chicago office.
- Base pay range of $130,000-$173,000 per year, plus a company stock plan.
- Medical, dental, and vision insurance.
- 401k with company match and RSUs.
- Paid vacation, 10 company holidays, sick time, and volunteer time off.
- Employee Resource Groups, monthly cell phone and internet stipend, and tuition reimbursement of up to $2,000 per calendar year.
Tech Stack
Categories
Data Engineering
About SpotOn
SpotOn builds point-of-sale and commerce software for restaurants and local businesses, combining payment processing with tools for online ordering, reservations, loyalty, and reporting. The company sells subscriptions, hardware, and transaction services, often delivered through local sales reps and implementation support. Founded in 2017 and headquartered in San Francisco, it is privately held and focuses on independent restaurant operators across the U.S.