Sr. Analyst, Business Intelligence

Position Summary

The Sr. Analyst, Business Sales is responsible for financial analysis and management of North America commission programs that drive both strategic and tactical initiatives related to Sales performance, promotional activities, and decision support. They are responsible for providing recommendations to the sales leadership based on their analysis, reporting and interpretation of sales data. The role will identify regional sales trends, forecast sales, lend analytical support to sales leadership in setting goals, and calculate and monitor performance to ensure sales effectiveness. The role works with Revenue Planning, Revenue Management, Finance and Accounting team to ensure cohesiveness with corporate goals and initiatives

Essential Duties and Responsibilities:

• Lead monthly North American commission certification, while maintaining multiple budgets totaling +$50M.
• Reconciliation of external payments to travel agencies in coordination with Accounting
• Responsible for the gathering, analysis, and interpretation of data. Analyze sales data to identify trends (i.e. regionally, by product, by account, by market, or by segment.
• Develop, implement and enhance high impact business reporting. Develop financial models and projections to address complex business problems.
• Provide information and recommendations to leadership on both regular and ad-hoc basis. Provide analytical support on tactical and strategic special projects. Prepare reports and presentations for all levels of the department.
• Develop productive working relationships with all Sales Managers, Directors, and Executives as well as peers and other colleagues within the department and cross-departmentally.
• Make decisions and ensure departmental metrics are tracked. Interpret data and make recommendations to sales management regarding sales strategy, process execution and revenue opportunities / risks. Provide decision support to Sales and business leadership through analysis and tracking of sales and product performance.
• Communicate with other departments to assure that departmental policy changes or projects that will affect processes are identified and solutions are created.
• Track and report results against specific initiatives and programs and make recommendations on improvements in a timely and efficient manner.
• Develop new and revise/maintain existing reports and operational procedures. Write or provide executive level analysis, reports, and presentations.
• Will be responsible for the development of Trade commissions programs
• Manage multiple budgets totaling +$50M.
• Lead monthly North American commission certification.
• Reconciliation of external payments to travel agencies in coordination with Accounting.

Qualifications, Knowledge and Skills:

• Bachelor’s degree (BA) from four-year college or university or equivalent work experience required.
• Two to four years related experience in financial / business analysis or related field preferred.
• Masters of Business Administration (MBA) or Masters degree (MA) preferred
• Previous experience with Sales or Marketing preferred but not required
• Analytical skills to interpret data trends.
• The responsibilities and level of supervision required will vary based on individual job performance.
• Excellent knowledge of Microsoft Word, Excel, and PowerPoint required.
• Knowledge of Hyperion, Brio, Access, Microsoft Project, Visio, Lotus Notes, and the AS400 or equivalent mainframe reservations system strongly preferred.
• Must be detail oriented to ensure accuracy in data and analysis.
• Ability to effectively present information to executive management and public groups.
• Ability to work, interact, and communicate with external / internal customers at all levels.
• Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
• Work on projects independently and as part of a cross functional team.
• Ability to solve complex problems with a variety of variables in situations where no standardization exists.