Senior Data Engineer (US)
Summary
Senior Data Engineer at Firstup designs and builds scalable data pipelines, warehouse models, and analytics for its employee-communication SaaS platform, including natural-language/GenAI interfaces to data. Core stack: SQL, large-scale warehouses (StarRocks/Redshift/Snowflake/Databricks/Trino), Kafka/Spark, Python, AWS/GCP.
The Senior Data Engineer will design and build reliable data solutions that translate complex product and business logic into scalable, well-tested data models and pipelines. This role requires deep expertise in SQL, query acceleration, and applying GenAI to both engineering workflows and data/analytics interfaces. They will partner across engineering, analytics, and business teams, contribute to shared codebases, improve data quality and observability, and help evolve the data architecture.
Responsibilities
-
Design, build, and maintain scalable data pipelines, warehouse models, and analytics solutions, balancing data quality, business value, and speed.
-
Build and maintain natural language interfaces to data and analytics, applying GenAI/LLM techniques to make data more accessible across the business.
-
Use GenAI coding tools and practices in daily development to improve code quality, testing, and delivery speed.
-
Continuously evaluate new technologies that could improve and scale the team's data platform and technology stack.
-
Establish and follow standards for SQL development, data modeling, testing, documentation, code reviews, and production support.
-
Support production data pipelines through on-call rotation and incident response, partnering with engineering, analytics, and business teams.
-
Document and maintain expertise in the technology stack and product domain, translating business needs into technical solutions with product management.
Minimum Qualifications
-
Bachelor's degree in Computer Science or related field, or equivalent professional experience.
-
8+ years building reliable, high-performance, large-scale distributed systems, with an emphasis on streaming and data pipelines.
-
Experience working with and maintaining multi-tenant SaaS experiences.
-
Experience building natural language interfaces over data warehouses, including applying GenAI/LLM techniques to data and analytics.
-
Enterprise-level experience with at least one large-scale analytical data warehouse or query engine: StarRocks, Amazon Redshift, Snowflake, Databricks, or Trino.
-
Expertise writing, optimizing, and analyzing SQL.
-
Hands-on experience building and operating distributed data platforms on AWS or GCP.
-
Hands-on experience with streaming platforms such as Kafka and Spark.
-
Experience scaling data modeling and warehousing.
-
Proficiency in python.
Preferred Qualifications
-
Experience with Cube or other semantic layers.
-
Experience with scheduling tools such as Airflow.
-
Familiarity with the BI tool Metabase.
-
Proficiency in Ruby on Rails, React, or other adjacent languages.
Skills
As published by lever · 12 questions · 5 written answers
Basics
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, GitHub URL, Stack Overflow URL, Portfolio URL, Twitter URL, Other website
Short answers (1)
- What are your salary expectations?
Pick from a list (6)
- Are you subject to any post-termination restrictions, including non-compete or non-solicitation obligations, that could materially affect your ability to perform this role?
- If offered employment, do you acknowledge that the offer may be conditional upon successfully completing relevant pre-employment checks, in accordance with applicable law?
- Do you have hands-on experience with AWS?
- Have you entered into or signed a non-compete or non-solicitation agreement with your current or previous employer that could interfere with your application for employment? optional
- Do you now or will you in the future require sponsorship to work legally in the country in which the job is located?*Please note: Proof of eligibility may be required at time of hire. optional
- If offered a position with our organization, do you acknowledge that depending on local law/relevant legislation you may be required to successfully complete pre-employment screening? optional
Written answers (5)
- Do you have experience with SQL, Python, Ruby and Typescript? Please list each below and the number of years of experience with each.
- How many years of experience do you have designing and maintaining data pipelines?
- How many years of experience do you have with data streaming and CDC?
- How many years of experience do you have with Gen-AI engineering workflows?
- Address (City, State)