About the role
Kensington delivers the world’s most personal travel experiences. We bring to life each client’s desire to travel in a way that’s tailored specifically for them, in the company of local private guides who ensure that they enjoy the authentic best of their destination. The result is a unique journey rich in memories that last a lifetime!
We achieve this because of our extraordinary people, passionate experts with deep knowledge of their destinations. They are what enables us to deliver remarkable experiences in over 120 countries worldwide, and across each of our businesses – Private Touring, Cruises, Villas, Yachts, Expeditions, Ultraluxe Land, Private Jets, and Air.
To learn more about Kensington, visit kensingtontours.com.
Are you passionate about data and analytics that solve real business problems?
Do you enjoy building BI solutions that leaders trust to make critical decisions?
We’re looking for a BI Developer / Data Analyst to join our analytics team and play a key role in maintaining, enhancing, and scaling our business intelligence environment. This is a cross-functional, cross–business unit role, requiring strong technical foundations, business acumen, and the ability to balance multiple stakeholders and priorities.
What You’ll Do
- Develop and maintain SQL- and DAX-driven BI datasets that support enterprise reporting.
- Design, enhance, and maintain semantic data models using best practices (fact/dimension tables, star schemas, relationships).
- Build, publish, and maintain Power BI reports and datasets using Power BI Desktop and Fabric workspaces.
- Create and optimize DAX measures aligned to business KPIs.
- Troubleshoot scheduled refresh failures, native query issues, and data model errors to ensure reporting stability.
- Ingest and transform data from multiple sources using Power Query and SQL.
- Improve data visualizations for clarity, storytelling, and executive decision-making.
- Operate in a cross-functional, cross-BU environment, partnering with stakeholders across teams.
- Balance multiple priorities and competing requests while maintaining data quality and delivery standards.
- Translate business questions into actionable BI solutions that drive outcomes.
What You Bring (Must Have)
- 3–5 years of experience in BI development and data analytics.
- Strong critical thinking and analytical skills, including ability to distinguish correlation from causation, perform root cause analysis, and apply basic statistical methods to support business decision-making
- Strong SQL and DAX skills, with the ability to build and troubleshoot complex logic
- Solid understanding of dimensional modeling fundamentals: Fact and dimension tables, Star schemas, Data grain and relationships
- Hands-on experience with:
- Power BI Desktop
- Publishing datasets and reports
- Managing and troubleshooting scheduled refreshes
- Power Query for data ingestion and transformation
- Ability to use SSMS (or other tools) to extract and validate data using SQL, and to automate recurring data refreshes that keep BI semantic models up to date
- Strong business acumen and ability to connect analytics to business decisions
- Proven ability to manage multiple stakeholders and priorities in a cross-functional, cross-BU environment.
- Clear communication skills and comfort working with both technical teams and senior leaders.
Nice to Have
- Experience building Power BI Apps with dynamic, executive-facing content.
- Familiarity with Microsoft Fabric / Lakehouse concepts.
- Exposure to Medallion architecture (Bronze / Silver / Gold).
- Experience supporting transitions from SQL Server–based models to Fabric.
- Marketing analytics experience, including working with data from tools such as Google Analytics, Google Ads, or other digital marketing platforms, and translating performance data into actionable insights.
02 Aplyr's read
Kensington Tours crafts bespoke travel experiences with a focus on personalized itineraries and expert guidance, attracting professionals passionate about luxury travel and client satisfaction.
What's promising
- •Kensington Tours offers employees the chance to work on unique, customized travel experiences.
- •The company provides opportunities to engage with diverse cultures through its global travel offerings.
- •Employees can develop deep expertise in luxury travel and client relations.
What to watch
- •The niche focus on luxury travel may limit broader career opportunities.
- •High customization demands could lead to increased pressure and workload.
- •Limited public information about internal career progression and development opportunities.
Why Kensington Tours
- •Kensington Tours specializes in private, guided travel experiences with personalized itineraries.
- •The company employs expert local guides to enhance client travel experiences.
- •Focus on luxury and personalized service differentiates it from mass-market travel companies.
Aplyr’s read is generated by AI from public sources. Was it useful?
03 About Kensington Tours
Kensington Tours specializes in custom, private guided travel experiences around the world, offering personalized itineraries and expert local guides.
04 Similar roles