At a Glance
- Tasks: Lead the design and development of BI solutions using Power BI and advanced data modelling.
- Company: Join Aubay UK, a dynamic player in the global energy sector.
- Benefits: Competitive salary, career support, and a chance to work on impactful projects.
- Other info: Fast-paced environment with opportunities for continuous improvement and career growth.
- Why this job: Transform the energy industry while working towards a net-zero future.
- Qualifications: Mastery in Power BI, strong SQL skills, and excellent communication abilities.
The predicted salary is between 36000 - 60000 £ per year.
Aubay UK is seeking a Power BI Engineer to join a Greenfield project within a leading global energy organisation. The successful candidate will work independently, set their own priorities, and act as a subject matter expert across multiple IT domains. This role is focused on the functional design and development of complex applications and infrastructure, requiring strong hands-on technical capability, excellent communication skills, and the ability to work closely with business stakeholders. Experience within trading or energy environments is advantageous but not essential.
Required Skills and Experience:
- Mastery-level expertise in Power BI, including advanced DAX, Power BI development, visualisation best practices, and Power BI Service administration.
- Experience with Snowflake and Azure Databricks as data platforms.
- Strong SQL capability for querying, modelling, and transforming complex dataset structures.
- Deep experience in data modelling, including semantic model design, star schemas, and enterprise BI architecture.
- Hands-on experience with Tabular Editor, DAX Studio, and Measure Killer for optimisation and model governance.
- Strong understanding of GitHub-based version control, CI/CD processes, and general DevOps patterns for BI environments.
- Excellent communication skills with the ability to lead discussions, influence stakeholders, and work closely with business teams.
Desired Skills and Experience:
- Experience with DBT, IBM Data Manager, or broader ETL/ELT practices.
- Exposure to trading environments or energy markets (advantageous but not required).
- Foundational understanding of data engineering concepts.
- Familiarity with governance topics such as Power BI licensing, capacity optimisation, and workspace administration.
Roles and Responsibilities:
- Lead the design, development, and optimisation of BI solutions using Microsoft Power BI, advanced DAX, and robust data modelling practices.
- Build and maintain high-quality semantic models, star schemas, and tabular structures that support scalable analytics.
- Act as SME across BI, reporting, and multiple IT/data domains, providing technical guidance and best-practice recommendations.
- Develop performant dashboards, reports, and datasets using tools such as Tabular Editor, DAX Studio, and Measure Killer.
- Design and enhance ETL/ELT workflows across Snowflake, Azure Databricks, DBT, and IBM Data Manager (where applicable).
- Collaborate with business stakeholders to gather requirements and translate them into effective reporting and data solutions.
- Support governance practices including version control (GitHub), CI/CD pipelines, Power BI Service administration, licence management, and capacity optimisation.
- Identify continuous improvement opportunities and advise on optimal use of applications, infrastructure, and reporting platforms.
- Provide leadership within the team and contribute to shaping technical standards in a Greenfield environment.
Aubay's Take: Our client is one of the Super Major global energy companies with whom we are working to power progress through cleaner energy solutions. You will have the opportunity to work in a challenging but rewarding environment that is fast-paced and fundamentally changing, and work towards transforming the business of a Super Major energy company to meet the ambition to be a net-zero emissions energy business by 2050, whilst delivering a world-class business case that has a strong societal licence to operate. In your role you will be expected to enact change and deliver value globally across business lines and geographies. At Aubay UK, people are at the heart of our business. We offer a competitive remuneration package which includes a range of benefits. You will receive continuous support from our dedicated team of Talent Acquisition Specialists who will support your career development and success during your assignment with our client.
Power BI Specialist in London employer: Aubay UK
Aubay UK is an exceptional employer, offering a dynamic work environment where innovation meets sustainability within the global energy sector. As a Power BI Specialist, you will not only contribute to transformative projects aimed at achieving net-zero emissions by 2050 but also benefit from a competitive remuneration package and robust career development support. Our culture prioritises collaboration and continuous improvement, ensuring that you thrive while making a meaningful impact in a fast-paced, Greenfield setting.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI Specialist in London
✨Tip Number 1
Network like a pro! Reach out to professionals in the energy sector or Power BI community on LinkedIn. Join relevant groups and participate in discussions to get your name out there and show off your expertise.
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills and understanding the latest trends in BI and data modelling. Practice explaining complex concepts in simple terms, as communication is key when working with stakeholders.
✨Tip Number 3
Showcase your work! Create a portfolio of your Power BI projects, including dashboards and reports you've developed. This will give potential employers a tangible sense of your skills and creativity.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that match your skills, and applying directly can sometimes give you an edge over other candidates. Plus, we’re here to support you every step of the way!
We think you need these skills to ace Power BI Specialist in London
Some tips for your application 🫡
Show Off Your Power BI Skills:Make sure to highlight your mastery in Power BI, especially your experience with advanced DAX and visualisation best practices. We want to see how you've used these skills in real-world scenarios, so don’t hold back!
Tailor Your Application:Take a moment to customise your application for this role. Mention any relevant experience you have with Snowflake, Azure Databricks, or even your understanding of data engineering concepts. This shows us you’re genuinely interested in the position.
Communicate Clearly:Since excellent communication is key for this role, make sure your application reflects that. Use clear and concise language to describe your experiences and how you’ve influenced stakeholders in past projects.
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 don’t miss out on any important updates during the process!
How to prepare for a job interview at Aubay UK
✨Master Your Power BI Skills
Make sure you brush up on your Power BI expertise, especially advanced DAX and visualisation best practices. Be ready to discuss specific projects where you've applied these skills, as this will show your hands-on capability and understanding of the tool.
✨Know Your Data Platforms
Familiarise yourself with Snowflake and Azure Databricks, as these are key platforms for the role. If you have experience with them, prepare to share examples of how you've used these tools in past projects to enhance your data modelling and ETL processes.
✨Communicate Like a Pro
Since excellent communication is crucial, practice articulating your thoughts clearly and confidently. Think about how you can influence stakeholders and lead discussions, perhaps by preparing a few scenarios where you've successfully collaborated with business teams.
✨Showcase Your Governance Knowledge
Be prepared to discuss governance topics related to Power BI, such as version control and capacity optimisation. Highlight any experience you have with GitHub or CI/CD processes, as this will demonstrate your understanding of best practices in BI environments.
