Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create impactful Power BI dashboards and data models to drive business insights.
- Company: Join JCDecaux, a diverse and inclusive employer committed to your growth.
- Benefits: Flexible working options, supportive culture, and opportunities for professional development.
- Why this job: Make a real difference by transforming data into actionable insights.
- Qualifications: 4-7 years in BI/Analytics with strong Power BI and SQL skills.
- Other info: Collaborative environment where creativity and diversity are celebrated.
The predicted salary is between 28800 - 48000 £ per year.
Deliver enterprise-grade Power BI dashboards, data models and reporting assets that provide clear, actionable insights aligned with business needs.
Responsibilities
- Design, develop and maintain Power BI reports, dashboards and interactive analytics.
- Build robust data models (star schemas, semantic layers, DAX measures) to ensure high performance and reusability.
- Translate business questions into metric definitions, KPIs and validated datasets.
- Collaborate with Data Engineering to ensure data availability, quality and performance.
- Conduct data validation, reconcile dashboards against source systems, and document assumptions.
- Optimise report performance (aggregations, query folding, incremental refresh).
- Support self-serve BI enablement through documentation, training and data-literacy support.
- Ensure BI assets follow visual design best practices and accessibility standards.
A Little Bit About You — Required Skills & Experience
- 4-7 years in BI/Analytics with strong Power BI experience.
- Expertise in DAX, Power Query (M), data modelling and designing semantic layers.
- Strong SQL; good understanding of ETL/ELT and data pipelines.
- Comfortable engaging with business teams to clarify requirements and deliver insights.
- Experience in high-volume or multi-system data environments.
- Advantage: Azure DataBricks, Fabric and Purview familiarity.
We believe in building a diverse and inclusive culture and positive employee experience. We are One Team, more than just ourselves. We are customer first, we understand, and help solve our customers' problems. We Test & Learn, we are empowered to learn and grow, unafraid of change. We choose to care, we are committed to doing the right thing, the right way. It's really important to us that we give as much to our colleagues as they give to us. Our latest Belonging Survey showed that our colleagues feel valued and listened to as we continue to build an environment where everyone can thrive, grow, belong and be their authentic selves. We believe that diversity of thought, experience and background provides the platform for great creativity. We are committed to equal employment opportunities regardless of race, colour, ancestry, religion, national origin, sexual orientation, age, citizenship, marital status, disability or gender identity. Many of our colleagues work flexibly in many different ways. Please talk to us at interview about the flexibility you need. We can't promise to give you exactly what you want, but we do promise not to judge you for asking.
Recruitment Process
- You find or get sent this job advert, read it, and feel like you'd be a great addition to the JCD family.
- You send in your application to let us know you're interested.
- We see your application, get excited, and give you a call.
- You'll meet us twice; depending on the role, you may prepare a presentation and we'll get to know each other.
- You'll begin your journey with us; we're excited to support and develop you throughout your career.
Business Intelligence Analyst in City of Westminster employer: myGwork - LGBTQ+ Business Community
Contact Detail:
myGwork - LGBTQ+ Business Community Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst in City of Westminster
✨Tip Number 1
Network like a pro! Reach out to current or former employees at JCDecaux on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by brushing up on your Power BI skills. Be ready to showcase your expertise in DAX and data modelling. We want to see how you can turn complex data into clear insights!
✨Tip Number 3
Don’t just talk about your experience; bring examples! Have a portfolio of your best Power BI dashboards ready to share. This will help us visualise your skills and how you can contribute to our team.
✨Tip Number 4
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 diverse and inclusive team.
We think you need these skills to ace Business Intelligence Analyst in City of Westminster
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Power BI and DAX. We want to see how your skills align with the responsibilities listed in the job description, so don’t hold back!
Showcase Your Projects: If you've worked on any impressive BI projects, include them! We love seeing real examples of your work, especially if they demonstrate your ability to create actionable insights and robust data models.
Be Clear and Concise: When writing your application, keep it straightforward. We appreciate clarity, so make sure your points are easy to understand and directly related to the role. Avoid jargon unless it’s relevant to the job!
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, we can’t wait to hear from you!
How to prepare for a job interview at myGwork - LGBTQ+ Business Community
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI, especially DAX and Power Query. Brush up on your data modelling skills and be ready to discuss how you've built robust data models in the past. Prepare examples of dashboards you've created that provided actionable insights.
✨Understand the Business Needs
Before the interview, think about how you can translate business questions into metrics and KPIs. Be prepared to discuss how you’ve engaged with business teams to clarify requirements and deliver insights that align with their needs.
✨Showcase Your Problem-Solving Skills
JCDecaux values a customer-first approach, so come ready with examples of how you've solved complex data issues or optimised report performance. Highlight any experiences where you’ve had to reconcile dashboards against source systems or validate data.
✨Emphasise Collaboration and Flexibility
Since collaboration with Data Engineering is key, share instances where you’ve worked closely with other teams. Also, don’t hesitate to discuss your flexibility needs during the interview; they appreciate open communication and want to ensure you feel comfortable.
