Power BI & Databricks Engineer
ago
Location
Waterloo, London
Hybrid
Salary
Competitive
Employment Type
Full Time
Experience Level
Entry
Junior
Mid
Senior
Expert
Our Client
Global Energy Company
SPECIALTY
Upstream/Downstream, Bio-Fuels, Integrated Gas, New Energies, Chemicals, Energy and Trading
INDUSTRY
Energy
Company Size
80000+ Employees
Aubay's Take
Our client is one of the Super Major global energy companies with who 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 changing fundamentally, 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 license to operate. In your role you will be expected to enact change and deliver value globally across business lines and geographies.
Benefits from Aubay
At Aubay UK, people are at the heart of our business. We offer a competitive remunerations 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.
25 Days Annual Leave
Work From Home Opportunities
Pension Scheme
Opportunities to Work Directly with our Client
Training Opportunities
Discount Holidays at I'Aero Chalet
Role Summary
Aubay UK is seeking a Power BI + Databricks 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.
- Knowledge of Microsoft Dynamics CRM, intermediate Python, or JavaScript.
- 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 bestpractice 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.