AUTHENTICITY | PASSION | COMMUNITY | INNOVATION | ADVENTURE

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, 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

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 looking for a Senior Data Engineer with significant cloud database and data warehousing experience comfortable working in a hybrid technology environment to join our Unified Data Platform team. Core technologies include Snowflake, Matillion, SQL, Python, MS Azure; bonus for DevOps experience. This role will provide the opportunity to extend our current capabilities to capture and move data through our pipelines and develop the code for transforming the data to the aligned enterprise standard.

ESSENTIAL DUTIES

General Responsibilities

• Extend, develop and maintain Alterra’s strategic data capabilities

• Develop ongoing quality, monitoring and optimization capability within the entire data ecosystem

• Ensure that ETL jobs are scheduled, monitored and generate detailed logs to support ongoing diagnostics, exception processing, and audit trails for compliance

• Technical development, testing and deployment of data pipelines and target data warehouse schemas

• Contribute to the design, implementation, maintenance, enhancement, monitoring and governance of enterprise data repositories and processes

• Develop data processing code with a focus on consistency, reliability, and accuracy

• Profile inbound data and work with subject matter experts to ensure data is conformed to enterprise standards

• Contribute to the technical standards and data dictionaries

• Provide input to and execute development and enforcement of naming conventions for enterprise data assets including data models; database, schema, table, view, index, trigger, stored proc/function names; object level storage container names and paths; file names; and ETL scripts

• Ensure data ingestion processes catalog and tag arriving data and provide data life cycle and version management across landing, near-term archive, long term cold storage, and data destruction events based on corporate security, compliance, and data retention policies

• Ensure data pipelines provide appropriate access security, encryption (at rest and in motion) and data masking/stripping based on content and corporate security and compliance guidelines

• Ensure proper governance of enterprise data assets including data access at the subject and row level, enforcement of data privacy (PII), protection of financial data (PCI), and country specific treatment and regional storage of data

• Collaborate with teams that manage operational data masters and execute the design and development of data mastering processes

• Provide solutions for logical and physical enterprise data models; enterprise master data and reference data models; metadata models; and data catalogs. Support the governance and stewarding of master and reference data

• Lead ongoing development and code reviews of data acquisition, data movement, data cleansing, data transformation, data mapping, data quality screens, ETL jobs and schedules, and other ETL and data integration activities

• Work with IT Ops & Security to manage infrastructure, across on-premises and Azure deployments

• Ensure stable platforms and processes for software development, deployment, source control, and test/QA

• Develop CI/CD processes, tooling and methodology in conjunction with IT Ops, QA and development resources

• Automate and optimize processes to reduce manual workload

• Support and collaborate with multiple development and operational teams across Alterra

EXPERIENCE REQUIREMENTS

• Design and implementation of complex orchestrated ELT/ETL services, including sourcing data from various databases, cloud services, REST & SOAP APIs, and json/xml/csv/excel data formats

• Design and construction of information architectures that enable well-integrated transactional, collaborative and analytical systems.

• SDLC concepts including application lifecycle management, release management, and optionally continuous delivery

• Enterprise level data modeling at the logical and physical levels

• ETL job scheduling tools/techniques, job control, exception handling, logging, and monitoring

• ETL workflow design including change data capture, transformations, mapping, and data quality assurance

• Data Architecture, Data Management Services, Data Governance, Data Quality processes and Data Lifecycle

• Data cataloging and metadata management

• Master data management using mapping tables and/or commercial MDM tools

Additional experiences in the following areas are beneficial:

• Matillion ELT (or similar GUI based ETL/ELT tool), PowerBI, Tableau, R

• Database schema migration techniques

• Conceptual understanding of advanced analytic and machine learning data processing requirements

• Organizing data at scale including data lakes, data marts, and data warehouses

KNOWLEDGE, SKILL AND ABILITY REQUIREMENTS

• 5+ years software and/or data engineering experience

• 5+ years working with SQL in a data warehouse environment

• 5+ years building data platforms (architecture, storage, management, monitoring)

• 5+ years developing in a formal SDLC environment, using GitHub, Jira, Confluence or similar tools

• 5+ years building information architectures

• 5+ years data profiling & data mining

• 3+ years Python development; fluent

• 3+ years working with data and databases, SQL and Snowflake

• 1+ years hands-on experience with Azure

• Strong project management and organizational skills

• Collaborative and mentoring work style

• Strong analytic skills and hands-on attention to detail

• Mechanical tendencies and a curiosity to know how things work and how to make them better

• Passion for statistics & analytics, process engineering, and information management

• Loves being hands-on in a fast-paced, entrepreneurial environment

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: $118,000 - $177,000 per year