Senior Data Engineer (Clickhouse)

SPOTON INC
New York, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 190K

Job location

New York, United States of America

Tech stack

JavaScript
Artificial Intelligence
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Cloud Computing
Databases
Information Engineering
Data Infrastructure
ETL
Data Systems
Data Warehousing
DevOps
Distributed Systems
Identity and Access Management
Python
PostgreSQL
Machine Learning
MongoDB
Performance Tuning
Cloud Services
Next.js
Software Engineering
Software Systems
SQL Databases
TypeScript
Data Logging
React
Snowflake
Grafana
Database Performance
Core Data
Kubernetes
Data Analytics
Real Time Data
Kafka
Front End Software Development
Data Pipelines
Docker

Job description

We're not just building restaurant tech, we're giving independent restaurants the tools to compete and win. From our award-winning point-of-sale to AI-powered profit tools, everything we do helps operators boost profit, work smarter, and keep their best people. And every solution is backed by real humans who actually give a sh*t about helping restaurants succeed.

  • Named the #1 Restaurant POS by G2 (Fall 2025), based on ratings from real users
  • Rated the top-rated point-of-sale (POS) for restaurants, bars, retail, and small businesses by Capterra users
  • Awarded Great Places to Work and Built In's Best Workplaces for multiple years running

We move fast, care hard, and fight for independent restaurant operators to do what they love, and love doing it. If you're looking to make an impact with heart and hustle, SpotOn is the place for you.

As a Senior Data Engineer on our Data and Reporting team, you'll be responsible for designing, building, and maintaining high-performance, scalable data systems and data infrastructure. You will collaborate closely with cross-functional teams, including product management, engineering leadership, to enhance existing platforms and develop innovative solutions for complex data-driven applications.

On a daily basis you will:

  • Architect, develop, and maintain scalable software solutions for our reporting and analytics platforms.
  • Design and implement data pipelines, ETL processes, and integrations using ClickHouse, Streamkap, PostgreSQL, Snowflake, MongoDB, Kafka, and AWS.
  • Write and Optimize SQL queries that drive merchant reporting outcomes and improve database performance across large-scale, distributed systems.
  • Contribute to defining and refining system architectures, including cloud infrastructure and containerization strategies.
  • Implement robust data observability monitoring, logging, and alerting solutions using tools like Grafana, Metaplane, and OpenTelemetry.
  • Mentor junior and mid-level engineers, promoting technical excellence and best practices.

Requirements

Do you have experience in Python?, * 5+ years of professional software and data engineering experience.

  • Proficient in Python; experience with GO and TypeScript or JavaScript is highly beneficial.
  • Extensive experience with databases and data warehouses such as ClickHouse, PostgreSQL, and MongoDB.
  • Strong understanding of real-time data streaming and messaging systems, especially Kafka.
  • Experience designing and implementing robust ETL pipelines and handling large-scale data migrations.
  • Familiarity with cloud services, especially AWS, including IAM roles, S3, RDS, and MSK.
  • Proven ability in performance tuning and optimization for high-volume, low-latency data systems.
  • Experience applying core data observability principals to create a transparent and resilient data platform.
  • Comfortable with containerization technologies such as Docker and orchestration tools like Kubernetes.
  • Strong experience with infrastructure as code (IaC) tools and best practices.
  • Deep understanding of software development best practices, CI/CD pipelines, and DevOps methodologies.

Perfect candidate also has:

  • Experience in building frontend components or familiarity with React and Next.js.
  • Knowledge of monitoring and observability tools, including Grafana and OpenTelemetry.
  • Background or interest in data analytics, machine learning applications, and causal analysis.
  • Experience in the restaurant or hospitality technology sector.

Apply for this position