Data Engineer

Data Engineer Remote / Hybrid (Portland, OR HQ) Competitive Salary plus Equity Full-time About the Role Prophetic's platform processes billions of data points across all 50 states — parcel ownership records, zoning data, development activity, and geospatial layers that power every product we ship. As we scale to serve the nation's largest homebuilders, the complexity and volume of our data infrastructure is growing exponentially. We're looking for a Data Engineer to work alongside our senior engineering team on the data-intensive backbone of the platform. This is a hybrid role — roughly 70% database and data pipeline work, 30% application-level development. You'll spend most of your time in complex SQL, building and maintaining ETL pipelines, debugging data quality issues, and ensuring the accuracy of ownership records, development triggers, and parcel-level analytics. You'll work directly with our senior engineers on products like DevMap, where data pipeline accuracy directly impacts whether customers catch development opportunities. When something doesn't trigger correctly or ownership data is wrong, you'll be the one digging into the data to figure out why and fix it. This role requires someone comfortable navigating county assessor websites, understanding real estate data structures, and working with large-scale datasets (2+ billion rows). If you're a data-first engineer who thrives on problem-solving across messy, real-world datasets and wants to have outsized impact at a fast-growing startup, this is the role. What You'll Do Build, maintain, and optimize data pipelines that process parcel ownership, zoning, and development activity data across all 50 states. Write and optimize complex SQL queries against datasets with 2+ billion rows in PostgreSQL and Databricks. Debug and resolve data quality issues — ownership discrepancies, missing triggers, pipeline failures — across production systems. Navigate county assessor websites, state GIS portals, and public records to validate and source ownership and parcel data. Support DevMap and other platform products by ensuring data pipeline accuracy and reliability. Collaborate with senior engineers on backend logic, data validation, and application-level features as needed. Build monitoring and alerting systems for data freshness, pipeline health, and quality metrics. Work with Databricks for large-scale data processing, transformation, and analytics workloads. Document data schemas, pipeline architectures, and troubleshooting procedures. Use AI tooling daily to accelerate development, debugging, and data analysis workflows. What You Need 3+ years of experience in data engineering, database development, or a data-heavy software engineering role. Strong proficiency in SQL — complex joins, window functions, query optimization, and working with very large datasets. Experience with PostgreSQL and familiarity with PostGIS or geospatial data concepts. Experience building and maintaining ETL/ELT pipelines in production environments. Comfort with Python for scripting, data processing, and pipeline automation. Problem‑solving mindset — you enjoy digging into data discrepancies and figuring out root causes. Comfort navigating messy, real‑world data from government and public sources. Self‑starter who can manage competing priorities and context‑switch across multiple workstreams. Comfort with AI development tooling as part of your daily workflow. Nice to Have Experience with Databricks, Spark, or similar large‑scale data processing platforms. Familiarity with real estate data — parcel records, ownership chains, county assessor systems, or title data. Experience with geospatial data (PostGIS, shapefiles, GeoJSON). Background working at a startup where you wore multiple hats and adapted to shifting priorities. Experience with data quality frameworks, monitoring, and observability. Benefits (US‑based Full‑time Employees) 100% medical, dental & vision insurance coverage for you; 30% coverage for dependents Competitive salary and meaningful early‑stage equity Unlimited PTO Remote / hybrid Office equipment stipend In‑office perks: snacks, drinks, coffee, ping‑pong table, and more — plus cuddles from Olive, our in‑office Doberman Budget for intra‑office travel 2–3 annual team meetups in person Prophetic is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. #J-18808-Ljbffr