Senior Data Analyst
Posted Updated 6
views
Summary
Senior Data Analyst automates billing, call-center dialer files, and audits for a retail energy provider using SQL, ETL, and monitoring tools like Grafana.
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
- 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
- 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
- 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.
• 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.
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
Skills
As published by greenhouse · 8 questions · 2 written answers
Basics
First Name, Last Name, Email, Phone, Resume/CV, Location
Short answers (3)
- Preferred First Name optional
- LinkedIn Profile optional
- Website optional
Pick from a list (3)
- This role requires candidates to be in our Houston offices 50% of the time. Are you able to meet that requirement?
- Are you currently eligible to work in the USA?
- Will you now, or in the future, require sponsorship (i.e. H-1B visa, etc.) to legally work in the U.S.? (Please note: we are unable to sponsor new H-1B visas at this time.)
Written answers (2)
- What level of proficiency do you have with excel?
- What experience do you have in US electricity markets?