Data Analyst
Southtowne Plumbing, Heating, And Cooling, LLC
Dayton, United States of America
3 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Intermediate Compensation
$ 63KJob location
Dayton, United States of America
Tech stack
Microsoft Excel
Spreadsheets
Databases
Data Structures
Pivot Tables
Job description
- Build and maintain the customer equipment database - install dates, equipment age, make/model and serial numbers, warranty status, and last service date for every customer
- Track manufacturer recalls and safety notices - flag affected customers and generate outreach lists so the team can get ahead of problems instead of reacting to them
- Design and maintain the tools we run on - a well-structured spreadsheet system or a simple app - and keep the data clean, current, and trustworthy
- Own company KPIs - revenue, job counts, average ticket, maintenance-plan/membership numbers, technician productivity, callback rates, and whatever else drives the business
- Turn numbers into decisions - build clear dashboards and reports that owners and managers can actually act on
- Spot trends and surface opportunities - customers due for replacement, aging equipment, service gaps, and seasonal patterns
Requirements
You're genuinely obsessed with numbers and data. A messy spreadsheet bothers you. You love finding the pattern nobody else noticed, and you take real pride in data that's clean and can be trusted.
Required:
- 2+ years in a data analyst, reporting, or operations analyst role
- Advanced spreadsheet skills (Excel or Google Sheets) - formulas, pivot tables, clean data structure
- Experience building reports and dashboards that non-technical people can actually use
- Sharp attention to detail and a habit of double-checking your own work
- A clear communicator who can explain what the numbers mean in plain English
- Comfortable working on-site alongside our office and field teams
Pay: $52,235.01 - $62,906.68 per year
Benefits & conditions
Pulled from the full job description
- 401(k), * 401(k)