Data Engineer

Denver, CO, United States

Year Round

AUTHENTICITY | EMPOWERMENT | COLLABORATION | PURPOSE

Alterra Mountain Company is a family of 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, Alterra Mountain Company exists to shape the future of mountain adventure.

What We Offer

Free Ikon Pass for all eligible employees + additional free skiing/riding privileges across the family of Alterra Mountain Company resorts for 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 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

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.

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.

Essential Duties

General Responsibilities

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

Required Qualifications

3+ years in a Data Engineer role

Strong knowledge of Snowflake data platform including performance tuning/scaling, governance, security and RBAC

Experience with Matillion or other push-down cloud ELT tools

Expert-level SQL skills

Familiarity with DevOps practices including change management and source control

Strong experience with data warehouse design and best practices

Experience with Python scripting to support data ingestion and manipulation

Familiarity with modern data visualization tools (PowerBI, Looker, Tableau)

Knowledge of modern cloud data eco-system

Track record of success in building new data engineering processes from sourcing the data to stakeholder delivery

Demonstrated ability to work across disparate teams to achieve consensus on key business decisions

Willingness to roll up your sleeves and fix problems in a hands-on manner

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 the Company'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: $100,000 to $140,000 per year.

Application Deadline: This position is open and still accepting applications.

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

Alterra Mountain Company and its affiliates are equal opportunity employers.

#J-18808-Ljbffr