Data Analyst

MSA, The Safety Company; Cranberry Township (Butler County); On-site; USD 70,000 - 100,000; Full time

Job summary

MSA Safety seeks a dedicated Supply Chain Analytics professional to analyze data, build dashboards in Power BI, and drive improvements across the supply chain.

You will partner with IT and business leaders to develop data models, maintain data integrity, and deliver regular reporting to support decision making.

Qualifications

• 0-2 years of manufacturing/operational data and analytics experience.
• 2-4 years of Manufacturing/Operational Analytics Experience.
• 4+ years of Manufacturing/Operational Analytics Experience.
• Bachelor’s Degree in Computer Science, Engineering, Mathematics Statistics, Logistics, Supply Chain Management, Business or other related discipline.
• Experience with ERP systems (SAP).
• Advanced Experience with MS Office Products (Excel, PowerPoint, Access and Word).
• Experience in leading a cross functional team without direct authority of team members.
• Experience in extracting data from BI or other DB sources, validating and conducting advanced analytics.

Responsibilities

• Regularly analyze data, workflow and processes, using numerical and statistical analyses, to make quantifiable cost benefit analysis and recommendations for improvement in subject areas not limited to in/outbound fill rate, inventory, supply/ replenishment planning, cost reduction, distribution and network optimization.
• Create measurement systems, reports and forecasts to support cost, quality and delivery.
• Own key performance indicators and consistently publish results in a frequency defined by the business.
• Conduct advanced data analysis using Power BI, Excel, etc.
• Compile and reconcile data from multiple sources into formats to be leveraged by Business Partners and Senior Leaders
• Provide daily, weekly and monthly reporting and analysis to Business Partners and Senior Leaders
• Responsible for gathering data and conducting analysis with the goal of improving the supply chain operations
• Identify underperforming areas and recommend improvements and resolutions to issues
• Create processes and methods to gather supply chain data
• Collect and analyze data to monitor performance against targets & trends, to identify problematic areas and recommend solutions
• Monitor data and system rules to ensure data integrity
• Conceptualize and build centralized tools (including dashboards) that the Global Operations team can use to extract data/insights for daily business management in an automated manner
• Work with end users to gather KPI details, business logic and data requirements for new dashboards.
• Translate user requirements into technical requirements. Collaborate with IT to determine the appropriate data repositories. Balance needs of agility to support end users and long-term maintainability.
• Create data model to accurately reflect business reality. Optimize as necessary to deal with system constraints.
• Visualize data collaboratively using dashboarding best practices end user requirements as a starting point. Refine dashboard based on key user feedback both before go-live and on a continuous basis.
• Test thoroughly and proactively identify and resolve data integrity issues.
• Develop user training for dashboards and analytics platforms to increase adoption across the organization.
• Educate users on best practices for maintaining data feeding reports and act as liaison on them with appropriate IT resources if needed.
• Develop internal training to ensure processes are repeatable as the supply chain analytics function continues to expand.
• Capture data that is not available in existing production systems. Ensure data can be validated and used in dashboards on an ongoing basis without manual intervention.
• Coordinate dashboard refreshes with external systems to ensure data is reliable before publishing
• Evaluate new automation opportunities and platforms to reduce manual error and non-value-added work across the supply chain.
• Perform project management functions for new business implementations, leading departmental action items/tasks
• Identify and prioritize efforts to support and improve analytics within the supply chain.
• Collaborate with IT professionals to ensure implementation of effective systems
• Enforce global reporting standards and led efforts to ensure KPIs are globally consistent.
• Create and facilitate user acceptance testing and drive adoption of reporting tool sets across the Supply Chain organization
• Increase ease of access to organizational data by prioritizing supply chain datasets to be moved into BI and data repository systems.

Skills

Data analytics

Power BI

Excel

Dashboarding

Data modeling

Education

Bachelor’s Degree in Computer Science, Engineering, Mathematics Statistics, Logistics, Supply Chain Management, Business

Tools

SAP

MS Office

Job description

Overview

Are you someone who is passionate, motivated, and driven to make a difference? If so, MSA Safety is the perfect fit for your career.

At MSA, SAFETY is who we are AND it is what we do. We are a purpose-driven company committed to deploying innovation and technology to deliver on our Mission to help protect people and assets all around the world. We continue to be relentless in our pursuit of solving our customers greatest problems so they can go home safe each and every day.

Are you in? Read on for more details about this particular role.

Responsibilities

• Regularly analyze data, workflow and processes, using numerical and statistical analyses, to make quantifiable cost benefit analysis and recommendations for improvement in subject areas not limited to in/outbound fill rate, inventory, supply/ replenishment planning, cost reduction, distribution and network optimization.
• Create measurement systems, reports and forecasts to support cost, quality and delivery.
• Own key performance indicators and consistently publish results in a frequency defined by the business.
• Conduct advanced data analysis using Power BI, Excel, etc.
• Compile and reconcile data from multiple sources into formats to be leveraged by Business Partners and Senior Leaders
• Provide daily, weekly and monthly reporting and analysis to Business Partners and Senior Leaders
• Responsible for gathering data and conducting analysis with the goal of improving the supply chain operations
• Identify underperforming areas and recommend improvements and resolutions to issues
• Create processes and methods to gather supply chain data
• Collect and analyze data to monitor performance against targets & trends, to identify problematic areas and recommend solutions
• Monitor data and system rules to ensure data integrity
• Conceptualize and build centralized tools (including dashboards) that the Global Operations team can use to extract data/insights for daily business management in an automated manner
• Work with end users to gather KPI details, business logic and data requirements for new dashboards.
• Translate user requirements into technical requirements. Collaborate with IT to determine the appropriate data repositories. Balance needs of agility to support end users and long-term maintainability.
• Create data model to accurately reflect business reality. Optimize as necessary to deal with system constraints.
• Visualize data collaboratively using dashboarding best practices end user requirements as a starting point. Refine dashboard based on key user feedback both before go-live and on a continuous basis.
• Test thoroughly and proactively identify and resolve data integrity issues.
• Develop user training for dashboards and analytics platforms to increase adoption across the organization.
• Educate users on best practices for maintaining data feeding reports and act as liaison on them with appropriate IT resources if needed.
• Develop internal training to ensure processes are repeatable as the supply chain analytics function continues to expand.
• Capture data that is not available in existing production systems. Ensure data can be validated and used in dashboards on an ongoing basis without manual intervention.
• Coordinate dashboard refreshes with external systems to ensure data is reliable before publishing
• Evaluate new automation opportunities and platforms to reduce manual error and non-value-added work across the supply chain.
• Perform project management functions for new business implementations, leading departmental action items/tasks
• Identify and prioritize efforts to support and improve analytics within the supply chain.
• Collaborate with IT professionals to ensure implementation of effective systems
• Enforce global reporting standards and led efforts to ensure KPIs are globally consistent.
• Create and facilitate user acceptance testing and drive adoption of reporting tool sets across the Supply Chain organization
• Increase ease of access to organizational data by prioritizing supply chain datasets to be moved into BI and data repository systems.

Qualifications

Experience Required:

Level 1: 0-2 years of relevant experience in manufacturing/operational data and analytics

Level 2: 2-4 years of Manufacturing/Operational Analytics Experience

Level 3: 4+ years of Manufacturing/Operational Analytics Experience

Education Required:

Bachelor’s Degree in Computer Science, Engineering, Mathematics Statistics, Logistics, Supply Chain Management, Business or other related discipline.

Experience Preferred:

• Experience with Project management
• Experience with ERP systems (SAP)
• Advanced Experience with MS Office Products (Excel, PowerPoint, Access and Word)
• Experience in leading a cross functional team without direct authority of team members
• Experience in extracting data from BI or other DB sources, validating and conducting advanced analytics