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 employer: Aubay UK
Aubay UK is an exceptional employer, offering a dynamic work environment in the heart of the West Midlands, where innovation meets operational excellence. With a strong focus on employee growth and development, we provide opportunities for career advancement and the chance to lead impactful data initiatives within the financial services sector. Our collaborative culture encourages teamwork and accountability, ensuring that every team member feels valued and empowered to contribute to our success.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI Specialist
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Aubay UK!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Power BI Specialist at Aubay UK.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Aubay UK.
✨Apply Directly through Our Website
When you find a suitable opening like Power BI Specialist at Aubay UK, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Power BI Specialist
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Aubay UK, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Aubay UK. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Aubay UK
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Aubay UK!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
