Parcell

Role Description Behind every state we launch is a mountain of data—parcels, school ratings, transit, flood zones, crime indicators, and dozens of state-specific layers—that has to be found, understood, and brought into our platform before scoring can happen. Much of it doesn't come with a clean download button. It lives in undocumented municipal portals, inconsistent county feeds, and sources where the only "API" is whatever an embedded map happens to call. We are looking for someone who finds that kind of source irresistible—part data detective, part engineer, part problem solver—who can track down hard-to-find data, get meaningful information out of it, and turn it into something our platform can rely on. You'll be the technical right hand to our implementation team: they know what each state's scoring needs, and you figure out how to get it and make it real. This role is ideal for someone who likes end-to-end ownership, technical problem solving, and visible impact. What You Will Do - Source Discovery & Data Acquisition (40%) - Track down the external data our scoring needs—including poorly documented, inconsistent, or hard-to-access sources—and confirm you can reliably get usable data out of them. - Reverse-engineer undocumented portals, APIs, and feeds to extract meaningful data. - Evaluate new and existing sources for coverage, quality, and fit against each state's requirements and scoring criteria. - Data Wrangling & Integration (30%) - Figure out how messy, real-world data has to be reshaped to be useful, and get it into our platform in a form scoring can trust. - Work with varied formats (shapefiles, GeoJSON, CSVs, county/state feeds) and reproject spatial data correctly across coordinate systems. - Load, structure, and index geospatial and tabular data in PostgreSQL/PostGIS using our internal tooling and scripts (Node.js, Bash, SQL). - Reproducibility & Maintenance (15%) - Make every data pull repeatable—a re-runnable path to refresh each source on its cadence, not a one-time extraction only you know how to repeat. - Monitor upstream sources for format or schema changes and update pulls before they break a launch. - Validation & QA (15%) - Validate spatial and tabular data beyond row counts—geometry validity, topology, and coverage gaps—to ensure accuracy before it reaches scoring. - Document where each dataset lives, how it was sourced, and how to refresh it. Qualifications - A track record of getting data out of difficult, poorly documented sources—you've reverse-engineered an undocumented endpoint, scraped a stubborn portal, or wrangled a malformed feed into something clean, and you find that kind of puzzle satisfying rather than frustrating. - Solid working proficiency with PostGIS—reprojecting between coordinate systems, validating and repairing geometry, spatial indexing, and spatial joins. You don't need to be a GIS specialist, but you're well past "I've used ST_Intersects." - Strong SQL skills (PostgreSQL) with the ability to write queries for analysis, validation, and troubleshooting. - Hands-on experience shipping and maintaining production code in a typed language (we use Node.js/TypeScript; strong experience in Go, Java, or Python transfers well). - A reproducibility instinct—you treat "I can re-run this cleanly next quarter" as part of the job, not an afterthought. - Excellent attention to detail and comfort working with messy data and edge cases. - Strong communicator able to collaborate with our implementation team, software engineers, and external data providers. - Passionate about affordable housing and real estate development is a plus. Benefits - Market-rate compensation aligned with experience and role expectations. - Comprehensive health coverage (medical, dental, and vision). - Equity ownership in Parcell, so you share in the company’s long-term success.

Role Description Launching a new state on Parcell is a high-ownership, high-impact technical challenge. Because each state has its own scoring system, rules, and data requirements, every launch is like solving a new puzzle. We are looking for someone who is part project manager, part technical implementer, part quality assurance, and part customer advocate. If you're strong with SQL, comfortable running scripts, enjoy digging into rule systems, and want to be the expert responsible for bringing new states live on our platform, you’ll thrive in this role. This role is ideal for someone who likes end-to-end ownership, technical problem solving, and visible impact—without needing to be a software engineer. What You Will Do - Project Management (15%) - Own state launch projects from kickoff to launch. - Build project plans based on each state’s QAP and guideline updates. - Identify and evaluate the right data sources based on the state’s requirements and scoring criteria. - Track timelines, dependencies, risks, and communicate status clearly to internal and external stakeholders. - Configuration & Technical Implementation (45%) - Translate state guidelines (QAPs) into system logic and configurations using our internal tooling. - Execute scripts and perform data operations using Node.js, Bash, and similar tools. - Collaborate with internal teams, policy experts, housing departments, and customers to resolve ambiguities or rule interpretations. - Provide structured feedback to improve configuration processes and internal tools. - Quality Assurance & Updates (20%) - Perform rigorous QA before each state launch to ensure accuracy. - Use SQL extensively to validate scoring logic, verify data integrity, and confirm rule compliance. - Maintain compliance as states update their rules and scoring. - Identify, document, and resolve issues during and after launch. - Support (20%) - Respond to customer questions related to scoring and state rules. - Proactively notify customers of scoring updates or changes in state guidance. Qualifications - Technical background with some hands-on scripting experience (Node.js, Bash, or similar). - Strong SQL skills with ability to write queries for analysis, validation, and troubleshooting. - Excellent attention to detail and comfort working with complex rules and edge cases. - Strong communicator able to collaborate with software engineers, internal teams, and customers. - Able to manage multiple projects simultaneously. - Experience in software development, business analysis, data analysis, or technical operations. - Passionate about affordable housing and real estate development is a plus. Benefits - Market-rate compensation aligned with experience and role expectations. - Comprehensive health coverage (medical, dental, and vision). - Equity ownership in Parcell, so you share in the company’s long-term success.