Analyst - Business Intelligence & Analytics

Inspirato•Remote, CO, CO

4d•$92,000 - $100,000

About The Position

The Analyst actively contributes to Inspirato’s Business Intelligence & Analytics function by developing, enhancing, and maintaining data queries, models, reports, dashboards, and analytics. The role collaborates with business partners and customers, advocates for data-driven decision-making, and helps advance the company’s business intelligence culture. The position focuses primarily on reporting and analytics, including developing Power BI reports and dashboards, authoring DAX measures, and performing data integration, ETL, and data-model development. It also engages business stakeholders to identify reporting opportunities, prepare data for integration, promote data-management best practices, and address data defects. The analyst is expected to continue developing BI skills and contribute expertise to special projects as needed. The role performs routine work within established policies and procedures, receives detailed instructions on new projects and assignments, and makes decisions within its area of responsibility. It also helps ensure company policies and procedures are followed. The position may be based in Denver, Colorado, or remotely.

Requirements

Two to three years of previous experience in the same or a related field.
Bachelor’s degree or equivalent experience.
Knowledge of Microsoft Power BI, including proficiency in the DAX formula language.
Ability to develop ETL processes using Power Query and working knowledge of the M query language.
Experience creating dimensional data models, including star and snowflake schemas.
Proven experience using data visualization techniques to create meaningful reports and dashboards.
Ability to translate business requirements into elegant, user-friendly reports and dashboards.
Ability to clearly articulate complex or technical ideas and solutions to a broad audience.

Nice To Haves

Experience working with and/or developing in Microsoft Power Automate.
Excellent written and spoken communication skills and the ability to interact effectively with business unit leadership.
Experience with programming languages such as SQL or Python.

Responsibilities

Develop, enhance, and maintain reports, dashboards, and analytics in Power BI.
Conceive and author DAX measures to support meaningful calculations and insights.
Perform data integration, ETL, and data-model development and enhancement.
Work with I.T., Data Architecture teams, and contracted resources to deliver business intelligence to stakeholders.
Engage stakeholders across business functions to identify opportunities for analytics and reporting enhancements.
Identify data sources and help prepare data for integration.
Encourage a data-driven culture by promoting data-management best practices and BI adoption throughout the organization.
Communicate observed data defects and work with the business to remedy them.
Develop knowledge of Power BI, DAX, Power Query, and other BI and analytics tools through self-directed learning, training, user groups, or professional organizations.
Stay up to date on Power BI and Microsoft Power Platform functionality and developments.
Contribute business intelligence and analytics expertise to special assignments and projects as required.