Energy Analytics Engineer: Real-Time PnL & Dashboards

Gridmatic Inc; Cupertino (CA); On-site; USD 175,000 - 208,000; Full time

Benefits offered by this job

Education opportunities

Flexible PTO

Medical/Dental/Vision

Donation matching

Home office stipend

Job summary

Gridmatic Inc. in Cupertino seeks an analytics engineer to build and scale our analytics platform, automating gross margin, domain modeling, and revenue reporting with a strong SQL/dbt foundation.

You will translate data into durable data products, create dashboards for financial exposure across asset lines, and convert notebooks and Excel work into robust dbt pipelines. 3+ years in analytics engineering and experience with BigQuery or Snowflake preferred.

Qualifications

• 3+ years of experience in analytics engineering or similar roles.
• Strong SQL, dbt, and data warehouse skills.
• Ability to translate complex data for business stakeholders.
• Experience with financial analytics or PnL data is a plus.

Responsibilities

• Build an end of month accounting pipeline in dbt for our retail electricity business.
• Translate raw, complex external data into clear internal data products.
• Create dashboards to track financial exposure across asset lines.
• Convert existing notebooks and Excel workbooks into dbt pipelines.

Skills

Analytics engineering

SQL

dbt

Stakeholder communication

Financial analytics

Tools

BigQuery

Snowflake

Python

Job description

Gridmatic Inc. in Cupertino seeks an analytics engineer to build and scale our analytics platform, automating gross margin, domain modeling, and revenue reporting with a strong SQL/dbt foundation.

You will translate data into durable data products, create dashboards for financial exposure across asset lines, and convert notebooks and Excel work into robust dbt pipelines. 3+ years in analytics engineering and experience with BigQuery or Snowflake preferred.