Data Engineer

Teal Drones; Salt Lake City, Northern (UT, KY); Hybrid; USD 95,000 - 135,000; Full time

Job summary

Red Cat Holdings is seeking a Data Engineer to build our data foundation from the ground up in Salt Lake City. You will stand up our first analytics data warehouse and implement ETL/ELT pipelines that keep data accurate, fresh, and easy to use.

You’ll work with stakeholders and engineers to translate questions into durable datasets, ensure data quality, and enable self-serve analytics. This role emphasizes observability and scalable pipelines.

Qualifications

• Bachelor's degree in computer science, data engineering, information systems, or equivalent technical degree.
• 3+ years of data engineering experience, specifically in managing a data warehouse.
• Strong SQL skills (joins, window functions, reliable transformation logic).
• Comfortable in Python (or a similar language) for pipeline code, automation, and data tool glue.
• Understanding of data warehousing basics: tables, partitions, incremental loads, and modeling implications.
• Hands-on exposure to ETL/ELT or pipelines in production or major projects.
• Solid engineering habits: Git, readable code, and documentation.

Responsibilities

• Build and maintain ETL/ELT pipelines ingesting data from multiple sources (internal DBs, SaaS tools, external APIs).
• Implement scheduling/orchestration, retries, and alerting for visibility and recovery.
• Design scalable pipelines with incremental processing patterns.
• Assist in standing up a cloud data warehouse (Snowflake/BigQuery) and initial schema.
• Add data quality checks, lineage, and observability (freshness, SLAs, monitoring).
• Collaborate with stakeholders to translate questions into durable datasets and self-serve data products.
• Document data sources, models, and assumptions; participate in on-call rotation.

Skills

SQL

Python

Data warehousing

ETL/ELT pipelines

Git

Documentation

Education

Bachelor's degree in computer science or related field

Tools

dbt

Airflow

Snowflake

BigQuery

Redshift

Job description

Job DetailsJob Location: Red Cat Corporate - Salt Lake City, UT 84115

Position Summary

We’re hiring a Data Engineer to build our data foundation from the ground up.

Today, our data lives across transactional databases, SaaS tools, and external APIs. Over the next few months, you’ll help us stand up our first analytics data warehouse and build the ETL/ELT pipelines that keep it accurate, fresh, and easy to use.

You won’t be doing this alone—you’ll work closely with stakeholders (Product, Ops, Finance, and Analytics) and with engineering teammates to make pragmatic choices and ship value quickly.

Essential Duties and Responsibilities

Building Pipelines and Ingestion

• Build and maintain ETL/ELT pipelines that ingest data from multiple sources (e.g., internal DBs, SaaS tools, and third-party APIs), and keep them running reliably.
• Implement scheduling/orchestration, retries, and alerting so failures are visible and recoverable.
• Design pipelines using incremental processing patterns for scalability and cost efficiency.

Standing up the Warehouse and Models

• Help set up our first cloud data warehouse (e.g., Snowflake or BigQuery) and the initial schema/layout.
• Add data quality checks (tests, constraints, anomaly detection, reconciliation checks) and fix root causes when numbers look wrong.
• Create lightweight observability: freshness/SLAs, pipeline run monitoring, and basic lineage documentation.
• Make thoughtful tradeoffs between performance, usability, and maintainability.

Collaboration and Enablement

• Work with stakeholders to translate questions into durable datasets (not one-off queries).
• Document sources, models, and assumptions so teammates can self-serve and onboard quickly.
• Participate in a reasonable support/on-call rotation once the stack is live.

Required Qualifications

• Bachelor’s degree in computer science, data engineering, information systems, or equivalent technical degree.
• 3+ years of data engineering experience, specifically in managing a data warehouse.
• Strong SQL skills (joins, window functions, building reliable transformation logic).
• Comfortable in Python (or a similar language) for pipeline code, automation, and data tool glue.
• Understanding of data warehousing basics: tables, partitions (where relevant), incremental loads, and why modeling choices matter.
• Some hands‑on exposure to ETL/ELT or pipelines in production or in a substantial project/internship (we care about proof you can ship and debug).
• Solid engineering habits: Git, readable code, and a willingness to write things down.

Additional Desired Qualifications

• dbt experience (models + tests + docs) or the ability to ramp quickly.
• Orchestration experience (Airflow, Dagster, Prefect, or similar).
• Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift).
• Experience ingesting data from APIs and messy SaaS exports (rate limits, pagination, schema drift, deduping).
• Familiarity with basic data quality/observability practices (freshness checks, anomaly detection, monitoring/alerting).

Physical Requirements and Working Conditions

• Must be able to walk, stand, and navigate large indoor and outdoor facilities for extended periods of time.
• Ability to lift, carry, and move materials and equipment weighing up to 25 lbs on a regular basis.
• Use of personal protective equipment (PPE) may be required in designated areas or when performing specific tasks, in accordance with safety protocols and company policy.
• May be required to climb ladders, stoop, kneel, or crouch during inspections, maintenance walk-throughs, or emergency response situations.
• Regular exposure to facility operations including noise, dust, temperature fluctuations, and industrial equipment.
• Occasional off‑hours or weekend work required for emergency facility responses or projects as needed
• Requires frequent use of a computer and other standard office equipment for documentation, communication, and coordination tasks.

Background Check

This position will require successfully completing a post-offer background check. Qualified candidates with a criminal history will be considered and are not automatically disqualified, consistent with federal and state law.

EEO and ITAR/EAR Work Authorization Disclosure

Red Cat Holdings provides equal employment opportunities (EEO) to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This position requires direct or indirect access to hardware, software, technology or technical data controlled under the International Traffic in Arms Regulations (ITAR) and the Export Administration Regulations (EAR). Successful candidates for positions subject to ITAR/EAR restrictions must provide proof of U.S. Citizenship or Permanent Residence and must not require sponsorship for export-restricted work authorization.

E-Verify

The company participates E-Verify ensure eligibility for employment and compliance with Right to Work rules.

Compensation: Base pay, plus generous annual equity package and potential bonuses.

Qualifications