At a Glance
- Tasks: Develop and maintain advanced BI reports and dashboards using Power BI.
- Company: Join Two Circles, a leading Sports & Entertainment Marketing business.
- Benefits: Choose your own benefits package, enjoy generous holiday, and receive private healthcare.
- Other info: Dynamic team environment with opportunities for professional growth and fun team events.
- Why this job: Make an impact in sports and entertainment by delivering data-driven insights.
- Qualifications: Strong Power BI skills, DAX expertise, and SQL knowledge required.
The predicted salary is between 50000 - 65000 € per year.
Location: London / Hybrid
About Two Circles
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
Essential
- 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).
Desirable
- Git Source Control.
- Azure DevOps.
- Fabric.
Benefits
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).
- Mobile phone contribution.
- Sport Challenge contribution.
- Gym membership contribution.
- 2 x annual kit drops.
BI Engineer in London employer: Two Circles
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. Located in London, our hybrid work model offers flexibility alongside a comprehensive benefits package tailored to individual lifestyles, including generous holiday allowances, private healthcare, and opportunities for professional growth through regular performance reviews. Join us to be part of a dynamic team that partners with prestigious clients in the sports and entertainment industry, driving data-driven solutions that truly resonate with fans worldwide.
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 people in the industry, especially those working at Two Circles. 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 data models. This is your chance to demonstrate what you can do beyond just a CV.
✨Tip Number 3
Prepare for the interview by brushing up on DAX expressions and SQL queries. Be ready to discuss how you've tackled complex analytical challenges in the past.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative to connect directly with us.
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! Use it to explain why you're passionate about data and how you can contribute to our team. Keep it engaging and relevant to the job description.
Showcase Your Projects:If you've worked on any cool BI projects, don’t forget to mention them! We love seeing real examples of your work, especially if they demonstrate your problem-solving skills and creativity.
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 get all the updates directly from us!
How to prepare for a job interview at Two Circles
✨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, as well as any complex DAX expressions you've written. Practising with sample datasets can help you articulate your thought process during the interview.
✨Showcase Your SQL Savvy
Since SQL is a key requirement for this role, prepare to demonstrate your knowledge of DQL. Think of specific examples where you've used SQL queries to solve problems or extract insights. Being able to explain your approach to filtering, joining, and aggregating data will impress the interviewers.
✨Collaborate Like a Pro
This role involves working closely with data engineers and business teams, so be ready to discuss your collaboration experiences. Share examples of how you've gathered requirements and translated them into technical specifications. Highlighting your teamwork skills will show that you're a great fit for their dynamic environment.
✨Prepare Questions That Matter
Interviews are a two-way street, so come prepared with thoughtful questions about the company culture, team dynamics, and the specific challenges they face in BI. This not only shows your interest but also helps you gauge if the company aligns with your career goals.
