Data Analyst
Job Description
Join Kaman Corporation’s Operations Department to collect, integrate, and visualize business performance using modern analytics, automation, and interactive reporting.
- Use modern technologies including artificial intelligence (AI), automation, and advanced analytics to improve reporting, visualize trends, monitor business performance, and surface opportunities for improvement
- Collaborate cross-functionally with manufacturing engineering, quality assurance, and shop-floor teams to align data insights with Lean-Six Sigma and continuous improvement goals
- Build standardized data systems for gathering, understanding, and sharing data across the organization
- Extract and consolidate data from legacy business systems, databases, spreadsheets, and other information sources
- Create repeatable data processes for sorting, validating, transforming, and standardizing data to support accuracy and consistency
- Develop and maintain data models that connect information across business functions and systems, and make these accessible to company stakeholders
- Identify and address data quality issues, inconsistencies, and gaps
- Automate reporting workflows by developing automated data collection and processes to reduce manual reporting
- Design and maintain dashboards and reporting solutions that convert complex data into clear, actionable information
- Create KPI visualizations including key performance indicators, trends, and operational results
- Build drill-down reporting tools enabling users to move from executive-level summaries to transactional and operational detail
- Improve usability over time by continuously enhancing reporting effectiveness, usability, and accessibility
- Independently develop analytics tools and reports as business needs evolve
- Select and deploy reporting technologies that support better ways to gather and report data
- Partner with stakeholders to understand business problems and define solutions
- Document reporting systems including data sources, reporting logic, KPI definitions, and processes as data systems change
- Train business users to support effective dashboard and reporting tool usage
Requirements
- Education: BS or MS in Data Analytics, Data Science, Computer Science, Information Systems, Mathematics, or Statistics from an accredited institution
- Experience: 3-5 years minimum of data analytics experience
- Data integration: demonstrated experience integrating data from multiple systems and working with complex or inconsistent datasets
- Lean manufacturing knowledge: understanding of Lean manufacturing principles, 5S, Gemba, root-cause analysis, and statistical process control (SPC)
- Manufacturing interest: previous experience in a manufacturing environment highly desired; strong desire to work in an advanced manufacturing environment
- Communication: excellent written and oral communication skills
- Collaboration: ability to work in a self-directed, cross-functional team environment
- Attention to detail: strong organizational skills and detailed-orientated work style
- Statistical analysis: working knowledge of statistical analysis; previous experience using SAS, Minitab, JMP, MS Excel, M-Code, or Six-Sigma
- Microsoft 365: working knowledge including Power Automate and Power Apps
- BI/reporting tools: experience using Power BI or others that demonstrated applications of value-add
- Programming: experience using SQL and Python
- Analytical skills: strong analytical and problem-solving abilities
Technologies
- Artificial intelligence (AI)
- Power Automate
- Power Apps
- Power BI
- SQL
- Python
- SAS
- Minitab
- JMP
- MS Excel
- M-Code
- Microsoft 365
- Lean-Six Sigma
Benefits
- Medical, Dental, and Vision Insurance
- 401k with employer matching contribution
- Generous Paid Time Off
Preferred Qualifications
- Experience working with legacy ERP, manufacturing, quality, financial, or operational management systems
- Proficiency in Python, Power Automate, or other scripting and automation tools
- Experience with Microsoft Fabric, Azure, cloud-based data platforms, or comparable technologies
- Practical experience using generative AI tools, AI-assisted coding, or machine learning applications to support data analysis
- Experience developing automated anomaly detection, exception reporting, or predictive analytics
- Understanding of manufacturing or operational KPIs including productivity, quality, delivery, inventory, cost, and financial performance
- Experience developing reporting environments from the ground up or modernizing existing reporting processes
- Location: Middletown, CT (onsite)
- Shift: 1st Shift Monday-Friday
- Salary: USD 95,176 - 152,282 per year (salaried pay range)