IT Data Analyst

Essential Functions – Data Management & Analysis:

1) Extracts, cleans, transforms, and validates data from multiple sources, including ERP Systems, Quality Systems, and production databases.

2) Develops advanced data models, visualizations, and reports using tools such as Power BI, SQL and Microsoft Access.

3) Analyzes production, inventory, quality, scrap, and labor efficiency trends to support operational decision-making.

4) Builds and maintains dashboards for real-time monitoring of KPI's (production throughput, quality audits, scrap, cycle time).

5) Ensures data accuracy and integrity, completeness, and security in alignment with IT and regulatory standards.

6) Troubleshoots data discrepancies, partnering with cross-functional teams to resolve system and data issues.

Essential Functions - Manufacturing Systems Support:

1) Collaborates with Operations, Engineering, Quality, Supply Chain, and Finance to understand data needs and translate business requirements into analytical solutions.

2) Supports integration of shop floor and production floor systems, to include barcode systems and machine logs.

3) Identifies automation opportunities and streamlines data workflows to reduce manual processes and eliminate redundancies.

4) Assists with ERP enhancements, upgrades, data migrations, and implementations, to include process workflow and data validation.

5) Recommends improvements based on statistical analysis, trend analysis, and operational insights.

6) Participates in Lean, Kaizen, and continuous improvement initiatives using data-driven methods.

7) Performs duties in support of the company's certifications (example: ISO and FDA/QSR).

Essential Functions – Documentation & Training:

1) Creates and maintains documentation for datasets, data dictionaries, workflows, and reporting processes.

2) Provides user training for dashboards, self-service analytics, and reporting tools.

3) Supports IT governance and compliance efforts, including data retention and audit requirements.

Secondary Functions:

1) Maintains a safe and clean work environment.

2) Performs other duties as assigned.

Job Scope/Demands & Complexity:

Frequent new and varied work situations

Job involves a high degree of complexity

Operates from established procedures using technical knowledge and experience

Contributes to the development of new concepts

Operates under minimal supervision

Supervisory Responsibility:

This position has no supervisory responsibilities.

Interpersonal Contacts:

Contacts will be:

Primarily made with others within the company

Made with others on own initiative

Made face to face, via email, over the phone

Knowledge, Skills & Abilities:

1) Experience with designing and analyzing SQL queries, as well as complex databases

2) Strong analytical skills with the proven ability to interpret complex datasets and present clear insights

3) Technical aptitude and system integration awareness

4) Ability to apply analytical and diagnostic skills to troubleshoot systems and database issues

5) Strong problem-solving ability, to include use of creativity, analytical skills and independent judgment

6) Ability to effectively train others in job-related skills

7) Strong aptitude for applying sound judgement in routine decision making

8) Strong project management skills with the ability to manage multiple priorities

9) Strong organizational and communication skills

10) Ability to collaborate with technical and non-technical stakeholders.

11) Aptitude for sharing knowledge and expertise with fellow team members

Job Conditions:

• Office/manufacturing environment with presence on the production floor as needed.

• Working a minimum of 40 hours per week is expected. May require working more than 8 hours per day or 40 hours per week to complete essential duties of the job.

Physical Requirements:

• Constant: Sitting or standing, use of hands, wrists and fingers for writing and keyboarding, grasping parts and using hand tools, hearing/listening, and talking.

• Frequent: Exposure to standard manufacturing elements, including noise, moving equipment, and PPE areas.

• Occasional: Walking, bending, reaching, lifting and carrying up to 35 lbs. for troubleshooting equipment or data collection activities. Visual acuity to be able to read printed documents and computer screens.

Education & Experience:

Required:

• Bachelor's Degree in Information Technology, Data Analytics, Computer Science, Business Intelligence, Industrial Engineering, or related field

• Minimum 5 years of experience in a manufacturing environment working with production, operations, or quality data

• Proficiency with SQL, relational databases, and data modeling

• Solid understanding of ERP systems and manufacturing process flows.

• Experience with business intelligence tools and dashboard design

Preferred:

• Experience in regulated manufacturing industries (medical devices, aerospace, electronics)

• Knowledge of Lean, Six Sigma, or continuous improvement methodologies

• Exposure to ISO environments

The IT Data Analyst supports the organization by designing, developing, and maintaining data models, reports, dashboards, and analytic solutions that improve decision-making across manufacturing, operations, and business functions. This role acts as a liaison between IT and Operations, ensuring data integrity, optimizing process and data workflows, and providing insightful analysis to improve productivity, quality, and overall performance.