Alterra Mountain Company is a family of 16 iconic year-round resorts, the world’s largest heli-skiing operation, and Ikon Pass - the premier ski and snowboard season pass offering access to more than 50 iconic mountain destinations around the world. Headquartered in Denver, Colorado and born out of a shared love of the mountains and adventure, the company has brought together some of the world’s most aspirational brands, including: Steamboat and Winter Park in Colorado; Palisades Tahoe, Mammoth Mountain, June Mountain, Big Bear Mountain Resort and Snow Valley Mountain Resort in California; Stratton Mountain and Sugarbush Resort in Vermont; Snowshoe Mountain in West Virginia; Tremblant in Quebec and Blue Mountain in Ontario, Canada; Crystal Mountain in Washington; Deer Valley Resort and Solitude Mountain Resort in Utah; and CMH Heli-Skiing & Summer Adventures in British Columbia. Also included in the portfolio is Alpine Aerotech, a worldwide helicopter support and maintenance service center in British Columbia, Canada and Aspenware, the ski industry leader in technology services and e-commerce. For more information, please visit www.alterramtnco.com.

The Data Analyst will support the marketing team by providing data driven insights regarding customers, markets, competitors, and campaign effectiveness. This position will provide analysis on a formal and ad hoc basis and will develop reporting that is as standardized and automated as possible with the objective of measuring performance and supporting business decisions. The Data Analyst will be an expert in management and querying of large data sets to drive business decisions. Modeling, joining data, querying large data sets, automation of data processes, and development of reporting/dashboards are core functions of this role. In addition, support of research functions and the management and analysis of survey data and management of guest sampling for survey research will be important aspects of this role.

Essential Duties

• Employ CRM databases to analyze email and direct marketing campaign performance. Analyze marketing metrics to identify cause-effect relationships between marketing actions and financial outcomes to increase profitability.
• Query data tables and create new data tables using SQL to provide analysis of market segments and product types to help optimize marketing performance and support strategic decisions. Proactively suggest analysis and research based on business objectives.
• Connect data across multiple touchpoints of the customer journey to drive insights for marketing campaigns that ultimately results in incremental revenue. Ability to connect CRM, social, web, and transaction data in a compelling and consistent manner to evaluate marketing campaign performance.
• Development of consistent approaches and tools for customer segmentation reporting and support in building, maintenance and analysis of customer segmentation.
• Design and implement ad-hoc research and data analysis that answer specific business questions.
• Create compelling data visualizations, using tools such as Tableau, to report and present analysis on marketing efforts and segmentation results. Communicate findings with diverse stakeholder groups. Automate reporting processes.
• Support the research function of the organization with data analysis and management from survey research. Manage sampling and data structures for surveys. Deliver insights from survey research programs and data as charts, graphs, and PPT presentations.
• Analyze and organize available data across multiple resorts and business units. Inspect, clean, and transform data while maintaining perspective on the relevant business questions.
• Support and help guide best practices for development of predictive analytics.
• Identify strategic recommendations based upon data and research.
• Complete competitive analysis on the industry.
• Other duties as assigned.

Competencies & Job Requirements

Required:

• Marketing: Knowledge of marketing, sales, and business processes. Experience extracting marketing data, combining and joining to provide insights. Experience combining data across marketing channels: CRM, web, social, research, media, app, etc. for the purposes of evaluating marketing effectiveness.
• CRM Database: Experience using data tables from CRM databases to identify key insights, create reports, and analyze customer behavior. Ability to extract data using SQL and create new, consistent data tables using SQL.
• Organization: Demonstrate ability to proactively prioritize needs, put first things first, and effectively manages resources and time. Excellent organizational and problem-solving skills with the ability to handle multiple tasks. Ability to project manage and prioritize.
• Analytics: Proven experience providing analysis and insights that had meaningful influence on strategies. Demonstrated success working with large and complex data sets. Experience building queries manipulating data with SQL, Tableau, Python, R and similar platforms is essential. Experience with survey data, sampling, and reporting from survey programs.
• Data Visualization: Ability to create reporting and data visualizations in Tableau. Ability to create straightforward visualizations for PPT presentations.
• Communication: Able to communicate effectively in writing and verbally across all levels of the organization. Able to effectively present information to management, employees, and customers.
• Reasoning Ability: Able to make independent judgments which have considerable impacts on the organization. Able to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Strong sense of curiosity needed.
• Advanced user with Microsoft Office suite (specifically Excel and PowerPoint).
• A team player who excels in a fast-paced environment and can operate with limited or general supervision. Able to navigate ambiguity and create new processes as warranted.

Preferred:

• Experience with customer segmentation.

Education & Experience

Required:

• Bachelor’s degree in related field required (marketing, business, business analytics, finance, economics, mathematics).

Preferred:

• MBA or master’s degree in related field preferred.

Work Experience

Required:

• 3-5+ years of experience in marketing analytics and market research.
• Equivalent combination of education and experience