Business Intelligence Analyst
Everett, MA - USA
Job Summary
- Healthcare benefits Multiple coverage levels of medical dental and vision plans
- 401k Roth or Pre-Tax options $1 for $1 match and once eligible to enroll ZERO vesting period
- Long Term Disability and life insurance Company provides coverage for all
- Voluntary Life Disability Accident & Critical Illness Various insurance programs are offered to support your needs
- Employee Assistance Program To support you and your familys overall wellbeing to achieve your best and most productive self
- Sick and Vacation plans Cascade understands the vital importance of a quality work/life balance
- Pet insurance Multiple coverage levels for whatever best suits your furry (or not so furry) friend
- Cascade Cares Exciting engagement programs each month
- Leadership Training We invest in and dedicate time to training some of the best leaders in the industry
- Design develop and maintain interactive dashboards and reports using Power BI.
- Build and manage robust data models using Power Query DAX and SQL.
- Translate business requirements into scalable data solutions and visualizations.
- Develop standardized KPI reporting for manufacturing operations supply chain and finance.
- Partner with Operations Supply Chain and Finance teams to analyze:
- Production efficiency (OEE throughput downtime)
- Yield and waste metrics
- Labor productivity
- Inventory turns and accuracy
- Cost of goods manufactured (COGM)
- Support variance analysis related to production materials usage and labor.
- Assist in demand planning capacity planning and performance forecasting.
- Extract and transform data from ERP MES WMS and other operational systems.
- Ensure data integrity accuracy and consistency across reporting platforms.
- Develop and maintain data documentation and governance standards.
- Identify and implement process improvements in data collection and reporting.
- Work closely with Finance Operations IT Supply Chain and Executive Leadership to identify reporting needs.
- Present insights and recommendations to cross-functional stakeholders.
- Train end-users on dashboard utilization and data interpretation.
- Bachelors degree in Data Analytics Information Systems Finance Accounting Engineering or related field.
- 35 years of experience in business intelligence data analytics or reporting roles.
- Minimum 23 years of hands-on Power BI development experience.
- Experience in a manufacturing environment strongly preferred.
- Advanced proficiency in Power BI (data modeling DAX Power Query).
- Strong SQL skills for data extraction and manipulation.
- Experience working with ERP systems (e.g. SAP Oracle NetSuite Microsoft Dynamics or similar).
- Understanding of relational databases and data warehousing concepts.
- Proficiency in Excel and other data analysis tools.
- Familiarity with manufacturing KPIs (OEE scrap yield cycle time etc.).
- Understanding of cost accounting principles in a manufacturing setting.
- Experience working with production inventory and supply chain data.
- Strong analytical and problem-solving skills.
- Ability to translate complex data into actionable business insights.
- Attention to detail and commitment to data accuracy.
- Effective communication skills with both technical and non-technical stakeholders.
- Self-motivated with the ability to manage multiple priorities in a fast-paced environment.
- Experience with ETL tools or data integration platforms.
- Knowledge of Python or R for advanced analytics.
- Experience supporting budgeting forecasting or financial planning processes.
- Familiarity with lean manufacturing or continuous improvement methodologies.
- This job is located within the corporate office in an indoor environment.
- This position may occasionally support work in the warehouse roasting facility that requires constant standing on concrete floors exposed to loud equipment noise and subject to coffee dust strong odors.
- Personal protection equipment and other Good Manufacturing Practices are mandatory.
Required Experience:
IC
About Company
Cascade Coffee is a premier gourmet coffee contract manufacturer located near Seattle, Washington. We specialize in roasting, grinding, flavoring, and packaging coffee, catering to the world’s finest coffee brands and shipping orders both across the United States and internationally. ... View more