> Markdown version of [/jobs/ext/1453139-founding-sr-data-engineer](https://www.wearedevelopers.com/jobs/ext/1453139-founding-sr-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Founding Sr. Data Engineer - **Company:** Diligent Robotics - **Location:** Austin, TX, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Business Logic, BigQuery, Software as a Service, Information Engineering, Data Warehousing, Dimensional Modeling, Identity and Access Management, Operational Data Store, Operational Databases, SQL Databases, Data Ingestion, Snowflake, Data Management - **Published:** July 26, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=7045b243ff78e8b2 ## About the Role * 5+ years of hands-on data engineering experience, including significant work in a modern data stack (cloud warehouse + dbt + version-controlled transformations). * Deep, hands-on experience with BigQuery (or another columnar cloud warehouse - Snowflake, Redshift - with willingness to ramp on BigQuery quickly). * Deep, hands-on experience with dbt, including project structure, testing, and modeling patterns. You can debate the tradeoffs of staging vs. intermediate vs. marts layering and have opinions about when to use incremental models. * Strong dimensional modeling fundamentals (Kimball or equivalent). You understand conformed dimensions, slowly changing dimensions, and grain. * Strong SQL. Comfortable reviewing and refactoring complex SQL written by analysts. * Experience designing ingestion pipelines from multiple source types - operational databases, SaaS APIs, log-based sources. * Excellent technical communication. You can explain tradeoffs and modeling decisions to analysts, engineers, and executives. * Comfortable being the first dedicated data engineer in an organization - setting standards, making decisions without a peer to defer to, partnering with non-data folks., * Experience with Firestore and the native Firestore-to-BigQuery integration, particularly at scale (multi-project setups). * Experience with Airbyte (self-hosted or cloud) or comparable managed ingestion tools (Fivetran, Stitch). * Experience working with Elastic as a data source - extracting metrics or operational data out of Elastic indexes into downstream systems. * Experience designing a metrics catalog or semantic layer (dbt Semantic Layer, MetricFlow, LookML, or similar). ## Description We're hiring our Founding Senior Data Engineer - the first dedicated data hire on a team that already has active analytics demand, working dashboards, and a clear plan for what comes next. You'll own the design and build of our BigQuery data warehouse, set the standards the rest of the data function will follow, and partner closely with our existing analyst team to build the analytics platform that will power the next stage of the business., * Stand up the warehouse. Design and implement our BigQuery environment from the ground up - project structure, IAM, dataset organization, naming conventions, cost controls - so it scales cleanly as we add sources and users. * Build the transformation layer. Set up dbt as the home for our transformation logic. Migrate the business logic from our existing analytics environment into version-controlled, tested dbt models. * Model master data. Introduce dimensional models for our core business entities so data from different sources can be joined consistently. * Own ingestion. Configure native Firestore-to-BigQuery integration, then stand up Airbyte as our managed connector layer for SaaS sources and log exports as we broaden the warehouse. * Partner across the org. Work with source-system owners, the analyst team, and engineering teams that will eventually consume curated data from the warehouse. Help define the boundary between what the warehouse is and is not for. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Best X (Twitter) Accounts for Developers](https://www.wearedevelopers.com/magazine/294-the-best-x-twitter-accounts-for-developers) - [Dev Digest 139 - Soft and hard queries](https://www.wearedevelopers.com/magazine/487-dev-digest-139-soft-and-hard-queries)