Business Intelligence & Reporting Analyst

Hotel Engine is a Denver-based travel tech company on a mission to radically simplify trip management for businesses. We’re not a cumbersome travel management company, nor an online price aggregator. We’re a powerful network that brings hotels and businesses together. Our members save time, money and effort in managing their lodging programs, and our partners get access to loyal, high-value business travelers. It’s a true win-win. Following a 2021 series B funding round at a $1.3 billion valuation, we achieved remarkable growth in 2022. We expect 2023 to be our best year yet.   Across our organization, we’re powered by exceptional talent. From our large Engineering and Product teams to Sales, Supplier Relations, Member Support, Data, Marketing and Operations, our team is forward-thinking, data-driven and customer-obsessed. We’re also a lot of fun — one of the many reasons we were named a Best Place to Work by Built In Colorado for the past four consecutive years.   We value our individuality, and we also understand that together, we thrive. Most importantly, we know we’re not for everyone! Complacency doesn’t live here. We’re focused on finding the right people who are energized by our culture and bring diverse experiences and backgrounds that will help us unlock our full potential. Click here to view our DNA , and if you like what you see, please read on! The Role:   As a Business Intelligence & Reporting Analyst , you will be responsible for conducting diverse data analysis in order to illuminate mission-critical business insights. Your conclusions will be used to identify, measure, and drive focus for our team's progress in areas across the business, including Sales, Marketing, Customer Support, and Product. The vital work you will spearhead is essential to the business, helping us establish the best path forward.   Reporting through Revenue Operations, you will be a solution-oriented partner to our go-to-market teams.     Essential duties and responsibilities:   Own the design, development, automation, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions. Educate and train users to drive the usage of reports. Simplify and manage the lifecycle of reports that are no longer necessary Use SQL to dive deeply into Hotel Engine’s business to respond to ad-hoc requests and provide relevant analysis Engage directly with internal business teams to determine and document KPIs and Business Intelligence requirements Standardize business and product metric definitions in curated and optimized datasets Recognize and adopt standard methodologies in reporting and analysis. Use data mining, model building, and other analytical techniques to drive insights. Learn and understand an increasingly broad range of Hotel Engine's data resources and know when, how, and which to use and which not to use based on technology and business context. Analyze data to shed light on key business questions and present on findings Build and maintain user-friendly documentation for data models, metrics, and reporting Drive continuous learning by proactively identifying marketing opportunity areas to increase conversion, translating them into structured analysis, generating actionable insights, and advocating for proposed next steps to key stakeholders   Here's what we're looking for:   Bachelor's Degree in one of the following areas: Finance, Marketing, Engineering, Economics, Mathematics/Statistics, or Data Science 3-5 years total relevant work experience   Proficiency in one or more of the following programming languages: SQL, R, VBA, Sass, Python, and/or experience in working with Google BigQuery. Advanced SQL skills, with experience using SQL to perform analysis, standardize queries, and build large-scale relational datasets Experience using Python to parse, structure, and transform data Advanced experience with Excel Experience with Salesforce and SFDC integrations Experience developing, deploying, and maintaining enterprise level reports using BI tools such as Tableau, Power BI, Looker, or other relevant technologies Experience with MPP databases such as Snowflake, Redshift, BigQuery, or other relevant technologies Strong quantitative reasoning, aptitude for discussing business performance in terms of data points, and ability to quickly learn new business lines, technology enablers, and data sources Outstanding verbal/written communication & data presentation skills, including effectively communicating with both business and technical teams, using email, Google Docs, Google Sheets, Google Slides, and Lucidcharts (or MS-equivalents Excel, Visio, and PowerPoint) Ability to prioritize and execute tasks in a high-pressure, constantly changing environment.  Strong knowledge of statistics (Hypotheses testing, Regression Analysis, Causality Analysis) Demonstrated ability to frame complex analytical problems and extract as well as articulate insights that led to tangible business results Your history and ability to engage with and influence the most senior decision-makers across the company and our customer and vendor ecosystems will add to your success in this role Cash compensation :   The base salary range for this role is $85,000 - $100,000/year. Final offer amounts are determined by multiple factors, including prior experience, expertise & may vary from the amount above. Remote Opportunities: This role is eligible for remote work within the U.S.   Hotel Engine Total Rewards Philosophy | We recognize that there is more to work than day-to-day responsibilities. Hotel Engine has been recognized on Built-in Colorado’s Best Places to Work list 3 years in a row (2020-2022) for our positive culture and robust growth opportunities.    As a company, we’re also dedicated to giving back to our greater community, and have comprehensive corporate social responsibility programs supporting community, social justice and environmental causes. In addition to a collaborative, high-performing team environment, we’re pleased to offer benefits including:     Competitive base salaries    Annual performance bonuses   Stock options for all associates + performance-based stock options    Insurance benefits including medical coverage (with a plan available at no cost to employees) + 100% paid dental and vision insurance    401(k) plan with a match program Unlimited PTO + 2 paid days each year to volunteer with your favorite non-profit   Paid parental leave and family medical leave   Hotel discounts through our exclusive platform   The ability to make a real impact in an incredibly fast-growing organization; you’ll never be just another cog in the wheel.