Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create analytical datasets and optimise query performance for airline revenue reporting.
- Company: Join a leading airline analytics team focused on innovation.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Why this job: Make a real impact in the airline industry with your analytical skills.
- Qualifications: 5+ years in data modelling, expert SQL skills, and BI tool experience.
- Other info: Dynamic work environment with a focus on collaboration and career advancement.
The predicted salary is between 48000 - 72000 £ per year.
Our client requires an Intermediate BI/Analytics Engineer to build analytical data models and optimize query performance for business intelligence consumption.
Responsibilities:
- Design dimensional models for Revenue and Customer analytics
- Optimize Redshift query performance and table design
- Create aggregate tables and materialized views
- Build semantic layers for BI tool consumption
- Support Revenue UAT testing and validation
- Document business rules and calculations
Must Haves:
- 5+ years building analytical data models and marts
- Expert SQL and dimensional modeling skills
- Experience with Redshift performance optimization
- Background in business intelligence tools integration
- Understanding of airline metrics (RPK, ASK, load factor, yield)
Nice to Haves:
- Experience with Tableau or PowerBI
- Knowledge of revenue management concepts
- dbt experience
Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting in London employer: S.i. Systems
Contact Detail:
S.i. Systems Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting in London
✨Tip Number 1
Network like a pro! Reach out to folks in the airline industry or BI space on LinkedIn. A friendly chat can open doors and give you insights that job descriptions just can't.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your analytical data models and any projects you've worked on. This is your chance to shine and demonstrate your expertise beyond just words.
✨Tip Number 3
Prepare for interviews by brushing up on key airline metrics and BI tools. We want you to be ready to discuss how your experience aligns with their needs, especially around revenue analytics.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace Intermediate BI/Analytics Engineer to create analytical datasets for airline revenue and operations reporting in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with analytical data models and SQL skills. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about BI and analytics, and how your skills can help us optimise query performance and support revenue testing.
Showcase Your Technical Skills: Don’t forget to mention your experience with Redshift and any BI tools like Tableau or PowerBI. We love seeing candidates who can demonstrate their technical prowess and understanding of airline metrics!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at S.i. Systems
✨Know Your Data Models
Make sure you brush up on your knowledge of dimensional models and analytical data structures. Be ready to discuss how you've designed these in the past, especially in relation to revenue and customer analytics.
✨SQL Skills on Display
Since expert SQL skills are a must-have, prepare to showcase your abilities. Practice writing complex queries and optimising them for performance, particularly in Redshift. You might even be asked to solve a problem on the spot!
✨Understand Airline Metrics
Familiarise yourself with key airline metrics like RPK, ASK, load factor, and yield. Being able to discuss how these metrics impact business intelligence will show that you understand the industry and can contribute effectively.
✨Prepare for BI Tool Integration
If you have experience with Tableau or PowerBI, be ready to talk about it! Think of specific examples where you've integrated these tools into your workflow, and how they helped in visualising data for better decision-making.
