Alterra Mountain Company | Hiring | Business Intelligence (BI) Analyst | Denver, CO | BigDataKB.com | 5 Oct 2022

Year Round

AUTHENTICITY | PASSION | COMMUNITY | INNOVATION | ADVENTURE

Alterra Mountain Company is a family of 15 iconic year-round mountain destinations, 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 and Big Bear 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, and Ski Butlers, the global leader in ski and snowboard rental delivery.

A career with Alterra Mountain Company is more than what you do today; it’s being part of creating a community rooted in the spirit of the mountains, united by a passion for adventure, and celebrating the legendary adventures and enduring memories that mountains bring to everyone.

BESIDES WORKING SOMEWHERE AWESOME, WHAT’S IN IT FOR YOU?

• Free Ikon Base Pass for all eligible employees, with additional free skiing + riding privileges across the family of Alterra Mountain Company resorts for all eligible employees and their dependents
• Discounted skiing + riding for friends and family of eligible employees across the family of Alterra Mountain Company Resorts
• Flexible Time Off (FTO) and Paid Time Off (PTO) policies for eligible employees to rest, relax and recharge
• Generous discounts on outdoor gear, apparel, rental cars, etc.
• Medical, dental, vision, life, AD&D, short term & long-term disability insurance, EAP, HSAs, FSAs, and more
• 401(k) plan with generous company match
• Discounted tuition with partner online university for all Alterra Mountain Company employees to further their education
• Paid parental leave of up to 6 weeks for eligible employees
• Commuter benefits (Denver employees only)
• Alterra Mountain Company office located in Denver’s RiNo Art District neighborhood

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily with or without reasonable accommodations.

POSITION SUMMARY

Alterra Mountain Company is looking for a BI Analyst to support the strategic use of data emanating from enterprise applications (Microsoft Dynamics 365, OneStream, Workday). This role will work directly with the Enterprise Applications Manager to realize solutions to the various business requirements given. Having a creative mindset and a passion for data visualization is key for this role, as well as having solid interpersonal skills and excellent written and oral communication of potentially complex topics with fellow team members and end-users.

ESSENTIAL DUTIES

General Responsibilities

• Analyze, design, build and test data visualization solutions (BI dashboards and report) that will enable the company to make better, more informed business decisions.

• Perform ad-hoc data analyses to provide answers to business questions.

• Collaborate with source system experts, vendors, and other team members to determine data extraction, transformation, analytics requirements.

• Breakdown raw information and undefined problems into actionable components that in order identifies clearly the problem the end user is trying to solve.

• Identify opportunities to leverage impactful data visualization using the existing enterprise applications.

• Work with your team, and end-users, to develop a BI roadmap.

• Promote the use of data and BI tools within the company. Train and support the end-users as needed.

EDUCATION & EXPERIENCE REQUIREMENTS

Education & Experience

• Bachelor’s degree in Computer Science, Information Science, Business Analysis or related field. Or equivalent combination of education and experience.

• 3-5 years of data analysis/visualization using Power BI, PowerQuery or Tableau

• 3 years of experience with MS SQL server, SSIS, SSRS, and normalized and dimensional models

• Experience with data visualization for complex corporate structure desired

• Business acumen in at least one of those areas: General accounting, AP, AR.

• Experience working successfully with both technical personnel and non-technical customers and staff

KNOWLEDGE, SKILL AND ABILITY REQUIREMENTS

• Analysis and design skills, critical thinking, and analytical problem solving

• Microsoft Business Intelligence language, specifically TSQL and DAX

• Must have a good understanding of data relationships and a strong command of SQL syntax

• Good understanding of data warehousing, data lake and database technologies, standards, and methodologies

• Report and queries tuning and performance

• Knowledge of data conversion techniques

• Experience with cloud based or self-service business intelligence platforms

The base salary range below represents the low and high end of the Alterra Mtn Co Shared Services Inc. salary range for this position. Actual salaries will vary and may be above or below the range based on various factors including but not limited to experience, education, training, location, merit system, quantity or quality of production, responsibilities, and regular and/or necessary travel. The range listed is just one component of Alterra Mtn Co Shared Services Inc.’s total compensation package for employees. Other rewards may include short-term and long-term incentives and many region-specific benefits.

Denver area base salary range: $85,000 – $128,000 per year

PHYSICAL REQUIREMENTS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to walk, talk, see, hear, and operate a computer and other office productivity machinery.

WORKING CONDITIONS

Indoor/Outdoor: While performing the duties of this job, the employee may be exposed to harsh and varying outside weather conditions.

Hazardous Materials/Noise: The noise level in the work place is usually moderate.

This job description is not an exhaustive list of all functions and responsibilities that an employee may be required to perform in this position. Alterra Mtn Co Shared Services Inc. and its affiliates reserve the right to modify, increase, decrease, suspend, and or eliminate any of the essential duties and/or the position in its entirety.

This job description is not an express or implied contract, guarantee, promise, or covenant of employment for any set term or duration, or for termination only for cause.

Employment with Alterra Mtn Co Shared Services Inc. or any of its affiliates is “at will” meaning either party may terminate the employment relationship at any time with or without cause and with or without notice.

This position is located in Colorado, and the work is primarily in Denver, CO and, as such, employment in this position is subject to the labor and employment laws of the state of Colorado.

Alterra Mtn Co Shared Services Inc. and its affiliates are equal opportunity employers and maintain drug-free workplaces. All employees and candidates are reminded that Alterra Mtn Co Shared Services Inc. and its affiliates adhere to all applicable labor and employment laws, and State, County, and City-specific labor and employment regulations, where applicable.