Director, Business Analytics - Simon Media & Experiences

Company: Simon Property Group
Location: Indianapolis
Posted on: October 16, 2024

Job Description:

Director, Business Analytics - Simon Media & Experiences
Job Location: Corporate Indianapolis
Primary Purpose:

• 
  
• Create and update dynamic analytical models for the SBV sales team and volume-based businesses.
  
• Manage analysis and modeling to exacting standards to generate operational insights and provide monthly financial accruals and allocations.
  
  Principal Responsibilities:
  The successful candidate's responsibilities will include, but not be limited to:
  
  • 
    
  • Understand all volume-based business agreements to ensure monthly reporting from the business partners is complete and revenue is being calculated accurately. Prepare monthly accruals and ACH allocations to the shopping centers for each business.
    
  • Analyze weekly and monthly metrics to identify trends for each volume-based business. Communicate those trends to the business owners so that they may address any issues and ensure maximum opportunity to generate revenue.
    
  • Manage the monthly forecasting and accrual processes for all volume-based businesses - need to have a strong understanding of credits & debits in the general ledger.
    
  • Ability to evaluate and adapt the volume-based business forecast models as needed and update the volume-based business summary report.
    
  • Create budget models for all volume-based businesses using known trends, business events, agreement terms, etc.
    
  • Update SBV pipeline report twice a week and adapt the dynamic model as needed.
    
  • Update and adapt weekly SBV revenue pacing and YOY status reports for EVP.
    
  • Prepare weekly summary of the revenue change (+/-) in deal activity.
    
  • Generate and distribute the contracted revenue reports for the SBV sales team monthly.
    
  • Create special request reports/analyses for EVP, and other responsibilities as assigned.
    
  • Meet deadlines for all accruals, allocations, reporting, etc. on a consistent basis.
    
    Minimum Qualifications:
    
    • 
      
    • Bachelor's degree in Business Analytics
      
    • Advanced Excel skills (power pivot, pivot tables, slicers, SUMIFs, IF statements, lookups, data tables, measures, etc.)
      
    • Extensive experience using Power BI for data visualization, reports, dashboards, apps, etc.
      
    • Experience with Access, Salesforce.com, SQL and Python a plus
      
    • Strong analytical and conceptual skills, ability to build dynamic (interactive) analytical and forecast models
      
    • Basic accounting skills: strong understanding of credits, debits, and accruals
      
    • Logical thinker that is highly detail oriented with exceptional organizational skills
      
    • Ability to interpret and understand contract language
      
    • Ability to prioritize, multi-task, meet deadlines, and demonstrate initiative
      
    • Flexible and able to work independently in a fast-paced environment
      
    • A problem solver who not only can develop and maintain multiple analyses, but can interpret the data and effectively communicate actionable insights
      
    • Minimum of 8 years experience
      
      About Us
      Simon is a global leader in retail real estate ownership, management and development and an S&P 100 company (Simon Property Group, NYSE: SPG). Our industry-leading retail properties and investments across North America, Europe and Asia provide shopping experiences for millions of consumers every day and generate billions in annual retail sales. Our portfolio includes assets of national and international renown - proven assets that are the preferred location for retailers.
      In addition to our high quality properties, Simon is also known for our strong balance sheet, a long-tenured and well-respected senior management team, and our innovative spirit, as reflected in a 50 + year history of successful retail real estate development, management, and leasing. Simon was named Fortune's Most Admired Real Estate Company eight times. We have experienced an explosion of growth and innovation unprecedented in the industry and we look forward to Simon's future.
      Simon is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
      If you require assistance or need to request an accommodation due to a disability, please email CandidateAccommodations@simon.com. Please note this email is intended only for accommodation requests related to the application and interview process. Any other correspondence will not receive a response.
      #J-18808-Ljbffr

Keywords: Simon Property Group, Middletown , Director, Business Analytics - Simon Media & Experiences, Advertising , Indianapolis, Ohio