At a Glance
- Tasks: Support key BI initiatives and develop high-quality reporting using Power BI, SQL, and Excel.
- Company: Join OEG, a leader in energy solutions for the global offshore industry.
- Benefits: Competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career development.
- Why this job: Make an impact by driving data-informed decisions in a dynamic energy sector.
- Qualifications: Experience in data analysis and strong skills in Power BI and Excel required.
The predicted salary is between 35000 - 45000 £ per year.
Company Overview
OEG is a leading energy solutions business, providing mission critical infrastructure assets and services to the global offshore energy industry. Through our specialist divisions - topside, marine, subsea, cables, logistics and industrials, we are a pivotal link in the global offshore energy project chain, ensuring our customers’ projects are delivered safely, reliably and efficiently. We are currently seeking a Data Analyst to join our Group Division.
Location: Dyce, Aberdeen, United Kingdom.
Core Purpose
- Support the delivery of key BI and IT initiatives, including master data management, data warehousing, and analyst capability development programmes.
- Develop and maintain high-quality reporting, analytics, and data solutions using Power BI, DAX, SQL, and Excel.
- Work closely with stakeholders across the business to understand operational and commercial challenges, translating requirements into actionable insights and solutions.
- Build strong business knowledge and trusted relationships to evolve into a strategic business partnering role, driving data-informed decision making across the organisation.
Key Responsibilities and Accountabilities
- Partner with stakeholders across OEG business units to understand reporting requirements, business processes, and performance challenges, translating these into effective data and reporting solutions.
- Translate business questions and requirements into clear analytical outputs, reporting specifications, and practical data-driven solutions.
- Develop, enhance, and maintain Power BI dashboards and reports that deliver actionable insights and support informed decision-making across the Group.
- Design, develop, and maintain robust data models, relationships, measures, and calculations using DAX and Power Query to support accurate and scalable reporting.
- Utilise Excel for data analysis, modelling, reconciliation, and the creation of stakeholder-facing reports and outputs where appropriate.
- Provide insightful analysis and commentary to help stakeholders understand business performance, identify trends, and assess risks and opportunities.
- Support the standardisation of reporting, KPI definitions, and business metrics to ensure consistency and alignment across the Group.
- Identify and support the resolution of data quality issues, inconsistencies, and reporting gaps to improve the reliability of business information.
- Collaborate with data engineers, IT, finance, and operational teams to source, transform, and integrate data from multiple systems and platforms.
- Provide guidance and support to end users to drive adaptation and effective use of Power BI and other reporting tools across the business.
- Identify and implement opportunities to automate manual reporting processes, reduce duplication, and improve overall reporting efficiency.
- Act as a bridge between technical teams and business stakeholders, ensuring analytics solutions are both technically robust and commercially relevant.
Skills and Experience
Required
- Experience in data analyst, BI analyst, reporting analyst, or similar role within a data driven environment.
- Strong experience designing, developing and maintaining reports and dashboards in Power BI.
- Good working knowledge of DAX, Power Query, and core data modelling principles.
- Strong Excel skills, including data analysis, advanced formulas, lookups, pivot tables, and data validation.
- Ability to gather, clarify, and document business requirements effectively, translating them into clear technical specifications.
- Strong analytical and problem-solving skills with excellent attention to detail and a focus on data accuracy.
- Ability to translate data into clear insights, actionable recommendations, and meaningful business outcomes.
- Confident communicator with the ability to engage effectively with both technical and non-technical stakeholders.
- Proactive, curious, and commercially aware mindset with a strong interest in understanding business performance drivers.
Desirable
- Experience within oil and gas, renewables, offshore services, energy, engineering, logistics, project-based, or other asset-intensive industries.
- Familiarity with ERP, finance, project management, CRM, asset management, or other operational business systems.
- Experience writing SQL queries to extract and analyse data.
- Understanding of data warehousing concepts, ETL processes, and modern data platforms.
- Experience supporting senior management reporting, KPI packs, and performance review processes.
- Knowledge of Python, APIs, Microsoft Fabric, Azure, SharePoint, or Power Automate is advantageous.
Qualifications
A minimum of a bachelor’s degree (or equivalent) in a relevant subject such as Computing, Data Science, or a related discipline.
We are an equal opportunity employer committed to a fair and inclusive recruitment process for all applicants.
Data Analyst employer: OEG
OEG is an exceptional employer, offering a dynamic work environment in Dyce, Aberdeen, where innovation meets collaboration. As a Data Analyst, you will have the opportunity to engage with diverse stakeholders, driving data-informed decision-making while benefiting from a culture that prioritises professional growth and development. With a commitment to inclusivity and a focus on delivering impactful solutions in the offshore energy sector, OEG provides a rewarding career path for those looking to make a meaningful contribution.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Network like a pro! Reach out to current employees at OEG or in the energy sector on LinkedIn. Ask them about their experiences and any tips they might have for landing a role as a Data Analyst. You never know who might help you get your foot in the door!
✨Tip Number 2
Prepare for interviews by brushing up on your Power BI skills. Create a portfolio of dashboards you've built, showcasing your ability to turn data into actionable insights. This will not only impress interviewers but also give you confidence when discussing your work.
✨Tip Number 3
Practice your communication skills! As a Data Analyst, you'll need to explain complex data findings to non-technical stakeholders. Try explaining your past projects to friends or family to ensure you can convey your insights clearly and effectively.
✨Tip Number 4
Don't forget to apply through our website! We want to see your application directly, and it gives you a better chance to stand out. Plus, keep an eye on our careers page for any new opportunities that pop up!
We think you need these skills to ace Data Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Analyst role. Highlight your experience with Power BI, DAX, and SQL, and showcase any relevant projects that demonstrate your analytical skills. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and how your skills align with our mission at OEG. Be sure to mention specific examples of how you've tackled challenges in previous roles.
Showcase Your Analytical Skills:In your application, don’t just list your skills—show us how you've used them! Include examples of reports or dashboards you've created, and how they helped drive decision-making. We love seeing real-world applications of your expertise.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you’re considered for the role. Plus, it’s super easy to do—just follow the prompts!
How to prepare for a job interview at OEG
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, DAX, SQL, and Excel. Brush up on your skills and be ready to discuss specific projects where you've used these tools to solve problems or create reports. Being able to demonstrate your technical expertise will impress the interviewers.
✨Understand the Business Context
Familiarise yourself with OEG's operations and the offshore energy industry. Research their recent projects and challenges they might face. This knowledge will help you tailor your answers and show that you can translate data into actionable insights relevant to their business.
✨Prepare for Scenario-Based Questions
Expect questions that ask how you would handle specific data challenges or stakeholder requests. Think of examples from your past experience where you successfully gathered requirements, developed reports, or resolved data quality issues. Use the STAR method (Situation, Task, Action, Result) to structure your responses.
✨Show Your Communication Skills
As a Data Analyst, you'll need to bridge the gap between technical and non-technical stakeholders. Practice explaining complex data concepts in simple terms. Be prepared to discuss how you've effectively communicated insights in previous roles, as this will highlight your ability to engage with diverse teams.
