At a Glance
- Tasks: Design SQL data pipelines and Power BI dashboards for real-time project insights.
- Company: Confidential, leading engineering firm in the oil and gas sector.
- Benefits: Competitive salary, pension, private healthcare, flexible working, and annual bonus.
- Other info: Hybrid role with excellent growth opportunities in business systems.
- Why this job: Join a dynamic team and make impactful decisions with data-driven insights.
- Qualifications: Strong SQL and Power BI skills; passion for data analysis.
The predicted salary is between 40000 - 70000 € per year.
Salary: £40,000 – £70,000 depending on experience
Benefits: Pension, Private healthcare, Flexible working, Life insurance, Annual bonus
About our client
Our client is a well‑established, market‑leading engineering business operating internationally across the oil and gas sector. At their request, their identity is being kept confidential at this stage. Full details will be shared with shortlisted candidates.
Opportunity
This is not a standard reporting role. Our client is looking for a commercially minded analyst who is genuinely passionate about data – someone who sees insight as a tool for making better business decisions, not just producing charts for a weekly report. You’ll be embedded in a Projects team that delivers complex, bespoke, multi‑million‑pound solutions to international clients. You’ll own the data and analytics function for that team – building dashboards, interrogating cost data and helping project managers and commercial leads make smarter decisions throughout the project lifecycle. Longer term, there is a clear path into broader business systems work across finance, HR and operations – making this an exceptional opportunity for someone with ambition to grow.
What you'll do
- Design and maintain SQL‑based data pipelines and Power BI dashboards giving real‑time visibility of project costs, budgets and performance
- Analyse project cost data to identify risks, trends and savings opportunities – presenting findings in a way that drives action
- Work closely with project managers and commercial leads to understand their data needs and deliver solutions they’ll use
- Champion the use of AI tools to automate analysis, improve data quality and streamline reporting workflows
- Identify gaps in data capture and business process, and work with stakeholders to resolve them at source
- Document data models and definitions to ensure consistent, trustworthy insight across the organisation
Skills & experience
Essential
- Strong SQL – queries, joins, stored procedures
- Power BI – report design, DAX, data modelling
- Genuine passion for data and its commercial value
- Clear communicator with non‑technical stakeholders
- Analytical, cost‑conscious mindset
- Self‑starter who thrives with autonomy
Highly desirable
- Practical experience with AI tools in a business context
- Systems or business analysis experience
Working arrangements
This is a hybrid role based in Aberdeen. The client offers flexible working with a blend of office and remote working. Full details on working patterns will be discussed at interview stage.
Bright Purple is an equal opportunities employer. We are proud to work with clients who share our values of equality and diversity within our industry.
Business Systems Analyst employer: Bright Purple
Our client is an exceptional employer, offering a dynamic work culture that values innovation and collaboration within the engineering sector. With a strong focus on employee growth, this role provides a unique opportunity to engage with data in meaningful ways while contributing to high-stakes projects. The hybrid working model in Aberdeen allows for flexibility, ensuring a healthy work-life balance alongside competitive benefits such as private healthcare and an annual bonus.
StudySmarter Expert Advice🤫
We think this is how you could land Business Systems Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by researching the company and its projects. Show genuine interest in their work and be ready to discuss how your skills can help them achieve their goals. We want to see that passion for data shine through!
✨Tip Number 3
Practice your problem-solving skills! Be ready to tackle case studies or technical questions during interviews. We love candidates who can think on their feet and demonstrate their analytical mindset.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we’re always looking for talented individuals who are eager to make an impact in the business systems space.
We think you need these skills to ace Business Systems Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the skills and experience mentioned in the job description. Highlight your SQL and Power BI expertise, and don’t forget to showcase your passion for data!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you’re the perfect fit for this role. Share specific examples of how you've used data to drive business decisions and how you can bring that insight to our team.
Showcase Your Analytical Mindset:In your application, demonstrate your analytical skills by discussing past projects where you identified trends or risks. We want to see how you think and approach problem-solving!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It’s the best way for us to keep track of your application and ensure it gets the attention it deserves!
How to prepare for a job interview at Bright Purple
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be ready to discuss your experience with queries, joins, and stored procedures. You might even be asked to solve a problem on the spot, so practice makes perfect!
✨Showcase Your Passion for Data
This role is all about using data to drive business decisions, so be prepared to share examples of how you've used data in previous roles. Talk about specific projects where your insights led to actionable outcomes. Let your enthusiasm shine through!
✨Communicate Clearly with Non-Technical Stakeholders
Since you'll be working closely with project managers and commercial leads, practice explaining complex data concepts in simple terms. Think of examples where you've successfully communicated technical information to non-technical audiences.
✨Prepare for AI Tool Discussions
Given the emphasis on AI tools in this role, be ready to discuss any practical experience you have with them. Think about how you've used AI to automate processes or improve data quality, and be prepared to suggest ways these tools could benefit the company.
