Apply for this job now

Business Intelligence (BI) Engineer

Denver, Colorado
Job Type
1 Aug 2022

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 Ikon Pass connects the most iconic mountains across North America, Australia, New Zealand, Japan and Chile, delivering authentic, memorable snow adventures. Alterra Mountain 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. Alterra Mountain Company s family of diverse playgrounds spans six U.S. states and three Canadian provinces: Steamboat and Winter Park Resort in Colorado; Palisades Tahoe, Mammoth Mountain, June Mountain and Big Bear Mountain Resort in California; Stratton and Sugarbush in Vermont; Snowshoe in West Virginia; Tremblant in Quebec, Blue Mountain in Ontario; 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. Alterra Mountain Company honors each destination s unique character and authenticity and celebrates the legendary adventures and enduring memories they bring to everyone.

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.


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
Flexible Time Off (FTO) policy 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)
Brand new Alterra Mountain Company office located in Denver s RiNo Art District neighborhood


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.

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


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

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..... click apply for full job details
Apply for this job now


  • Job Reference: 674008109-2
  • Date Posted: 1 August 2022
  • Recruiter: Alterra Mountain Company (HQ)
  • Location: Denver, Colorado
  • Salary: On Application
  • Sector: I.T. & Communications
  • Job Type: Permanent