Analytics Engineer

Gridmatic Inc•Cupertino, CA

18h•$175,000 - $208,000

About The Position

We’re looking for someone passionate about energy & electricity markets with deep expertise in analytics reporting & SQL frameworks who can help develop our analytics platform. As a power company driven by ML and data, your scope would include automating gross margin, domain modeling, and revenue reporting, which help us measure real-time financial health and risk across all lines of our business. You would also deeply embed with Gridmatic teams to build fundamental data products that help model Gridmatic’s business domains for real-time analytics.

Requirements

3+ years of experience in analytics engineering or similar roles.
Strong technical skills in SQL, dbt, and data warehouses (e.g. BigQuery, Snowflake).
Highly effective at talking to stakeholders to solve complex business problems and to understand messy domain-specific data sources.
Enough software engineering skills to be dangerous.
Energy experience is not strictly required, but a successful engineer in this role will be proactive in learning and understanding the specifics of energy domain data and financial concepts, with minimal hand-holding from business domain experts.

Nice To Haves

Python experience isn’t strictly necessary but is a big plus.
Worked on financial analytics or PnL data. Not a requirement, but would be a big plus.

Responsibilities

Build an end of month accounting pipeline in dbt for our retail electricity business
Translate raw, complex external data (e.g. billing and settlement reports) into clear and cohesive internal data products
Create a dashboard to track financial exposure across asset lines (e.g. commodity trading, retail electricity contracts, energy storage assets)
Convert existing python notebooks and excel workbooks into dbt pipelines