Senior Data Analyst

The Role 

This is a hybrid operations and technical role centered on automation - taking the manual processes that keep a fast-growing retail energy provider running and rebuilding them so they run themselves. At most retail energy providers, legacy systems and process ownership are locked in, and there's limited room to change how things work. At Gridmatic, we're not looking to just do things better - we want to do them differently.

Must have - top priority

• Dialer file automation: Automate producing and delivering call center dialer files for outbound campaigns.
  • Automation / systems integration
• Audit & alerting: Build audits and exception reporting for key processes, with live alerts via Slack and Grafana.
  • Data quality / observability
• Bill run audit: Automate bill validation to catch errors before they reach customers.
  • Data validation / QA automation

Should have - important, less urgent

• Operations work queue: Automate pulling and working market transactions (enrollments, rejects, drops). Long-term: a queue-based tool for the ops team.
  • ETL / automation, light app development
• EDI archiving: Archive EDI files from our billing vendor's SFTP before they age off after 6 months.
  • Data pipeline / storage

Nice to have

• Complex billing automation: Automate the manual Excel-based billing process for flexible-load customers.
  • ETL / automation
• Commissions forecasting & exposure: Build pipelines against our commissions vendor's API for leadership forecast and exposure reports.
  • Data pipeline / reporting
• Billing component data load: Automate manual loading of billing components into the system.
  • ETL / automation
• Accounting close automation: Automate month-end close processes for the accounting team.
  • ETL / automation
• Compliance reporting automation: Automate data pulls for compliance reporting.
  • Data pipeline / automation

Beyond the project list

• New market entry: Stand up operations and technical processes for each new market launch.
  • Process design
• Product development: Build data/billing infrastructure for large or flexible-load customer products outside our standard system.
  • Systems integration
• Engineering liaison & data modeling: Translate operations needs into engineering requirements; help shape how our pricing/contracting system models productsand customers.
  • Data modeling / architecture
• System support: Support third party platforms and assist with any migrations.
  • Vendor evaluation / systems strategy

What we're looking for

• Strong SQL skills and experience building queries and reports against production data.
• Experience automating manual or error-prone business processes (ETL, scripting, workflow tooling).
• Comfort working with monitoring/alerting tools (e.g., Grafana, Slack integrations) or similar.
• Ability to translate business or operational requirements into technical specs and work with engineers to implement

them.

• Experience in retail energy, billing systems, or another regulated/transactional industry is a plus.
• Comfort with ambiguity and shifting priorities - we're a startup, and this role will help shape its own scope.

Why this role

You'll have direct, visible impact on the accuracy and scale of our operations, with the autonomy to identify problems and

build the solution end to end. As we grow, this role has room to grow with it, including deeper involvement in data

architecture and new market launches.

Taking care of you today:

- Continuing Education Opportunities

- Flexible PTO

- Medical, Dental and Vision plans with competitive employer contributions

- Pre-Tax commuter benefits

- $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