Master Data Analyst
Job Overview:
Manufacturing Analytics & Business Intelligence
Department: Operations / Manufacturing Excellence
Reports To: Sr. Maintenance Manager
Location: Essex, Vermont
Position Summary
The Data Analyst is responsible foracquiring, processing, analyzing, and visualizing manufacturing data to support operational excellence, productivity improvements, and strategic decision-making. This role serves as the primary resource for transforming complex production, maintenance, quality, and supply chain data into meaningful dashboards, reports, and actionable insights.
The successful candidate will work closely with Operations, Maintenance, Engineering, Quality, Supply Chain, and Leadership teams to design and maintainreporting solutions using Power BI, Tableau, MDS (Manufacturing Data System), Excel, SQL, and other analytics tools. This position plays a critical role in supporting highly automated manufacturing operations through data-driven decision making.
Key Responsibilities
Data Acquisition & Integration
- Collect, validate, and consolidatedata from manufacturing systems including:
- MDS (Manufacturing Data System)
- MES platforms
- SCADA and PLC systems
- ERP systems
- Quality management systems
- Maintenance management systems (CMMS)
- Data warehouses and cloud platforms
- Develop automated data extraction and transformation processes to improve reporting efficiency.
- Ensure data integrity, accuracy, and consistency across multiple systems.
Business Intelligence & Reporting
- Design, develop, and maintaininteractive dashboards and reports using:
- Power BI
- Tableau
- Excel
- Reporting Services
- Build automated reporting solutions that provide visibility into:
- OEE (Overall Equipment Effectiveness)
- Production performance
- Downtime analysis
- Yield and scrap performance
- Quality metrics
- Labor efficiency
- Maintenance KPIs
- Inventory and supply chain metrics
- Create executive-level reports that support strategic decision making.
Manufacturing Analytics
- Analyze production trends and identifyopportunities for process improvement.
- Perform root cause analysis using production and operational data.
- Develop statistical models and KPI scorecards to measure business performance.
- Support Continuous Improvement initiatives through data analysis and visualization.
- Identifyemerging trends, performance gaps, and areas requiring corrective action.
Business Partnership
- Work directly with plant leadership to define reporting requirements.
- Translate business needs into technical reporting solutions.
- Train end users on dashboard functionality and data interpretation.
- Serve as a subject matter expert for manufacturing analytics and reporting tools.
Total Rewards:
- Salary Range: $62,500 - $75,000
- Actual placement within the compensation range may vary depending on experience, skills, and other factors
- Benefits, subject to election and eligibility: Medical, Dental, Vision, Disability, Paid Time Off (including paid parental leave, vacation, and sick time), 401k with company match, Tuition Reimbursement, and Mileage Reimbursement
- Annual bonus based on performance and eligibility
Requirements:
- Bachelor's Degree or equivalent experience in Data Analytics, computer science, statiscs, business analytics or related field.
- 1-2years of experience in data analytics, business intelligence, or manufacturing analytics.
- Experience working within a manufacturing, industrial, or automated production environment.
- Experience building enterprise-level reports and dashboards.
Technical Skills
Advanced
- Power BI
- Tableau
- Microsoft Excel
- Pivot Tables
- Power Query
- Power Pivot
- Advanced formulas
- SQL
- Data modeling
Preferred
- MDS (Manufacturing Data System)
- MES platforms
- SCADA systems
- Ignition
- Historian databases
- Python
- R
- Snowflake
- Azure Data Platform
- Manufacturing ERP systems
Preferred Qualifications
- Experience supporting highly automated manufacturing facilities.
- Knowledge of Lean Manufacturing principles.
- Understanding ofSix Sigma methodologies.
- Familiarity with OEE, downtime tracking, and production analytics.
- Experience working with large data sets and cloud-based data platforms.
- Experience developing automated reporting and self-service analytics solutions.
Company Overview:
Keurig Dr Pepper (Nasdaq: KDP) is a leading beverage company with more than 150 owned, licensed and partner brands that meet a wide range of needs and occasions. Our North American refreshment beverage business holds leadership positions across carbonated soft drinks, water, juice and mixers with a portfolio of iconic brands such as Dr Pepper®, Canada Dry®, Mott’s®, A&W®, Peñafiel®, GHOST®, 7UP®, Snapple®, Clamato® and Core Hydration®. Our global coffee business spans more than 100 markets and includes the leading Keurig® single-serve brewing system in the U.S. and Canada, along with powerhouse brands such as Peet’s, L’OR and Jacobs, and other regional coffee leaders. Our more than 50,000 employees aim to enhance the experience of every beverage and coffee occasion while making a positive impact for people, communities, and the planet.
We strive to be an employer of choice, providing culture and opportunities that empower our team to grow and develop. We offer robust benefits to support your health and wellness as well as your personal and financial well-being. We also provide employee programs designed to enhance your professional growth and development, while ensuring you feel valued, inspired and appreciated at work.
Whatever your area of expertise, at KDP you can be a part of a team that’s proud of its brands, partnerships, innovation and growth. Will you join us?
Keurig Dr Pepper is an equal opportunity employer and recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability or association with a person with a disability, medical condition, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law.
A.I. Disclosure:
KDP uses artificial intelligence to assist with initial resume screening and candidate matching. This technology helps us efficiently identify candidates whose qualifications align with our open roles. AI does not make hiring decisions; all decisions throughout the hiring process are made by talent acquisition team members. If you prefer not to have your application processed using artificial intelligence, you may opt out by emailing your resume and qualifications directly to [email protected] in lieu of clicking Apply. In order for your application to be considered and opted out of AI, you must include the words "AI Opt-Out" and either job title and location or Job ID # in the email subject line in your email application.