Manager, Data Analytics

Simon Property Group • Morristown, NJ

19h • $62,000 - $121,346

About The Position

This position reports to the Vice President of Business Analytics, SME. Create and update dynamic analytical models for the SME sales team, volume-based businesses, strategic and programmatic media. Manage analysis and modeling to exacting standards to generate operational insights and provide monthly financial accruals and allocations. The successful candidate’s responsibilities will include, but not be limited to: Help drive effort to develop and maintain programmatic ecosystem – inventory data, network health tracking/monitoring, revenue reporting, pricing optimization, etc. Understand all volume-based business agreements to ensure monthly reporting from the business partners is complete and revenue is calculated accurately. Assist in preparing 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. Assist in managing 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 SME pipeline report twice a week and adapt the dynamic model as needed. Update and adapt weekly SME 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 SME 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.

Requirements

• Bachelor’s degree in Business Analytics/Business/Financial Management.
• Advanced Excel skills (power pivot, pivot tables, slicers, SUMIFs, IF statements, lookups, data tables, measures, etc.)
• Experience using Power BI for data visualization, reports, dashboards, apps, etc.
• 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
• 3-5 years’ experience

Nice To Haves

• Experience with Access, Salesforce.com, SQL and Python a plus

Responsibilities

• Help drive effort to develop and maintain programmatic ecosystem – inventory data, network health tracking/monitoring, revenue reporting, pricing optimization, etc.
• Understand all volume-based business agreements to ensure monthly reporting from the business partners is complete and revenue is calculated accurately.
• Assist in preparing 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.
• Assist in managing 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 SME pipeline report twice a week and adapt the dynamic model as needed.
• Update and adapt weekly SME 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 SME 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.

Benefits

• Simon offers a comprehensive benefits package, including, but not limited to, medical, dental, and vision coverage, 401(k), life and AD&D insurance, disability insurance, flexible spending accounts, and paid time off.
• This is a bonus-eligible position. Bonus award amounts are determined annually based on factors such as your position, achievement of individual performance goals, company's overall performance, as well as management's assessment of your individual performance.
• This position may be eligible for a discretionary bonus, which may be awarded at the sole discretion of management based on management's assessment of your individual performance

What This Job Offers

• Job Type: Full-time
• Career Level: Manager