Data Engineer

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. #J-18808-Ljbffr Red Cat Holdings