At a Glance
- Tasks: Support key BI initiatives and develop high-quality reporting and analytics solutions.
- Company: OEG, a leading energy solutions provider in the offshore industry.
- Benefits: Competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Join a collaborative team with excellent career advancement opportunities.
- Why this job: Make an impact by driving data-informed decisions in a dynamic energy sector.
- Qualifications: Experience in data analysis, Power BI, and strong Excel skills 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 in Aberdeen employer: OEG
OEG is an exceptional employer, offering a dynamic work environment in Dyce, Aberdeen, where innovation meets the energy sector. With a strong focus on employee growth, OEG provides opportunities for professional development through hands-on experience with cutting-edge BI tools and collaborative projects that drive data-informed decision-making. The company fosters a culture of inclusivity and teamwork, ensuring that every team member's contributions are valued and recognised, making it an ideal place for those seeking meaningful and rewarding careers in the offshore energy industry.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in Aberdeen
✨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 OEG!
✨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 Data Analyst at OEG.
✨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 OEG.
✨Apply Directly through Our Website
When you find a suitable opening like Data Analyst at OEG, 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 Data Analyst in Aberdeen
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 OEG, 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 OEG. 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 OEG
✨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 OEG!
✨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.
