MANAGER - DATA MANAGEMENT AND REPORTING (6-10 YEARS OF EXPERIENCE IN ADVANCE EXCEL AND VBA)

Description Manager, Data Management & Reporting, Future Planning Responsible for re-building, maintaining and managing Future Planning tools and reports including, program budgets, data roll ups, growth projection files, inventory management & tracking files, and capacity management files.
The successful candidate will also provide analysis and actionable reports of Conference Production future planning data to aid senior leadership decision making.
What you will do.
Design and build from start to finish complex analytic models and tools to support the global team, utilizing advanced modelling, Excel, and VBA skills.
Rebuild growth projection model in-line with our business-wide priorities to effectively manage our projected conference growth for long term planning purposes.
Automating and streamlining our current processes, whilst taking direction to build a source of truth that reflects similar models across the business.
Build, manage, and continuously improve all planning documents and associated roll ups, critical for managing various functions across the Conferences Future Planning team.
Including over 250 complex and cross-linked files at any given time in Microsoft Excel.
Create automations and efficiencies across various planning documents that are widely used across multi-functional teams.
Proactively identify opportunities to automate processes, mapping out project plans to drive document improvement and connections.
Use advanced VBA programming to automate manual Excel processes to realize significant time savings and reduction in errors.
Partner with stakeholders and other team members to identify data analytics requirements.
Identify and implement most effective and efficient solutions.
Support global team, building conference planning tools from scratch, including problem solving the most effective solutions and training team as required, enabling production team to efficiently analyze large amounts of data & make crucial event planning decisions.
What you will need.
Experience.
6+ years of progressive business experience, preferably in a strategy, consulting or business operations role.
Qualifications & Education.
Bachelor’s degree and advanced training in Microsoft Excel is preferred.
Technical skills.
Highly proficient in Microsoft Excel including VBA, with the ability to create and interpret complex Excel reports to track past, present, and future conference data and determine how to represent this in a dashboard.
Experience of SharePoint and its capabilities is desirable, but not required.
Ability to identify opportunities to automate processes using smart technology and quickly master any new software needed to build the models and tools required to take projects to the next level.
Soft skills.
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.
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.
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.
It is essential that you can work alongside a team whose technical skills and knowledge is organically learned and can translate directions and results in a digestible manor.
Strong core values.
You demonstrate integrity, collaboration, a no-limits mindset, objectivity, and consistent results using global best practices.
Personality traits.
Proactively demonstrate open-mindedness to contextualize all projects in their real-life scenarios, through building an understanding and knowledge of the conferences business.
Being customer-centric is pivotal to our expectations of delivering seamless onsite experiences.
This role will include travel and onsite conference delivery.
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 and we're proud to have over associates globally that support over 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 + or by sending an email to  .
Job Requisition ID.
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.
https://jobs.
artner.
om/applicant-privacy-policy For efficient navigation through the application, please only use the back button within the application, not the back arrow within your browser.