At a Glance
- Tasks: Develop and optimise BI solutions, creating impactful reports and dashboards.
- Company: Join a leading Sports & Entertainment Marketing business with global clients.
- Benefits: Customisable benefits package, generous holiday, and private healthcare options.
- Other info: Dynamic team culture with regular team days and excellent career growth.
- Why this job: Make a real impact in sports and entertainment through data-driven insights.
- Qualifications: Proficient in Power BI, DAX, SQL, and data modelling.
The predicted salary is between 45000 - 55000 € per year.
Two Circles is a leading Sports & Entertainment Marketing business focused on growing audiences and revenues by understanding fans deeply. We partner with clients worldwide, including the English Premier League, Red Bull, UEFA, VISA, the NFL, Nike, and Amazon, to help them comprehend and influence fan behaviour—how fans spend, attend events, engage with content, and more. With almost 1000 team members across 15 offices, we deliver cutting-edge data-driven solutions to sports and entertainment organizations globally.
Role Overview
We are seeking an experienced BI Engineer to join our dynamic team. In this role, you will develop, optimize, and maintain business intelligence solutions, supporting stakeholders with actionable insights. You will collaborate closely with data engineers, analysts, and business teams to ensure data integrity and empower data-driven decision-making.
Key Responsibilities
- Develop and maintain advanced BI reports and dashboards primarily using Power BI.
- Design and optimize data models and DAX expressions to meet complex analytical requirements.
- Collaborate with data engineering teams to integrate data pipelines and ensure data quality.
- Perform data validation, troubleshooting, and quality assurance across BI platforms and Excel dashboards.
- Participate in requirements gathering and translate business needs into technical specifications.
- Support knowledge sharing and training within the analytics team.
Requirements
Required Skills and Experience
- Strong proficiency in Power BI report development and data modeling.
- Advanced skills in writing DAX expressions for complex calculations.
- SQL Queries, specifically DQL (Data Query Language: select, filters, joins, aggregations).
- Data Modelling (Star Schema, Kimball methodology).
- Git Source Control.
- Fabric.
What can we offer you?
We offer a benefits package to suit you and your lifestyle! Out of a core monthly budget, you can choose your own comprehensive benefit package.
- Renowned Team Days often throughout the year.
- Summer Away Days.
- 23 standard days of holiday (+1 Birthday, +1 Well-being Day, +1 'Big Life Event', and +1 Admin Day), closure of office over Christmas (plus Bank Holidays).
- Discretionary Bonus based on company performance.
- Performance Reviews every 6 months with discretionary salary increases.
- Private healthcare (Vitality) and/or Health Care Plan (Medicash).
BI Engineer in London employer: Two Circles Ltd
Two Circles is an exceptional employer that fosters a vibrant and collaborative work culture, where innovation thrives and employees are empowered to make impactful contributions. With a focus on personal and professional growth, we offer tailored benefits packages, regular team-building events, and generous holiday allowances, ensuring a healthy work-life balance. Join us in our London office to be part of a dynamic team that partners with prestigious clients in the sports and entertainment industry, driving data-driven solutions that shape the future of fan engagement.
StudySmarter Expert Advice🤫
We think this is how you could land BI Engineer in London
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those at Two Circles or similar companies. A friendly chat can open doors and give you insights that a job description just can't.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI reports and DAX expressions. This is your chance to demonstrate what you can do beyond just a CV—let your work speak for itself!
✨Tip Number 3
Prepare for the interview by brushing up on SQL queries and data modelling techniques. Be ready to discuss how you've tackled complex analytical challenges in the past—this will show you're the BI Engineer they need.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our awesome team at StudySmarter.
We think you need these skills to ace BI Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the BI Engineer role. Highlight your experience with Power BI, DAX expressions, and SQL queries. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share your passion for data and how you can contribute to our team. Be sure to mention any relevant projects or experiences that showcase your BI expertise.
Showcase Your Technical Skills:Don’t hold back on showcasing your technical skills in your application. Mention your proficiency in data modelling and Git source control. We love seeing candidates who are confident in their abilities!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Two Circles Ltd
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with report development and data modelling, and have examples of your work handy. This will show that you’re not just familiar with the tool, but that you can leverage it effectively to deliver insights.
✨DAX is Your Best Friend
Since advanced DAX expressions are crucial for this role, practice writing complex calculations. Prepare to explain how you've used DAX in past projects to solve specific problems. This will demonstrate your technical prowess and problem-solving abilities.
✨SQL Queries Are Key
Get comfortable with SQL queries, especially DQL. Be prepared to discuss how you've used SQL to extract and manipulate data in previous roles. You might even be asked to write a query on the spot, so practice makes perfect!
✨Collaboration is Essential
This role involves working closely with data engineers and business teams, so be ready to talk about your collaborative experiences. Share examples of how you’ve gathered requirements and translated them into technical specifications, as well as how you’ve ensured data quality in your projects.
