Data Engineer

Crux is the capital platform for the clean economy, modernizing capital raising and deployment for clean energy and critical infrastructure. Crux's Market Intelligence practice produces reports and proprietary data that move the market. The Data Engineer will sit on Crux's Data Team, embed with Market Intelligence, and build the foundational datasets and pipelines that research, publications, and client deliverables depend on. This is a build role with datasets that will serve as the substrate for intelligence products through 2027 and beyond.

Responsibilities

Own the Market Intelligence data foundation, building and maintaining pipelines for survey responses, pricing series, volume and capacity forecasts, and buyer participation (extraction, transformation, scheduling, monitoring); Automate survey processes end to end, including ingesting, cleaning, and joining data; Get data where it needs to be by supporting the reporting layer so findings are plugged into tools, dashboards, and publications; Turn recurring questions into repeatable queries and help productize bespoke research; Firm up data practices by validating inputs, documenting assumptions, applying version control, ensuring reproducible outputs, and driving additional use cases across teams

Requirements

3+ years of experience building and maintaining production data pipelines in high-growth, fast-paced environments; Fluent in Python and SQL, with the ability to write, test, and debug production code and complex queries; Proficient in cloud data warehousing, including schema design, incremental data loading, query optimization, and cost management; Experience with extraction, transformation, loading, scheduling, and monitoring; Knowledge of established data-quality practices, including input validation, automated testing, monitoring, documentation, version control, and reproducible outputs; Skilled at translating business or research needs into clearly scoped technical requirements, deliverables, and implementation plans; Demonstrated ability to communicate technical tradeoffs, project status, data limitations, and delivery risks to technical and nontechnical stakeholders; Hands-on experience with AI-enabled tools supporting software development, data analysis, testing, documentation, or workflow automation; Sound technical judgment when evaluating datasets and engineering approaches against downstream reporting, research, or product requirements

Nice to have

Experience working with energy, finance, transaction, or market intelligence data; Exposure to research, forecasting, survey analysis, or data-intensive publications; Hands-on involvement in developing or supporting analytical or statistical models; Knowledge of model testing and data-validation practices, including documenting assumptions and handling missing values and outliers; Familiarity with data visualization, business intelligence, or reporting tools

Benefits

Healthcare premiums 100% covered for employees (Aetna nationwide, Kaiser in WA and California), with 70% subsidy for dependents; Dental and vision premiums 100% covered for employees and 50% for dependents; 10 company holidays per year; 20 days paid time off per year; 401k account (no matching program at this time); Parental leave of 16 weeks for birthing parents and 12 weeks for non-birthing parents; Company-wide bonus tied to revenue goals; Stock options; Remote-first model with optional offices in DC and NYC and co-working options; Regular team offsites three times a year