Alterra Mountain Company | Hiring | Business Intelligence (BI) Engineer | 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

The Business Intelligence Engineer of the Company’s data program will work closely with the Director, Data Engineering and the Company’s data team to develop enterprise reporting, underlying data structures and processes, and ad-hoc analysis. This role will contribute directly to the technical design, data transformation and organization, report development, and overall evolution of the reporting and analytics platform for the Company.

ESSENTIAL DUTIES

Reporting Development

• Work with departments throughout the business to understand their reporting requirements, document them concisely and formulate plans for executing on these.

• Work closely with the Senior Manager of Business Intelligence and other data team members to design and implement reporting and analytical capabilities.

• Own the development pipeline of new reporting content while continually working to refine the existing inventory of reports and data assets.

• Design advanced data queries – extract, validate, interpret and summarize the data. Translate this raw material into meaningful information that users can act on.

• Build and support best-of-breed dashboards, KPIs, and reporting solutions.

• Schedule, automate, and track reporting consumption.

• Seek creative solutions to maximize reporting output and reliability of the reporting platform itself.

• Create and refine visual representation and communication of complex data.

• Actively maintain the development backlog and prioritize revisions / fixes as needed.

• Work with the BI team to establish best practices and design patterns. Utilize sound development life cycle practices.

• Adhere to established processes of data team and document delivery of solutions.

Data Processing & Support

• Design, develop, optimize, and maintain the reference data processes downstream of staged data. This will primarily focus on enterprise data mart content but will also require contributions to the business logic used by Data Engineers staging data in our Unified Data Platform (UDP).

• Support Alterra’s Business Intelligence solutions as needed, both green field content as well as legacy, inherited tooling.

• Troubleshoot any issues as needed. Perform triage on incidents while communicating actively with stakeholders. Conduct root cause analysis to prevent repeated events / outages.

• Contribute to ongoing initiatives that generate trustworthy data and data governance.

• Perform planned maintenance as required, whether software upgrades on local systems or monitoring of upgrades in hosted environments that support enterprise reporting.

• Contribute to Alterra reference data, whether collecting and consolidating it from other sources or creating it from scratch in our Product Information Management (PIM) tool.

• Document work in progress and conform with the broader data team’s project planning and development methodology.

• Build disaster planning play book for reconstruction of reporting platform, rollback of discreet reports or database objects, user group security construction, etc.

• Conduct ongoing testing of content to ensure it remains timely, accurate and trustworthy.

• Contribute to the design and implementation of our Business Intelligence Competency Center (BICC).

Business Environment

• Foster partnerships with business users while collaborating on projects. Provide superior customer service to ensure our delivery exceeds expectations.

• Support end users with online & offline training resources, technical assistance, and hands-on instruction as needed.

• Ensure that adequate security procedures are developed and followed, to protect Alterra from potential data breaches. Conduct your own work with the highest standards for data security.

• Work diligently to service internal auditors (Accounting), GDPR related requirements (Legal) and general security (IT Sec) with any needs they have.

• Foster the enterprise-wide adoption of the tools, systems and processes that we design to support the organization’s information and raw data appetite.

• Achieve business goals by fostering innovation and coordinating the evaluation, deployment and management of current and future solutions.

Ad-hoc analysis

• Conduct periodic ad-hoc analysis to support corporate goals and objectives.

• Ensure high quality work – accurate, timely, repeatable (for revisions), and relevant.

• Provide support across departments by identifying and executing on analytical opportunities found in our raw data. Message opportunities upward as appropriate.

• Develop a logical, structured approach to work backward from business requirements or hypotheses and develop the needed data and analyses to effectuate change.

• Support peers in the broader Applications & Development team as they build intelligence informing their design decisions.

EDUCATION & EXPERIENCE REQUIREMENTS

Education & Experience

• Bachelor’s degree required – Computer Science, Information Systems, or related and relevant degree

• 3-5 years professional experience as a dedicated developer &/ analyst, operating in a data and reporting environment. A steady path of demonstrated conceptual thinking and analytical skills.

• 3-5 years developing reporting assets using one or more data visualization / reporting tools to tell stories. Preference will be given to Power BI, Tableau, Looker, or other nimble prototyping tools. We assert a “fast & light” methodology.

• Very strong experience writing SQL, including stored procedures and development of persistent data structures. This is the primary language you will use.

• 3+ years conducting data analysis in a multi-location, multi-lingual enterprise environment.

• 2-3 years of experience with data normalization and data de-normalization, with a pragmatic understanding of the pros / cons of each. You will need to bridge these simultaneously.

• 2-3 years of general exposure to data modeling and database architecture.

• 1-2 years of experience with a data modeling tool such as ER Studio, or ERDs in a database.

• Exceptional proficiency with Excel. We do not use this for reporting, but it is woven into the fabric of all analytics that our business partners conduct. Fluency is necessary.

• Strong analytical and research skills; accurate in your work, but not paralyzed by perfection.

• Experience with Python is not required but is definitely a plus.

• Basic experience with one or more enterprise ETL tools such as SSIS, Informatica, Ab Initio, Pentaho, or similar. Legacy systems are fed by these tools, and familiarity is helpful.

• Strong communication skills. Ability to translate technical concepts for non-technical audiences.

• Thrives in an environment that is fledgling and will pivot to capitalize on opportunities.

• A doer who gets the job done. Best practices are welcome, and encouraged, as long as you can complete the task on time or sooner.

KNOWLEDGE, SKILL AND ABILITY REQUIREMENTS

• 5+ years working with SQL, preferably MSSQL

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

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

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

• 3+ years building information architectures

• 3+ years data profiling & data mining

• 1+ years hands-on experience with Azure

• Business Process Management process and application experience

• Experience with Informatica & SSIS is a plus

• Experience with metadata applications and solutions

• Experience with master data management

• 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: $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