Data Engineer

Troveo AI; Oregon; Hybrid; USD 160,000 - 175,000; Full time

Benefits offered by this job

Health Benefits

Flexible PTO

Remote-First Policy

Learning & Growth

Equity Ownership

Modern Tech Stack

Job summary

Troveo is seeking a hands-on Data Engineer to own and scale an analytics data warehouse, build robust data pipelines, and partner with software engineers and business stakeholders. This hybrid role blends data engineering, modeling, analytics, and operational duties to ensure reliable data delivery across teams.

You will design pipelines, apply dimensional modeling, and leverage dbt and cloud platforms to deliver analytics-ready datasets while monitoring quality, performance, and SLAs.

Qualifications

• 5+ years of professional experience in data engineering or analytics engineering.
• Strong proficiency in SQL and Python.
• Hands-on experience building and maintaining data pipelines and working with cloud data platforms/warehouses (Snowflake, BigQuery, Redshift, Databricks).
• Experience with data orchestration tools (Airflow, Dagster, Prefect).
• Solid understanding of data modeling techniques and dimensional modeling.
• Experience performing data analysis and working with BI/visualization tools (Looker, Tableau, Power BI).
• Proven ability to troubleshoot data issues and support operational reliability/SLAs.
• Strong communication skills and ability to collaborate with both technical and non-technical stakeholders.

Responsibilities

• Design, build, and maintain ELT/ETL data pipelines (batch and streaming).
• Design and implement conceptual, logical, and physical data models (dimensional modeling).
• Build and maintain transformation layers using modern tools (dbt) to create analytics-ready datasets.
• Monitor data pipelines and data deliveries to meet SLAs for timeliness, freshness, and accuracy.
• Collaborate with analysts, data scientists, engineers, and business stakeholders.
• Document data pipelines, models, lineage, and processes.

Skills

SQL

Python

Data modeling

BI analysis

Education

Bachelor's degree in CS/Engineering or related

Tools

Snowflake

BigQuery

Redshift

Databricks

Airflow

Dagster

Prefect

Job description

About Troveo

About TroveoTroveo builds the data platform that AI labs and model builders need to train the next generation of models. We have created the world's largest licensed platform of scarce, proprietary data for AI, spanning video, audio, text, and business workflows.Troveo indexes, enriches, and packages this high-quality data into formats ready for training, fine-tuning, evaluation, and agentic use cases. Backed by top investors, we're a small, high-impact team solving one of the biggest bottlenecks in AI development.

Role Overview

We are seeking a versatile, hands-on Data Engineer to build and maintain a scalable analytics data warehouse while contributing to data modeling, performing data analysis, and ensuring reliable data delivery to downstream teams and systems. This hybrid role combines core data engineering responsibilities with data modeling, analytics, and operational support. You will own the full analytics data lifecycle, from ingestion and transformation to modeling, quality assurance, and timely delivery, while partnering closely with software engineers and business stakeholders.

Key Responsibilities

Data Pipeline Engineering

• Design, build, and maintain ELT/ETL data pipelines (batch and streaming), optimizing for performance, reliability, scalability, and cost.
• Design and implement conceptual, logical, and physical data models (including dimensional modeling, star/snowflake schemas).
• Build and maintain transformation layers using modern tools (e.g., dbt) to create clean, well-documented, analytics-ready datasets.
• Apply data modeling best practices, versioning, testing, and documentation to ensure consistency and reusability.

Data Analysis & Reporting Support

• Write optimal SQL queries for data exploration, ad-hoc analysis, and troubleshooting.
• Support the creation of reports, dashboards, and self-service analytics assets in collaboration with data analysts and business teams.
• Translate business questions into data requirements and deliver actionable insights or datasets.

Operational Support & Data Deliveries

• Monitor data pipelines and data delivery processes to ensure SLAs for timeliness, freshness, and accuracy are consistently met.
• Proactively identify, troubleshoot, and resolve data issues impacting downstream consumers or business operations.
• Manage incidents related to data availability and quality; participate in on-call rotations as needed.
• Implement data quality checks, observability, and alerting to maintain high reliability of data deliveries.
• Automate operational tasks and continuously improve data delivery processes.

Collaboration & Best Practices

• Work cross-functionally with analysts, data scientists, engineers, and business stakeholders to understand data needs and deliver solutions.
• Document data pipelines, models, lineage, and processes.
• Contribute to data governance, security, and best practices across the data platform.

Requirements

• 5+ years of professional experience in data engineering or a closely related role (analytics engineering experience is highly relevant).
• Strong proficiency in SQL and Python.
• Hands-on experience building and maintaining data pipelines and working with cloud data platforms/warehouses. (Snowflake, BigQuery, Redshift, Databricks, etc.).
• Experience with data orchestration tools (Apache Airflow, Dagster, Prefect, or similar).
• Solid understanding of data modeling techniques and dimensional modeling.
• Experience performing data analysis and working with BI/visualization tools (Looker, Tableau, Power BI, or similar).
• Proven ability to troubleshoot data issues and support operational reliability/SLAs.
• Strong communication skills and ability to collaborate with both technical and non-technical stakeholders.

Bonus Points

• Experience with DBT for data transformation and modeling.
• Knowledge of data observability/monitoring tools.
• Experience with real-time/streaming data technologies (Kafka, Flink, etc.).
• Familiarity with CI/CD practices for data pipelines.
• Experience in data quality frameworks and governance.
• Bachelor's degree in Computer Science, Engineering, or a related quantitative field (or equivalent practical experience).

Compensation

• Base Salary : $160,000 - $175,000 (depending on experience and location)
• Equity : Competitive equity package in a well-funded AI startup with significant upside

What We Offer

• Comprehensive Health Benefits : Medical, dental, and vision coverage (100% employer-paid for employees)
• Flexible PTO & Paid Holidays : Unlimited PTO with encouragement to actually use it
• Remote-First Policy : Work from anywhere in the US (with occasional team offsites)
• Learning & Growth : Annual learning stipend, access to top conferences, and direct mentorship from experienced founders
• Equity Ownership : Competitive equity package with clear growth potential as we scale
• Modern Tech Stack & Tools : Budget for the best equipment and software
• Strong Culture : High-trust, low-ego environment focused on impact, transparency, and work-life balance. We believe great work happens when people are supported, challenged, and given ownership.

Equal Opportunity Employer

Troveo is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.