
AMS Data Analyst
Required skills
- SQL
- Power BI
- Tableau
- Microsoft Excel
- SAP
- SMQS
- SharePoint
- Microsoft Office
- analytical experience
Nice to have
- ERP systems
- budgeting
- strategic planning
- Lean
- continuous improvement
Role summary
The Aftermarket Solutions (AMS) Data Analyst collects, analyzes, and transforms operational, financial, and customer data into actionable business intelligence. This role supports Aftermarket leadership by identifying trends, measuring performance, improving processes, and developing reports to enhance customer service, project execution, and revenue growth. Key responsibilities include developing and maintaining dashboards and reports, conducting operational and financial analysis, analyzing customer behavior, and managing departmental systems like SMQS and SharePoint to ensure data accuracy and accessibility. The analyst will also support forecasting, budgeting, and continuous improvement initiatives.
- Business Intelligence & Reporting
- Develop and maintain dashboards, KPIs, and executive reports for the Aftermarket organization.
- Automate recurring reports and present findings to leadership.
- Operational Analytics
- Analyze proposal activity, project execution, revenue, gross margin, backlog, win/loss rates, resource utilization, and customer response times.
- Analyze project execution data to identify bottlenecks and improvement opportunities.
- Measure proposal turnaround times and quote conversion.
- Support workload, staffing, and forecasting.
- Financial Analysis
- Monitor revenue, gross margin, backlog, and financial performance.
- Develop forecasting models and ROI analyses.
- Support budgeting and strategic planning.
- Customer Analytics
- Analyze customer purchasing behavior and aftermarket service trends.
- Measure customer retention and identify growth opportunities.
- Systems Administration & Data Management
- Maintain and administer departmental operating systems, including SMQS and SharePoint, ensuring information is accurate, current, and accessible.
- Develop and maintain standardized data structures, libraries, dashboards, and reporting tools.
- Ensure data accuracy and consistency across SMQS, SharePoint, and other business systems.
- Coordinate system updates, workflow improvements, and user enhancements.
- Manage departmental documentation, reporting repositories, templates, and standardized processes within SharePoint.
- Support implementation of new technologies, reporting tools, and automation initiatives.
- Continuous Improvement
- Partner with leadership to identify improvement opportunities through data analysis.
- Recommend process changes supported by measurable results.
- Participate in Lean and continuous improvement initiatives.
- 3–5 years of analytical experience.
- Advanced Microsoft Excel skills.
- Experience with Power BI or Tableau.
- Strong SQL knowledge.
- Experience with ERP systems (SAP preferred).
- Strong analytical, problem-solving, communication, and presentation skills.
- Strong interpersonal skills and ability work within multiple disciplines in MM and MT.
- Proficient in Microsoft Office products (Word, Excel, PowerPoint etc)
Similar roles
Field Service Engineer 1Makino, Inc · Austin, TX · Onsite
Application Engineer - Aero StructureMakino, Inc · Mason, OH · Onsite- Administrative Program Specialist: Academic Programs Data Analyst and Class SchedulerOSU Rec Sports - Sport. Leadership. Wellness. · Corvallis, OR · Onsite
- Senior Data Analyst, Client ReportingHello Heart · United States · Hybrid
- Lead Data AnalystHubSpot · Remote · Remote
- Data Analyst InternRevNet · Remote · Remote
