Service Data Analyst: P&L, Telemetry & Automation Lead

Kempower; Durham (NC); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Day-1 medical, dental, and vision

401(k) match

Annual bonuses

Free onsite EV charging

Job summary

Kempower is seeking a Service Data Analyst in Durham, NC to act as the commercial and analytical engine for field service, supply chain, and telemetry data. You will own the service P&L truth, automate fragmented workflows across Epicor Kinetic and Databricks, and build demand-supply models for the EV charging network.

You will reconcile revenue, analyze profitability, and present findings to leadership, while turning telemetry into actionable insights.

Qualifications

• 3–5+ years of experience in business, operations, or financial analysis within manufacturing, supply chain, hardware, or industrial service environments.
• Deep Epicor Kinetic expertise, including purchasing, inventory, and part masters, with BAQ and dashboards.
• Proficiency in SQL, Python, Excel macros/VBA, and Power Automate for automation and analytics.
• Knowledge of revenue recognition, cost drivers, inventory modeling, and min/max safety stock planning.
• Builder mindset: self-directed, commercially minded, and focused on automating manual work.

Responsibilities

• Own Service Financials & profitability: reconcile revenue, analyze P&L leakage, model warranty/goodwill exposure, and present Gross Profit/EBIT findings to leadership.
• Turn Telemetry into Action: query Databricks SQL to analyze charger uptime and utilization, combining telemetry with Jira and Epicor data.
• Balance Supply & Demand: build inventory burn-rate models, manage Epicor Kinetic PO workflows, and set safety stock levels to prevent stockouts.
• Automate & Modernize: eliminate manual multi-system processes using Power Automate, Python, and SQL, phasing out legacy Excel macros.

Skills

SQL (Databricks / Spark SQL)

Python (pandas / PySpark)

Advanced Excel (Macros / VBA)

Power Automate / workflow tooling

Data analysis & BI visualization

Tools

Epicor Kinetic

Databricks

Jira

Power Automate

Excel Macros / VBA

Job description

Kempower is seeking a Service Data Analyst in Durham, NC to act as the commercial and analytical engine for field service, supply chain, and telemetry data. You will own the service P&L truth, automate fragmented workflows across Epicor Kinetic and Databricks, and build demand-supply models for the EV charging network.

You will reconcile revenue, analyze profitability, and present findings to leadership, while turning telemetry into actionable insights.