Data Engineer, Revenue and Energy Supply

Gridmatic Inc; San Francisco, Cupertino (CA, CA); Hybrid; USD 140,000 - 210,000; Full time

Benefits offered by this job

Continuing Education Opportunities

Flexible PTO

Medical, Dental and Vision plans

$1500/year non profit donation match

Home Office Stipend

401K contribution match

Stock Option Loan Program

Job summary

Gridmatic Inc is seeking a startup-minded data engineer to build the data platform needed to answer core questions around profit and loss and how to optimize renewable supply. You will wear many hats and collaborate with multiple teams to implement robust data ingestion and transformation.

You’ll work with Python and SQL in production, design scalable data stores, and use DBT and orchestration tools like Flyte, Airflow, Prefect, or Dagster to deliver reliable analytics for trading, storage, and

Qualifications

• Strong production Python and SQL skills.
• Store and query data efficiently in relational databases and data warehouses.
• Production DBT skills and clean data architecture.

Responsibilities

• Build a unified set of financial data across trading, battery storage, and energy sales for real-time revenue and PnL insights.
• Develop tooling and infra to grow renewable supply, including simulations of additional renewable resources.
• Own data ingest and transformation, build pipelines in Flyte and Python, or models in DBT.

Skills

Python

SQL

Data warehousing

Tools

Flyte

Airflow

Prefect

Dagster

DBT

Job description

Gridmatic’s business is complex, and we need to build a robust data layer to be able to answer core questions around profit and loss and how to best optimize our renewable supply.

We’re looking for a startup-minded data engineer who can wear a lot of hats, work with multiple teams, and build the data platform needed to support answering these questions.

What you might work on:

• Revenue analytics. Building a unified set of financial data across trading, battery storage, and energy sales, allowing us to have a clear real-time view of revenue and PnL - an essential part of being an energy supplier.
• Energy supply analytics. Building tooling and infra so we can grow our renewable supply, e.g. tooling to easily simulate additional hypothetical renewable resources.
• Ownership of data ingest and transformation. For both revenue and supply, owning the data platform and building new ingest pipelines in Flyte and Python, or new models in DBT.

You might be a good fit if you:

• Are interested in diving into the domain of energy and financial data (not just data infrastructure) and grappling with complex business logic and messy data
• Have strong production Python and SQL skills
• Have a strong understanding of how to store and query data efficiently in relational databases and data warehouses
• Have production DBT skills, and are adept at clean data architecture
• Have used data orchestration tools like Flyte, Airflow, Prefect, or Dagster

This role requires candidates to adhere to our hybrid policy, 3 days a week in office with at least 1 day in our Cupertino office.

Taking care of you today:

• Continuing Education Opportunities
• Flexible PTO
• Medical, Dental and Vision plans with competitive employer contributions
• $1500/year non profit donation matching program through Millie
• Home Office Stipend

Protecting your future for you and your family:

• 401K contribution match up to 4%
• Company-paid parental leave
• Company Paid Life Insurance
• Stock Option Loan Program

Pay range: