This job offer is not available in your country.

Manager, Attendee Projections Data Management - Future Planning (6-10 yrs experience in VBA & Advance Excel)

GartnerGurgaon

30+ days ago

Job type

Full-time

Job description

About the role :

Responsible for preparing us for our future and the rapid growth of our Destination Conferences by establishing accurate attendee projections for onsite logistics planning. This includes maintaining and tracking projections across all conference attendee types, ensuring cancellation and no-show rates are considered, and tracking against maximum capacity to inform conference sell out.

The successful candidate will take ownership of the end-to-end processes for all attendee projections and will align with key stakeholders to successfully manage and track registrations as well as ensure data accuracy across all platforms. This person will inform the conference sell-out process, understanding what is required and where necessary help to build & recommend effective solutions to allow for the continued success of conferences.

What you will do :

Create and maintain automated attendee projection models, tools, and reports with the flexibility to adapt easily as attendee types change, and scale as the business grows, running weekly VBAs and complex excel queries.
Support Conference Logistics by providing attendee projections across all attendee types, including paid and complimentary, for onsite logistics planning.
Project manage against Logistics timelines to ensure projections are provided in line with key planning milestones tied to larger financial commitments, ensuring we are driving decisions to maximize conference contribution.
Inform the attendee sell out process, tracking registrations against venue max capacities, allowing for maximum conference growth whilst not compromising the attendee experience.
Generate reports for the Gartner Operating Committee with projected attendee volume for flagship conferences.
Perform in-depth data analysis to understand attendee behaviors and registration curves across all attendee types, ticket types and channels. Leverage findings to forecast attendance.
Ensure data consistency across registration platforms, troubleshoot discrepancies and partner with Registration, Business Analytics, and IT to resolve.
Maintain the attendee dashboard in PowerBI, looking for continuous improvement as well as accuracy and consistency across platforms and tracking systems.
Stay abreast of attendee type additions and modifications, partnering with Registration and ensuring necessary changes are executed within all tools and projection models.

What we will need :

Experience : 6+ years of progressive business experience, preferably in a strategy, consulting or business operations role.

Qualifications : Being extremely process driven with strong project management skills are essential. Events knowledge is a plus – e.g., understanding of floor plans, logistical challenges, etc.

Organizational Skills : You possess excellent organizational skills to manage complex formulas, logic, data structures, and interlinked Excel reports. Ability to categorize and bucket relevant information, take detailed notes on report requirements and data sources, and systematically build reports based on established logics.

Exceptional problem-solving capability : You have a proven track record of solving complex problems, thinking creatively, and using data to tell a story and drive change.

Technical skills : You are highly proficient in Microsoft Excel as well as VBA’s and can create and interpret complex Excel reports to track past, present, and future conference attendee data. Technical knowledge of PowerBI and other modeling platforms a plus.

Detail oriented : You have a critical eye for details and can effectively analyze and summarize data

Fast-paced : You operate with a sense of “urgency” and can excel in an execution-focused environment

Drive / Self-sufficiency : You have a demonstrated ability to own a problem and aggressively drive from problem statement to solution in a self-sufficient capacity, even in a matrixed environment

Communication skills : You are an excellent and structured verbal and written communicator with effective presentation and platform skills

Executive presence : You can effectively summarize and present attendee projection findings to your manager and other senior Gartner associates

Strong core values : You demonstrate integrity, collaboration, a no-limits mindset, objectivity, and consistent results using global best practices

Education : Bachelor's degree preferred

What you will get :

Competitive salary, generous paid time off policy, charity match program, and more!

Group Medical Insurance, Parental Leave, Employee Assistance Program (EAP)

Collaborative, team-oriented culture that embraces diversity

Professional development and unlimited growth opportunities

LI-Hybrid

LI-MD1

ConferencesOperations

Who are we?

At Gartner, Inc. (NYSE : IT), we deliver actionable, objective insight that drives smarter decisions and stronger performance on an organization’s mission-critical priorities. We’ve grown exponentially since our founding in 1979 and we're proud to have over 19,500 associates globally that support over 15,000 client enterprises in more than 100 countries.

What makes Gartner a great place to work?

Our teams are composed of individuals from different geographies, cultures, religions, ethnicities, races, genders, sexual orientations, abilities and generations. We believe that a diversity of experiences makes us stronger—as individuals, as communities and as an organization. That’s why we're recognized worldwide as a great place to work year after year. We've been recognized by Fortune as one of the World’s Most Admired Companies, named a Best Place to Work for LGBTQ Equality by the Human Rights Campaign Corporate Equality Index and a Best Place to Work for Disability Inclusion by the Disability Equality Index. Looking for a place to turn your big ideas into reality? Join #LifeAtGartner

What we offer :

Our people are our most valuable asset, so we invest in them from Day 1. When you join our team, you’ll have access to a vast array of benefits to help you live your life well. These resources are designed to support your physical, financial and emotional well-being. We encourage continued personal and professional growth through ongoing learning and development opportunities. Our employee resource groups, charity match and volunteer programs keep you connected to your internal Gartner community and causes that matter to you.

The policy of Gartner is to provide equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, ancestry, disability, veteran status, or any other legally protected status and to affirmatively seek to advance the principles of equal employment opportunity.

Gartner is committed to being an Equal Opportunity Employer and offers opportunities to all job seekers, including job seekers with disabilities. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access the Company’s career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at +1 (203) 964-0096 or by sending an email to .

Job Requisition ID : 87201

By submitting your information and application, you confirm that you have read and agree to the country or regional recruitment notice linked below applicable to your place of residence.

Gartner Applicant Privacy Link :

For efficient navigation through the application, please only use the back button within the application, not the back arrow within your browser.