Software Development Engineer II – Data Engineer

OpenKrill; United States; Presencial; USD 110.000 - 160.000; Jornada completa

Descripción de la vacante

Gather AI is building the data foundation for a next‑gen warehouse intelligence platform, with autonomous drones and real‑time analytics. We’re hiring an SDE II, Data Engineer, to join the India‑based remote team and own early data pipelines from the ground up.

You’ll ship scoped pipelines, extend the dbt data model, and define metrics that stay consistent across dashboards. Strong SQL, Python, and cloud experience are essential for success in this role.

Formación

• 2–5 years building and running production data pipelines.
• Strong SQL with joins, window functions, and CTEs, and dimensional modelling.
• Hands-on dbt, Snowflake, Databricks or equivalent experience.
• Production Python code with tests and reviews.
• Experience with orchestration tools like Airflow or Dagster.

Responsabilidades

• Build extraction pipelines moving data from production to analytical warehouse using incremental loads.
• Write and extend the shared data model with dbt models and metrics.
• Define metrics in the semantic layer and ensure consistency across dashboards.
• Add tests, freshness checks, and alerts; support backfills as needed.
• Maintain data lineage and apply tenant isolation in pipelines.
• Document work and collaborate across teams; ship through CI/CD.

Conocimientos

SQL

dbt

Python

Airflow

Snowflake

Databricks

Azure

Data modeling

Data quality

Git / CI/CD

Documentation

English comms

Educación

BS in Computer Science

Herramientas

dbt

Snowflake

Databricks

Airflow

Dagster

Descripción del empleo

About Us

Are you ready to build the future of the supply chain? At Gather AI, we're not just creating software; we're pioneering a new era of warehouse intelligence. We've developed a groundbreaking, vision-powered platform that uses autonomous drones and existing equipment to capture real-time data, completely digitizing workflows that have historically been manual and error-prone. This means facilities operate smarter, safer, and more efficiently, ultimately redefining "on-time, in full" delivery.

If you're looking for an opportunity to contribute to truly transformative technology and make a significant impact in a vital industry, Gather AI is the place for you. We're leading the charge in the rapidly evolving robotics industry, and we invite you to join us in reshaping the global supply chain, one intelligent warehouse at a time.

About the Team

You'll join the Full Stack group within Cloud Services, which is being built now. Today, production and analytical workloads share a single database, and each product defines its own metrics. This team exists to fix that by designing and building the warehouse, transformation layers, and semantic model from the ground up. You'll work closely with Full Stack, ML, Product, Security, and Customer Success.

About the Role

Most data engineers early in their careers maintain one slice of a large, mature platform, or build pipelines against a model someone else designed years ago. This role is the opposite.

As an SDE II, Data Engineer, you'll be one of the first engineers building Gather AI's data foundation from scratch. The work includes:

• - Moving analytics off our production PostgreSQL database
• - Writing the layered dbt models every product will share
• - Defining metrics once so they stay consistent everywhere
• - Linking structured records back to the drone images and video they came from

You’ll start by shipping well-scoped pipelines and models on our Drone product alongside senior engineers. From there, you’ll grow toward owning a data domain end to end: its design, its quality, and its on-call.

This is a fully remote role on our India-based team. We work across multiple time zones, so clear written communication, initiative, and the ability to make progress independently matter.

What You’ll Do

• - Build extraction pipelines. Move data from production PostgreSQL into the analytical warehouse (raw, refined, serving) using incremental loads that protect the production database.
• - Build and extend the shared data model. Write and maintain dbt models, such as dimensions, reusable metric building blocks, and serving tables, following the architecture set by our Principal Data Engineer.
• - Implement metrics. Add metrics to the semantic layer so a measure like "scan accuracy by site" is defined once and matches across every dashboard.
• - Keep data trustworthy. Add tests, freshness checks, and alerts to the pipelines you build, and help run safe backfills when data needs correcting.
• - Build in tenant isolation. Apply our access-control and tenant‑separation patterns to every model and pipeline you ship.
• - Maintain lineage. Keep metrics traceable to their source records and drone images, so any number can be checked against the original capture.
• - Work at the ingestion boundary. Partner with the integration team to validate incoming WMS data against agreed contracts.
• - Document your work. Keep models documented and registered in the data catalog.
• - Ship safely. Deliver through CI/CD, use AI‑assisted development, and join on‑call for the pipelines you own.
• - Grow with the platform. Start on the Drone product, then help onboard MHE Vision, 3D case counting products onto the same data foundation over the year.

What You’ll Need

• - Experience: 2–5 years building and running production data pipelines, and a degree in Computer Science or equivalent practical experience.
• - SQL: Strong SQL, including joins, window functions, and CTEs, plus a working understanding of dimensional modelling (facts, dimensions, grain). PostgreSQL experience preferred.
• - Transformation: Hands‑on experience building tested models in dbt, Snowflake Dynamic Tables, Databricks Lakeflow Declarative Pipelines, or equivalent.
• - Python: Production pipeline code with tests and code review, beyond notebooks or one‑off scripts.
• - Orchestration: Experience running pipelines in Airflow, Dagster, Databricks Lakeflow Jobs, Snowflake Tasks, or equivalent, including handling failures, re‑runs, and backfills.
• - Data movement: Has loaded data from an operational database into a warehouse or lakehouse such as Snowflake or Databricks.
• - Cloud: Production experience on Azure or another major cloud, including object storage, Git, CI/CD, and Docker/Kubernetes.
• - Data quality mindset: Writes tests alongside code and cares whether data is correct, not just whether the job ran.
• - Ownership and growth: Hands‑on and curious. Digs into problems beyond their own code, brings ideas to the team, and takes review feedback well.
• - Communication: Clear written and spoken English. Writes good PRs and documentation and raises blockers early in a distributed team.

Nice to Have

• - Change data capture (Debezium, Fivetran) or streaming (Kafka, Event Hubs)
• - PySpark or Snowpark
• - Terraform or other infrastructure as code
• - Semantic layers (dbt Semantic Layer, Cube) or data catalogs (Purview, DataHub)
• - Multi‑tenant data platforms or row‑level security
• - Working with image, video, or sensor data alongside structured records
• - Logistics, warehousing, or robotics domain experience