Sr Business Analyst - Retail Operations

Responsibilities

• Data Analytics & Visualization
• Build and maintain Power BI dashboards and reports that provide clear visibility into 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 to ensure leadership has timely access to accurate operational metrics.
• Design and monitor key metrics such as:
• Billing accuracy & cycle completion rates
• AR delinquency buckets, DSO, and collection recovery rates
• Deposit trends, credit exposure, and charge-off risk
• Customer retention and renewal of conversion rates
• Fraud detection and abnormal enrollment or payment activity
• Stand up parallel-run variance reporting (pre- and post-cutover) for billing and settlements: usage to bill, rate application, taxes/fees, securitization, deposits, AR aging, payment posting, write-offs, refunds, and adjustments- with alerting on materiality thresholds.
• Create data reconciliation packs: customer/account counts, premise/service IDs, contract terms, pricing products, deposit balances, payments/tokens, credit limits, and collections status-before/after snapshots with tie-outs.
• Operational & Business Insights
• Partner with Customer Care, Credit/Collections, Billing, Finance, and Sales teams to identify performance gaps and opportunities for improvement.
• 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 based on real-time Titanium data feeds.
• Data Governance & Automation
• 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 to reporting environments.
• Document data models, transformation logic, and KPI definitions to maintain transparency across departments.
• Implement automated ETL processes in Python or S

Benefits

Additional Information

COMPANY OVERVIEW Chariot Energy, is an affiliate company of Hanwha Energy USA and ultimately Hanwha Group, a FORTUNE Global 500 firm that is among the eight largest business enterprises in South Korea. Hanwha Energy USA designs, builds and manages solar power plant solutions. The company brings a decade of global leadership in solar PV to North America, combining best-of-world technology, processes, and partnerships to deliver utility-grade solar PV solutions customized for local energy markets. Hanwha Energy USA offers the full spectrum of PV solutions - from power plant development, design, construction, operations, and maintenance. With proven capabilities across the solar value chain, Hanwha Energy USA minimizes uncertainty and risk, and helps customers achieve a higher return on their investment in solar energy. Hanwha Energy USA has recently embarked to enter the energy retail market in deregulated markets throughout North America. Chariot Energy is a retail energy provider based in Houston, Texas. We offer electricity to homes and businesses, and it is our goal to provide products and services our customers love and an unmatched experience that is missing in today's retail energy market. Hanwha Energy USA has set out to have Chariot Energy become one of the leading energy retail providers (by RCE count) within 5-years of Chariot Energy's launch. POSITION OVERVIEW We are seeking a highly skilled Sr Business Analyst to join our innovative and fast-paced organization. The Sr Business Analyst will serve as the key analytical partner supporting data-driven decision-making across Operations, Finance, Customer Care and Risk Management. This role focuses on transforming data from multiple enterprise systems into actionable insights that enhance billing accuracy, AR health, credit-risk monitoring, renewal retention, and fraud mitigation. The Sr Business Analyst will work cross-functionally to design dashboards, generate insights, and identify opportunities that improve financial performance, operational efficiency, and customer experience. This position requires an individual with a deep understanding of the retail energy market, especially within deregulated environments, and an expert-level knowledge of ERCOT & PJM regulations and advanced billing systems. In this role, you will be responsible for developing and executing strategies that drive billing accuracy and compliance, to identifying opportunities for process optimization and automation. This position is an onsite role based in Houston, and the ideal candidate will be within commutable distance to the Chariot Energy Houston office.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at chariotenergy? Share your experience