Senior Python Data Analyst Jobs in Worcester, MA

Description

Methods Machine Tools, established in 1958, is one of the largest privately held machine tool importers in North America. The company designs and implements custom machining solutions, including machine tool selection, automation integration, and turnkey automation cells. With over 300 employees, seven technology centers, and more than 45,000 machines installed across North America, Methods is committed to delivering cutting-edge manufacturing solutions from its corporate campus in Sudbury, Massachusetts.

Job Summary: 

The Data Analyst serves as a key analytical resource within the office of the COO, responsible for transforming complex data into strategic insights that drive business performance. This role leads the design, development, and maintenance of enterprise reporting, dashboards, and data models across sales, aftermarket services, and SIOP (Sales, Inventory & Operations Planning) functions. The Senior Data Analyst partners with cross-functional leadership to deliver data-driven recommendations that support revenue growth, operational efficiency, and continuous improvement initiatives.

Key Responsibilities:

• Lead the collection, integration, and analysis of data from CRM, ERP, and other enterprise systems to support sales performance, aftermarket services, and SIOP planning cycles.
• Design and maintain advanced dashboards and reports that track KPIs across new equipment sales, aftermarket parts and service revenue, and demand forecasting accuracy.
• Serve as the primary analytics partner for SIOP processes, providing demand/supply data analysis, forecast variance reporting, and scenario modeling to support executive decision-making.
• Develop and standardize aftermarket analytics, including service contract utilization, parts consumption trends, and customer lifecycle metrics.
• Perform complex statistical analyses to identify trends, patterns, and opportunities for revenue optimization and operational improvement.
• Ensure data integrity, governance, and consistency across all reporting platforms through rigorous validation, quality assurance, and documentation practices.
• Collaborate with Sales, Operations, Finance, and Aftermarket leadership to translate business requirements into scalable, automated reporting solutions.
• Lead ad hoc analytical projects and present findings and recommendations to senior management and executive stakeholders.

Required Qualifications & Skills:

• Education: Bachelor's degree in Data Analytics, Statistics, Computer Science, Business Administration, or a related discipline (or equivalent combination of education and experience).
• Experience: 3-7 years of progressive experience in data analysis, business intelligence, or analytics, preferably within a manufacturing, distribution, or industrial sales environment.

Technical Skills:

• Advanced proficiency in Excel, Power BI, Tableau, or equivalent data visualization platforms.
• Strong working knowledge of SQL for complex data extraction, transformation, and manipulation.
• Experience with Python, R, or similar analytical programming languages.
• Familiarity with ERP/CRM systems (e.g., Infor CSI, Salesforce, ServiceNow, SAP, or similar) and SIOP/S&OP planning tools.

Soft Skills:

• Demonstrated ability to synthesize complex data into clear, actionable insights for both technical and non-technical audiences.
• Strong critical thinking, problem-solving, and strategic analysis capabilities.
• Excellent organizational skills with the ability to manage multiple priorities in a fast-paced environment.
• Proven track record of cross-functional collaboration and stakeholder management.

Supervisory Responsibilities:

• None (mentorship of junior analysts expected).

Travel Requirements: 

• Minimal; occasional travel to regional facilities may be required.

Physical Requirements: 

• Prolonged periods of sitting at a desk and working on a computer.
• Must be able to lift up to 20 pounds at times. 

Additional Information

This job description is designed to provide an overview of basic skills, experiences and education required to perform the job and is not designed to cover or contain a comprehensive listing of all activities, duties, or responsibilities required of the employee to perform the essential functions of the job. In instances where educational degrees are required, the company will take into consideration factors such as additional experience, training, or certifications in lieu of specific educational requirements.

Methods Machine is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.