Junior Business & Data Analyst

Junior Business & Data Analyst (Continuous Improvement & Business Integration Support)


Reports To: Continuous Improvement & Business Integration Manager Department: Operations / Continuous Improvement / Business Integration

Role Summary

This role supports the Continuous Improvement (CI) & Business Integration function by maintaining accurate, standardized data and converting it into actionable reporting that drives operational performance. The Junior Business & Data Analyst helps sustain KPI visibility across the plant(s), supports project tracking and communication, assists with dashboard/report automation, and improves data integrity so teams can measure, manage, and improve.

Key Responsibilities

Data Integrity, Tracking, and Governance: 

• Maintain data clarity, cleanup, and tracking across plant systems and reporting tools (ERP/MES/QMS exports, spreadsheets, dashboards). 
• Validate data quality (missing fields, incorrect codes, duplicates), correct issues, and coordinate fixes with process owners. 
• Maintain KPI definitions, data dictionaries, and documentation so reporting is consistent across departments and sites.
• Own “single source of truth” files/tables for CI reporting (version control, refresh routines, change logs). 

KPI Reporting & Dashboards:

• Build, refresh, and maintain recurring CI/Operations KPI reporting (daily/weekly/monthly).
• Assist with Power BI dashboards (data refresh, uploads, troubleshooting, measures support) and publish-ready visuals. 
• Create performance summaries for tier meetings and leadership reviews (variance, trends, key drivers, action focus). 
• Develop standard report templates that reduce manual effort and improve consistency. 

Analysis & Continuous Improvement Support 

• Perform analysis to identify drivers of performance (scrap/waste, downtime, speed loss, labor efficiency, schedule attainment, OTIF).
• Create Pareto charts, trend views, and stratified analysis (by shift, line/press, product family, customer, material).
• Support root-cause work by preparing data sets for problem solving (A3s, 5-Why, fishbone, DMAIC).
• Track CI project impact and savings (baseline vs improved), including assumptions and validation methods. 

Automation & Systems Support 

• Assist with automation tools for reporting and data movement (Power Query, Power Automate, scheduled refresh routines). 
• Support data uploads and transformations required for dashboards and standardized reporting.
• Identify repetitive reporting tasks and recommend/implement improvements with oversight.

Project Coordination & Communication 

• Maintain project trackers, timelines, action logs, and status updates for CI and business integration initiatives. 
• Prepare meeting materials, follow-ups, and progress updates for cross-functional stakeholders. 
• Help train users on new processes/data entry standards and ensure adoption with documented SOPs. 

Typical Deliverables

• Daily/weekly KPI scorecards and tier meeting visuals 
• Waste/downtime Pareto and “top drivers” summaries 
• Project tracker with milestone status, risks, and next actions
• Standard work documentation for reports, dashboards, and data entry processes 
• Baseline vs actual improvement impact tracking for CI initiatives 

Required Qualifications 

• 0–2 years of experience (internships/co-ops acceptable) in analytics, operations, finance, engineering, or CI support. 
• Intermediate Microsoft Excel skills (PivotTables, XLOOKUP, SUMIFS, charting; comfortable with large datasets). 
• Entry-level understanding of databases and schema concepts (tables, keys, joins). 
• Strong organizational skills and attention to detail (data accuracy is non-negotiable). 
• Ability to communicate clearly with both production-floor and office stakeholders. 

Preferred Qualifications 

• Power BI experience (model basics, DAX measures, publishing/sharing). 
• SQL basics (SELECT, JOIN, GROUP BY). 
• Power Query and/or Power Automate experience.
• Basic scripting in Python or R for automation/analysis. 
• Experience in a manufacturing environment and familiarity with operational KPIs. 

Core Competencies & Values Fit 

• Excellence: takes pride in clean data, clear logic, and polished deliverables
• Punctuality: meets reporting deadlines and keeps stakeholders informed
• Consistency: standardizes processes and prevents “one-off” reporting chaos
• Accuracy: validates inputs/outputs and documents assumptions 
• People: collaborative, respectful, and service-oriented across departments 

Performance Measures (First 90–180 Days) 

• CI reporting is accurate, on-time, and trusted by stakeholders 
• Reduced manual reporting effort through templates/automation 
• Documented KPI definitions and report SOPs adopted and used 
• Meaningful insights delivered that drive action (waste, downtime, speed, schedule adherence) 
• CI project tracking is current, clear, and reliable for leadership reviews 

Work Environment 

• Mix of office and manufacturing floor engagement to validate data against reality 
• Multi-department collaboration; occasional support around shift schedules as needed