Analytics Engineer

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

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.

What you might do:

• 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

You might be a good fit if you:

• Have had 3+ years of experience in analytics engineering or similar roles.
• Have strong technical skills in SQL, dbt, and data warehouses (e.g. BigQuery, Snowflake).
• Are highly effective at talking to stakeholders to solve complex business problems and to understand messy domain‑specific data sources.
• Have enough software engineering skills to be dangerous. Python experience isn’t strictly necessary but is a big plus.
• Have worked on financial analytics or PnL data. Not a requirement, but would be a big plus.
• 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.

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

$175,000 - $208,000 USD