Year Round AUTHENTICITY | PASSION | COMMUNITY | INNOVATION | ADVENTURE Alterra Mountain Company is a family of 17 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 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; Schweitzer in Idaho; 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, 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 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) Flexible/hybrid workplace policy empowering employees to work from home while encouraging regular in-person collaboration in our dog-friendly company headquarters office located in Denver’s RiNo Art District neighborhood For information on Alterra Mountain Company’s Social Responsibility work including our Diversity, Equity, & Inclusion actions, please see our webpage at www.alterramtnco.com/social-responsibility. Among other resources, Alterra has Employee Resource Groups to support the BIPOC (Black, Indigenous, and people of color), disability, LGBTQIA2S , and women communities within our workforce. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily with or without reasonable accommodations. POSITION SUMMARY Alterra is hungry to convert our troves of data into actionable information. We need data engineering pros, all-stars, and evangelists to satisfy that hunger. We’re a target rich environment, with opportunities to transform the way we understand the performance of our operations across lines of business. As a Data Engineer, you’ll be a member of the team responsible for transforming our industry by delivering best-in-class data architecture solutions and driving more accurate data-driven decision making. We are looking for an experienced, innovative Data Engineer with the ability to deliver data solutions that are customer focused, easy to consume and create business impact. You will be part of a group of talented engineers that build data products and services to help solve complex problems in a simple way. WHAT YOU’LL BE DOING: Develop and optimize large-scale batch and real-time data pipelines that ingest structured and unstructured data from a variety of sources (API, DB, Cloud Store, etc) Manage incoming data requests and prioritize the highest value projects in an organized fashion Use your advanced SQL skills to craft cutting edge data solutions Tackle ambiguity and a growing level of complexity when it comes to our organization's data Communicate data-backed findings to a diverse constituency of stakeholders Other duties as assigned PROJECTS YOU’LL BE WORKING ON: Scaling our Azure based Snowflake data platform and Matillion environments Building data infrastructure that brings together tech, product, and operational functions and informs strategic decision-making at the executive level Building new data pipelines and integrations from the ground up YOU SHOULD HAVE: 3 years in a data engineer role Strong Knowledge of Snowflake DW Expert-level SQL skills Strong experience with ELT design and best practices Good experience in Python scripting Analyze production workloads and develop strategies to run Snowflake database with scale and efficiency. Experience in Snowflake performance tuning, capacity planning, handling cloud spend and utilization. Strong in Agile with work estimation and providing input to managers on resource and risk planning Familiarity with Data Visualization Tools (PowerBI, Looker, Tableau) Knowledge of Cloud Data eco-system Track record of success in building new data engineering processes and an ability to work through ambiguity Demonstrated ability to work across disparate teams to achieve consensus on key business decisions Exposure to Matillion or other cloud ELT tools Willingness to roll up your sleeves and fix problems in a hands-on manner Intellectual curiosity and research abilities Expertise in Azure specifically in compute, storage & security services is a plus Your own unique skills! If you do not meet 100% of the qualifications above, tell us why you would be a great fit for this role in your cover letter. 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. Alterra Mountain Company is a family of 15 iconic year-round destinations, including the world’s largest heli-ski operation, offering the Ikon Pass, the new standard in season passes. The company owns and operates a range of recreation, hospitality, real estate development, food and beverage, retail and service businesses. Headquartered in Denver, Colorado, with destinations across the continent, Alterra Mountain Company is rooted in the spirit of the mountains and united by a passion for outdoor adventure.