Business Intelligence Analyst

Pursuit; Banff; Hybrid; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Free access to Pursuit attractions

50% off for friends

Discounts on hotel stays, dining and 3

Job summary

Pursuit in Banff, Canada, seeks a Business Intelligence Analyst to analyze data, build dashboards, and drive insights for business decisions. You will validate data, refine pipelines, and translate business needs into technical requirements.

The role emphasizes SQL, Excel, Power BI, and Azure, requiring meticulous data work and collaboration with stakeholders across a distributed team. On-site with some remote work possible.

Qualifications

• BS or BA in Information Technology, Computer Science, Data Analytics or similar, or 4 years of relevant work experience.
• Minimum 2 years of data analysis or data management experience.
• Proficiency in SQL querying and relational databases (e.g., SQL Server, Oracle).
• Understanding of database concepts, data warehousing principles.
• Intermediate or advanced Excel skills.
• Strong attention to detail in data reporting and recommendations.
• Knowledge of accounting and finance data.
• Create and maintain technical documentation.

Responsibilities

• Partner with stakeholders to understand business processes, define requirements and perform data validation.
• Research data inquiries from business partners across reports and dashboards.
• Provide ongoing support for BI solutions, including enhancements, ad-hoc queries and bug fixes.
• Provide data-centric post-go-live support for new solutions.
• Author and maintain complex queries focusing on data accuracy and performance.
• Create and maintain technical documentation for BI solutions.
• Validate data entering the EDW and outbound integrations.

Skills

SQL querying

Excel

Data analysis

Attention to detail

Power BI

Azure

Documentation

Stakeholder collaboration

Business processes

SQL Server

Education

BS/BA in IT/CS/Data Analytics

Tools

Power BI

SQL Server Reporting Services

Azure

Job description

• Microsoft Azure, master data management/data governance

At Pursuit, we offer more than just a place to visit, we create opportunities for our guests to truly connect with iconic destinations. Our experiences include world-class attractions and distinctive lodges, all designed to highlight the unique beauty of each location. Beyond that, we offer thoughtfully crafted restaurants, retail, and transportation services that help our guests immerse themselves fully in the experience. What ties it all together are the friendly faces you’ll find along the way, the thoughtful amenities, and the delightful details that make every visit feel personal and unforgettable.

The Business Intelligence (BI) Analyst collects and analyzes data, identifies trends and anomalies – ultimately generating valuable insights. They will attend to enhancements and modifications in existing data pipelines and dashboards. This role also collaborates with stakeholders to develop analytical and technical requirements based on business processes. The ideal candidate possesses expertise in SQL and Excel, extreme attention to detail and a relentless desire to understand the data behind the processes.

What You’ll Do

• Partner with stakeholders to understand business processes, define requirements and complete data validation, helping to ensure the final solution meets or exceeds all business needs
• Research data inquiries from our business partners within applications, on reports and dashboards
• Provide ongoing timely support for existing BI solutions and processes, including enhancements, ad-hoc query and report requests, and bug fixes when needed.
• Provide data-centric post-go-live support for new solutions and applications
• Author and maintain complex queries, focusing on data accuracy, relevancy and performance
• Create and enhance technical documentation for all BI solutions
• Validate data coming into the Enterprise Data Warehouse (EDW) and outbound integrations from the EDW.

Required Qualifications, Skills & And Experience

• BS or BA in a field such as Information Technology, Computer Science, Data Analytics, or similar, or 4 years of relevant work experience
• A minimum of 2 years of experience in data analysis, information technology, or a related field of data management
• Proficiency in SQL querying and experience with relational databases (e.g., SQL Server, Oracle)
• Understanding of database concepts such as database structures, query languages, and data warehousing principles
• Intermediate (or Advanced) experience with simple analytics tools, such as Excel
• Possess a ridiculously high level of attention to detail, always meticulous and thorough throughout the data analysis process, ensuring accuracy in reporting and recommendations
• Knowledge of accounting and finance operations and associated data
• Create and maintain documentation, including technical specifications, user guides, and troubleshooting information
• Power BI, SQL Server Reporting Services, understanding of the attraction/hospitality industry,
• Microsoft Azure, master data management/data governance

CRITICAL COMPETENCIES FOR SUCCESS

• Strong analytical and problem-solving skills
• The ability to translate complex business processes into technical requirements
• Sound organizational, verbal and written communication skills
• Ability to establish and cultivate relationships with key business partners
• Demonstrated ability to work effectively in a team-oriented and collaborative environment, as well as independently, on tasks and projects
• Possess strong project and time management skills
• Ability to explain concepts to non-technical and technical colleagues
• Always maintain a strong attention to detail, with consistency during high-pressure and time-sensitive situations
• A passion for learning and curiosity, willingness to experiment with varied technologies and a drive to make our data and BI platforms more robust, resilient and reliable.
• Ability to work effectively in a distributed global team environment.

This list describes at a high level what this role does, but no job description can anticipate every single task, issue or project that could come up. Pursuit reserves the right to adjust, reduce, add, or change job tasks as needed for the success of the business.

To handle this job successfully, any person hired must be able to perform responsibilities as described. Pursuit will make any reasonable accommodation to help a person with disabilities perform their job. This job is based in an office environment though remote work may also be required. Some travel both domestically and internationally may be necessary, so a valid passport and driver’s license is required.

About Us

We’re more than a hospitality and attractions company. We connect people to iconic places through unforgettable and inspiring experiences; Our team members included.

Thoughtfully united by their unique power to inspire and invigorate, our collection of hotels and lodges, recreational attractions, ground transportation services, retail, food and beverage, sightseeing, tours, and travel products are tied together by iconic, destination-worthy locations in Alaska, Montana, the Canadian Rockies, Reykjavík and Costa Rica.

Pursuit is a publicly traded company listed on the New York Stock Exchange under the symbol PRSU. As a member of the S&P SmallCap 600 index, we specialize in attractions-led hospitality, consistently generating revenue and delivering value to our shareholders.

What will your work environment be like?

At Pursuit, our locations are more than just a place to work – it’s a space where you can bring your whole self, collaborate with talented teams across departments, and build lasting friendships. We believe in fostering an environment where work and play coexist, so whether you’re tackling projects or enjoying our many perks, you’ll feel supported and valued. With a variety of great benefits, we’re committed to ensuring that your time with us is as fulfilling as it is fun.

Our team shares a passion for adventure and an authentic desire to play host to the world. We are united by our connection to the people and places we’re lucky to call home. Our workforce is diverse. Our team members come here to embrace the extraordinary. To watch the sunrise and set each day in a place that, for many people, exists only in their imagination. To build career experience beside seasoned professionals a community of people who say ‘yes’ to adventure time and time again. To be a part of the #PursuitLife and live each day with purpose, turning moments into memories

PURSUIT PERKS

• Join an inclusive, global team and make life-long connections
• Enjoy free access to Pursuit attractions and 50% off for friends
• Get discounts on hotel stays, dining, and retail
• Access subsidized mental health and wellness resources

Equal Employment Opportunities Information

Pursuit is an Equal Opportunity Employer committed to diversity in the workplace.

We evaluate qualified applicants without regard to race, color, age, religion, gender, sexual orientation, disability, veteran status, and other protected characteristics.

Pursuit places a high value on diverse backgrounds and experiences, recognizing that they serve as catalysts for creativity and innovation.

We encourage individuals who are eligible to work in the country where the role is located to apply and join our inclusive team!

We are working to eliminate barriers for applicants and team members from equity-deserving groups.

If you can’t apply online or need accommodation during the application or hiring process, please contact our Talent & Acquisition Team at [e-mail].

We thank all candidates for their interest; however, please note that only applicants selected for further consideration will be contacted directly.