Senior Data Analyst

Gridmatic Inc•Houston, TX

15d•Hybrid

About The Position

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. Key responsibilities include: - 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 - 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 Additional responsibilities include: - 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 products and customers. - Data modeling / architecture - System support: Support third party platforms and assist with any migrations. - Vendor evaluation / systems strategy 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.

Requirements

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.
Comfort with ambiguity and shifting priorities - we're a startup, and this role will help shape its own scope.

Nice To Haves

Experience in retail energy, billing systems, or another regulated/transactional industry is a plus.

Responsibilities

Automate producing and delivering call center dialer files 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 working market transactions (enrollments, rejects, drops).
Archive EDI files from our billing vendor's SFTP before they age off after 6 months.
Automate the manual Excel-based billing process for flexible-load customers.
Build pipelines against our commissions vendor's API for leadership forecast and exposure reports.
Automate manual loading of billing components into the system.
Automate month-end close processes for the accounting team.
Automate data pulls for compliance reporting.
Stand up operations and technical processes for each new market launch.
Build data/billing infrastructure for large or flexible-load customer products outside our standard system.
Translate operations needs into engineering requirements; help shape how our pricing/contracting system models products and customers.
Support third party platforms and assist with any migrations.