Job Summary:
Red Cat Holdings is seeking a Data Engineer to build their data foundation from the ground up. The role involves creating ETL/ELT pipelines, setting up a cloud data warehouse, and collaborating with various stakeholders to ensure data quality and accessibility.
Responsibilities:
• 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.
• 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.
• 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.
Qualifications:
Required:
• 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.
Preferred:
• 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).
Company:
Red Cat (Nasdaq: RCAT) is a U.S.-based provider of advanced all-domain drone and robotic solutions for defense and national security. Founded in 2016, the company is headquartered in San Juan, PRI, with a team of 51-200 employees. The company is currently Growth Stage.