At a Glance
- Tasks: Transform complex data into insightful dashboards and reports using Power BI.
- Company: Join Riviera Travel, a leading company in curated travel experiences.
- Benefits: Enjoy a competitive salary, annual bonus, 27 days holiday, and remote work options.
- Other info: Opportunity for continuous learning and career growth in a friendly team.
- Why this job: Make an impact by driving data-driven decisions in a collaborative environment.
- Qualifications: 2-4 years experience in data analysis with strong Power BI and Excel skills.
The predicted salary is between 45000 - 55000 £ per year.
Competitive Salary - £45,000 - £55,000 (DOE) per annum
Annual bonus scheme – on-target bonus opportunity of 7.5%.
27 days holiday + bank holidays (with holiday buy and flexible bank holidays)
Remote working with occasional visits to the office
Riviera Travel is one of the UK’s leading escorted tour and river cruise companies, proudly creating high quality, carefully curated travel experiences for over forty years. We are passionate about exceptional customer experiences and are recognised for our award-winning service. As a growing business, we combine our love of travel with a strong focus on innovation, continuous improvement and modernising how we work. It is a friendly and collaborative place to build your career, where people care deeply about what they do and take real pride in delivering unforgettable holidays for our guests.
As the Data Analyst, you will turn complex data into clear, meaningful insight that helps drive the direction of the business. Working closely with the Senior Data Engineer, Platform team and stakeholders across the organisation, you will design and deliver high quality dashboards, reports and analytical solutions that bring data to life. Using Power BI, Excel and an Azure based data platform, you will uncover trends, highlight opportunities and enable smarter decision making at every level. This is a fantastic opportunity for someone who enjoys data storytelling and visualisation and wants to build deeper expertise within the Microsoft analytics ecosystem.
You will play an important part in strengthening a data driven culture, helping teams understand and trust the data they use, while continuously improving how insight is delivered across the business.
Key Responsibilities:
- Design, build, and maintain interactive dashboards and reports using Microsoft Power BI
- Perform data analysis using Microsoft Excel (advanced formulas, pivot tables, Power Query, Power Pivot, VBA) to support business reporting needs.
- Write and optimise SQL queries to extract, transform, and analyse data from Azure SQL Database and other Azure data sources.
- Develop and maintain Power BI semantic models (datasets), ensuring accurate relationships, measures, and calculated columns using DAX.
- Create standardised reporting templates and self-service analytics solutions for business stakeholders.
- Translate complex data into clear, visually compelling narratives that support strategic decision-making.
- Implement and manage Row-Level Security (RLS) in Power BI to ensure appropriate data access across business units.
- Gather and refine reporting requirements from stakeholders, iterating on dashboard designs to ensure outputs meet business needs.
- Conduct exploratory data analysis to identify trends, patterns, and anomalies across business datasets.
- Collaborate with stakeholders to define KPIs, metrics, and analytical requirements that align with business objectives.
- Validate data accuracy and consistency across reports and dashboards, flagging discrepancies to the Data Engineering team.
- Document data definitions, report logic, and analytical methodologies to support governance and knowledge sharing.
- Implement access controls and security models in line with data governance policies, ensuring auditability, documentation and regulatory compliance (GDPR).
- Monitor Power BI workspace performance, dataset refresh schedules, and report usage metrics.
- Work with the Platform Team to identify data quality issues, propose improvements to upstream pipelines, and refine data models.
- Stay current with new features in Power BI, Excel, and the broader Microsoft analytics stack to continually improve reporting capabilities.
Your Expertise:
- 2–4 years of experience in a data analyst, business analyst, or similar analytical role
- Experience working with Microsoft Power BI and Excel in a professional environment
- Certifications such as Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Certified: Azure Data Fundamentals (DP-900), Microsoft Certified: Azure Enterprise Data Analyst Associate (DP-500), or Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) advantageous
- Strong proficiency in Microsoft Power BI, including data modelling, DAX, Power Query (M), and report/dashboard design
- Advanced Microsoft Excel skills, including pivot tables, VLOOKUP/XLOOKUP, INDEX/MATCH, Power Query, Power Pivot, and complex formulas
- Proficiency in SQL for data extraction, manipulation, and analysis
- Experience working with Azure data services such as Azure SQL Database, Azure Data Lake, or Azure Synapse Analytics
- Strong analytical and problem-solving skills with the ability to interpret data and present findings to non-technical audiences
- Desirable experience with Python or R for data analysis and automation.
- Familiarity with Azure Data Factory and understanding of ETL/ELT concepts.
- Knowledge of statistical analysis techniques and their practical application.
- Exposure to Azure DevOps for version control and collaborative development of Power BI reports.
- Exposure to Microsoft Fabric, including lakehouses, data pipelines, and Fabric-integrated notebooks.
- Git-based version control and collaborative development practices with CI/CD concepts for analytic artefacts.
Data Analyst (Power BI) employer: Riviera Travel
Riviera Travel is an exceptional employer that values innovation and collaboration, offering a competitive salary and a generous benefits package including 27 days of holiday and a remote working option. With a strong focus on employee growth and a culture that prioritises teamwork and pride in delivering unforgettable travel experiences, this role as a Data Analyst (Power BI) provides a unique opportunity to contribute to a data-driven environment while developing expertise in the Microsoft analytics ecosystem.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst (Power BI)
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and data analysis projects. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common data analyst questions and scenarios. Be ready to discuss your experience with SQL, Excel, and Power BI, and how you've used these tools to drive business insights.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are genuinely interested in joining our team at Riviera Travel.
We think you need these skills to ace Data Analyst (Power BI)
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Analyst role. Highlight your experience with Power BI, Excel, and SQL, and don’t forget to showcase any relevant certifications. We want to see how your skills align with what we’re looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to tell us why you’re the perfect fit for this role. Share your passion for data storytelling and how you’ve used analytics to drive business decisions in the past. Keep it engaging and personal!
Showcase Your Projects:If you’ve worked on any cool projects using Power BI or Excel, make sure to mention them! We love seeing real examples of your work, so include links or descriptions that highlight your analytical skills and creativity.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re genuinely interested in joining our team at Riviera Travel!
How to prepare for a job interview at Riviera Travel
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, Excel, and SQL. Brush up on your DAX skills and be ready to discuss how you've used these tools in past projects. Prepare examples of dashboards or reports you've created that showcase your ability to turn complex data into clear insights.
✨Understand the Business Context
Research Riviera Travel and understand their business model and customer experience focus. Think about how your role as a Data Analyst can contribute to their goals. Be prepared to discuss how data-driven decisions can enhance their services and improve customer satisfaction.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical data problems or analyse specific datasets. Practice explaining your thought process clearly and logically. Use the STAR method (Situation, Task, Action, Result) to structure your answers and demonstrate your analytical skills.
✨Showcase Your Collaborative Spirit
Since the role involves working closely with various teams, be ready to talk about your experience collaborating with stakeholders. Highlight instances where you gathered requirements, iterated on designs, or helped non-technical audiences understand data insights. This will show that you value teamwork and communication.
