Rockefeller Philanthropy Advisors is hiring a Lead Data Engineer (Remote - North America)

Rockefeller Philanthropy Advisors is hiring a Lead Data Engineer to shape the foundation of a modern data platform for real-time energy intelligence. In this remote role, you will architect high-performance data pipelines and infrastructure to support analytics, IoT integration, and machine learning in a collaborative environment.

What You'll Do

• Design and own schema modeling for energy metering and building management data.
• Architect and maintain cost-effective, high-throughput data storage solutions (e.g., ClickHouse, StarTree).
• Build, optimize, and manage scalable ETL/ELT pipelines for ingesting and transforming sensor data.
• Lead the evaluation and integration of modern tools in a scalable data stack.
• Implement and uphold data quality, governance, and validation frameworks.
• Support real-time analytics, streaming pipelines, and BI tooling across domains.
• Collaborate with AI/ML, web, and application teams to meet real-time and batch data access needs.
• Contribute to building internal data tools and infrastructure to support engineering and analysis.
• Manage projects, mentor junior engineers, and coordinate with technical leads.

What We're Looking For

• Based in North America with availability during core working hours (10:00AM–5:00PM PST).
• 5+ years of experience in data engineering at scale with large-volume, high-frequency datasets.
• Expertise in dimensional modeling, OLAP schema design, and columnar data stores (e.g., ClickHouse, Druid).
• Strong SQL skills and experience with Python for pipeline development and data manipulation.
• Familiarity with event-driven systems, stream processing tools (Kafka, Flink, Spark Streaming), and real-time analytics.
• Experience with ETL orchestration tools (e.g., Dagster, Airflow), AWS cloud services, and PostgreSQL.
• Proven leadership, team mentorship, and a strong track record of collaborative delivery.

Nice to Have

• Knowledge of time-series data practices, especially within IoT or energy-related domains.
• Experience in BMS/HVAC data systems, data observability, cataloging, and MLOps.

Technical Stack

• ClickHouse, StarTree, Druid
• SQL, Python
• Kafka, Flink, Spark Streaming
• Dagster, Airflow
• AWS, PostgreSQL

Team & Environment

You will collaborate closely with AI/ML, web, and application teams in a collaborative, cross-functional environment.

Benefits & Compensation

• Competitive compensation based on experience and location.
• Fully remote role with flexible working hours.
• Opportunity to drive meaningful impact on climate-focused technology.
• Work alongside a team that values curiosity, candid communication, and continuous learning.
• Supportive environment with a strong emphasis on growth and shared success.
• Inclusive and diverse culture where different perspectives are welcomed and respected.

Work Mode

This is a fully remote position for candidates based in North America.

Rockefeller Philanthropy Advisors is an equal opportunity employer committed to an inclusive and diverse culture.