Senior Data Analyst

Gridmatic Inc; Houston (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Continuing Education Opportunities

Flexible PTO

Medical, Dental and Vision plans with…

Pre-Tax commuter benefits

Home Office Stipend

401K match

Parental leave

Life Insurance

Stock Option Loan Program

Job summary

Gridmatic Inc. is seeking a hybrid operations and automation-focused professional to revamp manual processes for a growing retail energy provider.

The role emphasizes automating dialer outputs, audits, and bill validation, while enabling data pipelines and alerting through Grafana and Slack integrations. You will translate business needs into technical specs, partner with engineers, and contribute to data architecture as the company scales.

Qualifications

• 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 (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.

Responsibilities

• Automate dialer file production and delivery for outbound campaigns.
• Build audits and exception reporting for key processes with live alerts via Slack and Grafana.
• Automate bill validation to catch errors before they reach customers.
• Automate pulling and processing market transactions for operations (enrollments, rejects, drops).
• Archive EDI files from our billing vendor's SFTP before they age off after 6 months.

Skills

SQL

ETL automation

Scripting

Workflow automation

Requirements translation

Observability

Tools

Grafana

Slack integrations

Job description

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