Market and Forecast Analyst

Overview

Cree LED, an SGH company, offers one of the industry’s broadest portfolios of application-optimized LED chips and components, leading the industry in performance and reliability. Our team delivers best-in-class technology and breakthrough solutions for focused applications in High Power General Lighting, Mid-Power General Lighting, Specialty Lighting and Video Screens. With more than thirty years of experience, Cree LED develops products backed by expert design assistance, superior sales support and industry-best global customer service. For more information, visit www.cree-led.com.

Responsibilities

Job Summary:

We are currently seeking a Forecast and Market Analyst to join our Commercial Marketing team. This analyst will work cross-functionally to develop and support BI requirements across the marketing organization. This analyst will become the resident expert on market data and will focus on delivering insightful reporting to internal stakeholders and senior management. The ideal candidate will be a problem solver with the toolbelt to use data to answer open-ended questions and present findings across business units to achieve buy-in. This is a hybrid role requiring some on-site work in Durham, NC.

Key Responsibilities:

  • Analyze market trends, product sales, and distribution inventory to produce the monthly market forecast which feeds the factory supply plan
  • Own, develop, and maintain KPI reporting for commercial team
  • Play a key role in designing, testing, and implementing Product and Commercial Marketing data sources via SQL queries and Tableau visualizations
  • Provide high level reporting to senior management on a weekly/monthly basis
  • Utilize Tableau and Excel to streamline manual data processes
  • Liaise effectively with application developers, manufacturing teams, product managers, and internal IT resources to scope, execute, and test BI reporting tools
  • Provide ad-hoc data analysis to product management and commercial team members
  • Perform regular Oracle and business application updates through various data upload utilities

Important Skills

Requirements:

  • Education:
    • Bachelor’s degree in business, statistics, engineering, or related field; or equivalent
  • Technical:
    • Advanced Microsoft Excel ability; pivot tables, power query, data slicing, and validation are second nature to this individual
    • Understanding of manufacturing forecasting methods
    • Desire to become a Tableau guru
  • Business:
    • Impeccable attention to detail with the ability to thrive in fast-paced, rapidly changing environment
    • Excellent communication, organization and professional presence
    • Intrinsic drive and flexibility; able to quickly adapt to changing priorities
    • Prior experience with learning and mastering new software systems
    • Cross-functional communication
  • Other
    • Willingness to work a hybrid on-site/remote role

Preferred Qualifications:

    • Experience writing custom SQL queries
    • Experience with SAP
    • Dashboard development experience in Tableau or other BI tools
    • Experience planning UAT for dashboards and applications

This role may require additional duties and/or assignments as designated by management.

Benefits:

  • Medical, Dental and Vision benefits
  • Company bonus
  • 401k savings plan with company match
  • Flexible paid time off
  • Paid parental leave

Diversity and Inclusion Statement

SGH, together with its affiliates, is committed to creating a diverse environment that embraces differences and fosters inclusion.

Equal Opportunity Statement

Cree LED is an Equal Employment Opportunity Employer and is strongly committed to all policies that provide equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status, or genetic information.

Interview process includes completing our employment application forms. All offers of employment are contingent upon a successful background check, and proof of legal status to work in the U.S. We utilize E-Verify.

SALARY MIN

$78,000

SALARY MID

$100,000

Job Category
Job Type
Salary
Country
City
Career Level
Company
JOB SOURCE