Analyst - Business Intelligence & Analytics

Inspirato; Colorado; Hybrid; USD 92,000 - 100,000; Full time

Job summary

Inspirato, based in Denver, Colorado, is seeking a Reporting to the Manager, BUSINESS INTELLIGENCE & ANALYTICS. The role supports Power BI reporting, data modeling, and analytics to advance a data-driven culture across the organization.

You will develop dashboards, write DAX measures, and collaborate with IT and business teams to deliver insights. Ideal candidates hold a bachelor’s degree or equivalent with 2–3 years of BI experience and strong communication skills.

Qualifications

• Knowledge of Microsoft Power BI, including proficiency in the DAX formula language.
• Ability to develop data extract, transform, and load (ETL) processes via Power Query, with a working knowledge of the M query language.
• Experience creating dimensional data models such as star and snowflake schemas.
• Proven experience using data visualization techniques to create meaningful reports and dashboards.
• Able to translate business requirements into elegant and user-friendly reports and dashboards.
• Eager to effectively articulate ideas and solutions of a complex/technical nature to a broad audience.
• Experience with Power Automate (preferred).
• Excellent written and spoken communication skills for interaction with leadership.
• Experience with SQL or Python (preferred).

Responsibilities

• Develop, enhance and maintain reports, dashboards and analytics in the Power BI platform.
• Conceive and author DAX measures to allow for meaningful calculations and insight.
• Perform parallel work such as data integration, ETL and data model development and enhancement to support this effort.
• Work with the I.T. and Data Architecture teams and contracted resources as required to deliver best-in-class business intelligence to business stakeholders.
• Engage with business stakeholders across functions to identify opportunities for analytics and reporting enhancements.
• Identify data sources and help the business prepare data for integration.
• Foster a data-driven culture through adoption of data management best practices.
• Communicate data defects and collaborate to remedy them.
• Stay up-to-date on Power BI and Microsoft Power Platform functionality.
• Contribute BI expertise to special projects as needed.

Skills

Power BI

DAX

Data visualization

ETL design

M query language

Analytics thinking

Communication

SQL

Python

Education

Bachelor’s degree or equivalent experience

Tools

Power Automate

Power BI

Job description

Reporting to: Manager, BUSINESS INTELLIGENCE & ANALYTICS

Location: Denver, CO or Remote

Employee Category: Salary, Exempt

About Inspirato

At Inspirato, we believe extraordinary travel should be effortless. We are a luxury destination club built on the pillars: Certainty, Care, and Value while delivering curated experiences that consistently exceed expectations for our members.

We are committed to promoting diversity, equity, and inclusion across everything we do — in our workplace, our business, our marketing, and the causes we support. Our team spans ages, abilities, cultures, races, religions, gender identities, and sexual orientations. We don’t just embrace those differences; we celebrate them.

The Role

Actively contributes to the business intelligence & analytics function. Develops, enhances, and maintains data queries, data models, reports, dashboards, and analytics, collaborating with business partners and customers as required. Advocates and fosters a data-driven approach to decision-making, furthering the evolution of the company’s business intelligence culture.

What You’ll Do

• Reporting & Analytics (80%)
  • Develop, enhance and maintain reports, dashboards and analytics in the Power BI platform.
  • Conceive and author DAX measures to allow for meaningful calculations and insight.
  • Perform parallel work such as data integration, ETL and data model development and enhancement to support this effort.
  • Work with the I.T. and Data Architecture teams and contracted resources as required to deliver best-in‑class business intelligence to business stakeholders.
• Business Engagement (10%)
  • Engage with business stakeholders across a wide range of functions to identify and capitalize on key opportunities for analytics and reporting enhancements.
  • Identify data sources and help the business to prepare data for integration.
  • Foster a data‑driven culture through the adoption and proliferation of data management best practices and advocate BI throughout the organization.
  • Communicate any observed defects in the data and work with the business to remedy.
• Professional Development (5%)
  • Advance and further develop knowledge of Power BI, DAX, Power Query and other BI and analytics tools through online resources and/or books, training courses, user groups or professional organizations.
  • Stay up‑to‑date on the latest Power BI and Microsoft Power Platform functionality and developments.
• Special Assignments & Projects (5%)
  • Contribute business intelligence and analytics expertise to special projects/assignments as required by the company’s expansion or ongoing operation.

Degree of Supervision Received

• Supervision: The incumbent performs a variety of routine work within established policies and procedures and receives detailed instructions on new projects and assignments. Makes decisions within area of responsibility.

Degree of Decision-Making Responsibility

• Position enforces company policies and procedures: The incumbent performs a variety of work within established policies and procedures, and ensures policies and procedures are followed.

Experience Required

• Must have prior knowledge of position/industry (2-3 years previous experience in same or related field)

Education Required

• Bachelor’s degree or equivalent experience

Qualifications

• Knowledge of Microsoft Power BI, including proficiency in the DAX formula language (required)
• The ability to develop data extract, transform, and load (ETL) processes via Power Query, with a working knowledge of the M query language (required)
• Experience creating dimensional data models such as star and snowflake schemas (required)
• Proven experience using data visualization techniques to create meaningful reports and dashboards (required)
• Able to translate business requirements into elegant and user-friendly reports and dashboards (required)
• Eager to effectively articulate to a broad audience ideas and solutions of a complex/technical nature (required)
• Experience working with and/or developing in Microsoft Power Automate (preferred)
• Excellent written and spoken communication skills and the ability to interact effectively with business unit leadership (preferred)
• Experience with programming languages such as SQL or Python (preferred)

Compensation

Salary: $92,000 - $100,000

We build compensation structures that reflect comparable market rates for companies of similar size, revenue, and geography, while recognizing individual experience, performance, and demonstrated capability.

About Us

Based in Denver, Colorado, Inspirato is a luxury travel company providing affluent travelers access to a managed and controlled portfolio of hand-selected vacation options to ensure world‑class service and certainty. Our portfolio features 100+ destinations, 350+ luxury homes, 50+ hotels and resorts, and custom travel experiences worldwide, available exclusively to our members.

At Inspirato, our mission is to inspire lasting memories and relationships by enhancing the way our members experience the world. Guided by our core values of care, courage, collaboration, and curiosity, we strive to deliver exceptional service and unique travel opportunities that create unforgettable experiences. Join us in our journey to enrich lives through meaningful connections and inspire a world of lasting memories!

Equal Opportunity Employer

We are passionately committed to promoting diversity, equity, and inclusion in all we do—within our workplace, through our business initiatives, in our marketing efforts, and in the causes we support. As an innovator in the industry, we recognize the valuable role diverse perspectives play in keeping us at the forefront of our business. Together, we span ages, abilities, cultures, races, religions, gender identities, and sexual orientations. We not only embrace those differences; we celebrate them.

Inspirato is an Equal Opportunity Employer. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We are dedicated to fostering an inclusive environment where everyone feels valued and respected.

Application deadline

All applications are due by 5pm MDT, November 23rd, 2026