Service Operations Specialist

Jobtailor; Durham (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor in Durham, NC seeks a data-driven finance and operations analyst to own financial analysis, inventory modeling, and profitability insights for manufacturing services.

You will combine SQL (Databricks), Python, and Excel to automate workflows, build dashboards, and turn telemetry and ERP data into actionable business decisions.

Qualifications

• 3–5+ years of experience in business, operations, or financial analysis in manufacturing or supply chain.
• Deep Epicor Kinetic expertise: purchasing, inventory, and part masters; BAQ development.
• Strong technical stack: SQL, Python, Excel Macros/VBA, Power Automate or workflow tooling.
• Financial and supply chain acumen: revenue recognition, cost drivers, inventory modeling, min/max safety stock.
• Builder mindset: self-directed, commercially minded, 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, integrating Jira and Epicor data for a unified view.
• Balance Supply & Demand: Build inventory burn-rate models, manage Epicor Kinetic PO workflows, 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

BAQ Development

Tools

Databricks

Epicor

Jira

Power Automate

Excel Macros

Job description

• Own Service Financials & Profitability: Reconcile revenue, analyze P&L leakage, model warranty/goodwill exposure, and present Gross Profit/EBIT findings directly to leadership.


• Turn Telemetry into Action: Query Databricks SQL to analyze charger uptime and utilization, combining telemetry with Jira and Epicor data for a unified view of the business.


• Balance Supply & Demand: Build inventory burn-rate models, manage Epicor Kinetic PO workflows, and set safety stock levels to prevent stockouts without tying up cash.


• Automate & Modernize: Eliminate manual multi-system processes using Power Automate, Python, and SQL, phasing out legacy Excel macros in favor of scalable, AI-ready workflows.

Requirements

• 3–5+ Years of Experience: Background in business, operations, or financial analysis within manufacturing, supply chain, hardware, or industrial service environments (physical product exposure is required).


• Deep Epicor Kinetic Expertise: Daily hands-on experience managing purchasing, inventory, and part masters, plus proven capability building BAQs and dashboards.


• Strong Technical & Analytics Stack: Proficient in SQL (Databricks/Spark SQL preferred), Python (pandas/PySpark), Advanced Excel (Macros/VBA), and Power Automate or workflow tooling.


• Financial & Supply Chain Acumen: Solid understanding of revenue recognition, cost drivers, inventory modeling, and min/max safety stock planning.


• Builder Mindset: Self-directed, commercially minded, and naturally inclined to automate manual work out of existence.

Core Competencies

Demonstrates expertise in financial analysis, inventory management, and automation within manufacturing and supply chain environments, leveraging tools like SQL and Python to drive profitability and operational efficiency.

Highest-signal resume keywords

• Epicor Kinetic Expertise


• SQL Proficiency


• Python Programming


• Financial Analysis


• Supply Chain Management

ATS Optimization Keywords

Hard Skills

• Financial Analysis


• Inventory Modeling


• SQL


• Python


• Advanced Excel


• Power Automate


• BAQ Development


• Data Analysis


• P&L Analysis


• Telemetry Analysis

Soft Skills

• Self-Directed


• Commercially Minded


• Problem Solving

Industry Keywords

• Manufacturing


• Supply Chain


• Industrial Service


• Revenue Recognition


• Cost Drivers

Tools & Technologies

• Databricks


• Epicor


• Jira


• Power Automate


• Excel Macros