Strategic Planning Specialist I

Job Description

Lead collaborative process to develop robust, marketing transaction and budget forecasts that reflect thoughtful strategic planning, collaboration/coordination with channel managers, financial discipline and creative thinking.
Design and implement data models and simulations to forecast trends and patterns using advanced analysis and tools such as Python and integrate into repeatable dashboard (Tableau/ Power BI)
Identify areas of improvement and implement solutions to streamline, integrate and automate processes using advanced analytics tools to improve efficiency and accuracy
Calculate and forecast profitability of campaigns; perform sensitivity analysis for key assumptions and market scenarios
Prepare business case evaluations—including NPV, ROI, and Customer Lifetime Value analyses to provide cost-benefit recommendations on channel proposals and initiatives
Create and lead management presentations on campaign and channel-specific key drivers/metrics/performance to optimize channel mix and spend

Education, Experience & Skill Requirements

• 7 years of work experience in quantitative business functions such as FP&A, Data Science, Revenue Management or Business Intelligence
  Experience gained thru college degree or certifications is applicable to above skills (Bachelor’s degree with 5+ years or Master’s with 4+ years or equivalent 7+ years)
  Bachelor’s degree in Finance, Economics, Business or Data Analytics preferred
• Advanced experience in data modeling, SQL and/or Snowflake, Python and data visualization tools (Tableau/Power BI)
  Prompt engineering experience is a plus

Key Metrics

• Excellent analytical, problem-solving organizational, and time management skills, with the ability to work independently, proactively pursue business growth opportunities as a self-starter, and manage diverse range of projects simultaneously
  Ability to gain content knowledge quickly and a demonstrated ability to work effectively in a rapidly changing environment
  On time and accurate delivery and development of insightful forecasts, marketing spend tracking and transaction planning
  Strong oral and written communication skills, good presentation skills, and excellent interpersonal skills with the ability to work comfortably with all levels of employees, management and leadership
  Ability to leverage advanced analytics tools to convert large complex data into actionable business insights via dashboard visualization