Sr Business Analyst – Retail Operations

Chariot Energy • Houston, TX

2d • Onsite

About The Position

Chariot Energy, an affiliate of Hanwha Energy USA and part of the Hanwha Group, is a retail energy provider based in Houston, Texas, aiming to become a leading energy retail provider within five years. We are seeking a highly skilled Sr Business Analyst to join our innovative and fast-paced organization. This role will serve as the key analytical partner supporting data-driven decision-making across Operations, Finance, Customer Care, and Risk Management. The focus is on transforming data from multiple enterprise systems into actionable insights to enhance billing accuracy, AR health, credit-risk monitoring, renewal retention, and fraud mitigation. The Sr Business Analyst will collaborate cross-functionally to design dashboards, generate insights, and identify opportunities for improving financial performance, operational efficiency, and customer experience. This position requires a deep understanding of the retail energy market, especially in deregulated environments, and expert-level knowledge of ERCOT & PJM regulations and advanced billing systems. Responsibilities include developing and executing strategies for billing accuracy and compliance, and identifying opportunities for process optimization and automation. This is an onsite role in Houston.

Requirements

• Bachelor’s degree in Business, Finance, Data Analytics, or Information Systems required.
• Minimum 5 – 7 years of analytics or business intelligence experience or financial operations in retail energy.
• Advanced proficiency in Power BI (data modeling, DAX, custom visuals, and drill-through design).
• Expert-level knowledge of SQL with proven ability to write complex, optimized queries across large data sets.
• Strong command of Excel for data analysis and ad-hoc reporting (pivot tables, lookups, advanced formulas).
• Demonstrated ability to develop and apply information-driven approaches to solve critical business questions in a practical manner with tangible results, while demonstrating flexibility to take consultative approach in ambiguous business environment.
• Demonstrated ability to translate data into insights that drive measurable improvements in billing accuracy, credit-risk control, customer retention, and fraud reduction.
• Experience in the deregulated energy market, primarily ERCOT, PJM, NYISO and NEPOOL.
• Excellent attention to detail with the ability to manage multiple priorities and deadlines in a fast-paced environment.
• Strong communication and presentation skills for both technical and non-technical audiences.
• Collaborative, solutions-oriented mindset with experience working across operations, finance, and IT functions.
• Strong analytical and problem-solving abilities to identify trends, analyze data, and make informed decisions.
• Ability to work effectively under pressure and meet deadlines.
• Eligible to work in the USA for any employer without sponsorship.

Nice To Haves

• Experience with Python for data transformation, automation, or anomaly detection preferred.
• Familiarity with Git or other version-control tools for managing code and BI assets preferred.

Responsibilities

• Build and maintain Power BI dashboards and reports for billing performance, receivables aging, customer renewals, churn trends, and operational KPIs.
• Extract and transform large data sets from Titanium, CRM, payment processors, and marketing systems using SQL and Python.
• Develop automated reporting pipelines for timely access to operational metrics.
• Design and monitor key metrics including billing accuracy, AR delinquency, DSO, collection recovery rates, deposit trends, credit exposure, charge-off risk, customer retention, renewal conversion rates, and fraud detection.
• Stand up parallel-run variance reporting for billing and settlements, with alerting on materiality thresholds.
• Create data reconciliation packs with before/after snapshots and tie-outs.
• Partner with Customer Care, Credit/Collections, Billing, Finance, and Sales teams to identify performance gaps and improvement opportunities.
• Provide actionable insights to reduce bad debt, unstatemented charges, and billing disputes, and to improve collection efficiency.
• Analyze renewal, churn, and customer lifecycle data to inform retention strategy and campaign targeting.
• Evaluate fraud trends across enrollments, payments, and account activities, identifying data-driven prevention mechanisms.
• Support leadership with forecasting, budget variance, and revenue/margin analysis.
• Establish and enforce data integrity and consistency standards for reports and integrations.
• Collaborate with IT and ESG teams to enhance Titanium’s data extract processes and ensure accurate mapping.
• Document data models, transformation logic, and KPI definitions.
• Implement automated ETL processes in Python or SQL.
• Work closely with internal leaders to define KPIs, prioritize reporting enhancements, and support key business initiatives.
• Present findings and dashboards to senior leadership.
• Support regulatory and compliance reporting.
• Adhere to Retail Market Guide protocols as set forth by ERCOT, PJM, NYISO and NEPOOL.
• Establish and maintain positive business relationships with internal customers and key stakeholders.
• Achieve excellence by delivering on key performance indicators (KPI’s).

Benefits

• Equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior