BI Engineer Full Time

Job Title: BI EngineerLocation: London / HybridAbout Two CirclesTwo 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 behavior—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 OverviewWe 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 ResponsibilitiesDevelop 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.RequirementsRequired Skills and ExperienceEssentialStrong 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 ControlAzure DevOpsFabricBenefitsWhat 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