Data Engineer
Red Cat Holdings · Salt Lake City, UT · 2 wk ago
Information TechnologyVolunteer
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’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
- 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.
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.
- 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).