Cookies — it's your choice

At Bright Network we use cookies and similar technologies to help deliver you the best possible experience. Some are necessary to help our website work properly and can't be switched off, and some are optional but support Bright Network in building and running the service that we provide to you.

Data we store

You can find out more in our privacy policy at any time by going to the link in our footer.

  1. Home
  2. Graduate Jobs
  3. Technology & IT Infrastructure
  4. Business Intelligence Analyst Aberdeen 2022
Lock Applications for this job are now closed
Closing soon

Petrofac is a respected international service provider to the energy industry, with a diverse client portfolio including many of the world’s energy companies.

We design, build, manage and maintain infrastructure for the energy industries. Our comprehensive and tailored service offering covers each stage of the project life cycle and a variety of commercial models, giving our clients the flexibility they need.

Diversity & Inclusion

We recruit, reward, and develop our people based on merit regardless of race, nationality, religion, gender, age, sexual orientation, marital status, or disability. Petrofac is striving to develop a diverse and inclusive culture where everyone can contribute. Applications are also welcomed from candidates who want to discuss flexible working or job-sharing requests.

Main purpose of the role

Developing and maintaining Power BI reports as per design governance, ensuring consistency in theme, design and visualisations is achieved to deliver a meaningful report. Experience working with big data models in Power BI or tabular would be advantage.

Key accountabilities

  • Understanding current IT and data landscape, gathering reporting needs from the business, communicating recommendations and solutions. 
  • Utilising TSQL, AAS and Power BI skills to interpretate the data model and create dax measures when required, switching between technical and business friendly terminology to suit the audience
  • Writing complex dax measures and making recommendations to achieve the business brief while creating best practice data schema’s to store the transformed data
  • Prioritising work to support a range of Power BI and data queries and troubleshooting
  • Collaborating closely with Data Engineers, discussing solutions and troubleshooting data
  • Complying with IT PMO process ensuring completed tollgate documentation and obtained approvals
  • Ensuring high quality documentation is created and maintained to reference the data logic and transformation undertaken
  • Proactively share new ideas and innovative solutions to enhance the Data Science process and service offering
  • Prioritising internal and external requests, ensuring delivered work meets a high standard and is aligned with Data Science strategy
  • Complying with Data Science governance and change management process

Skills & Experience

  • Reporting Tools, Power BI / Tableau (moderate/advance level)
  • Microsoft Office Suite
  • Analysis Services (advantageous)
  • Power Automate and Power Apps
  • TSQL (advantageous)
  • Knowledge of the Microsoft BI product stack (SSIS, SSMS, and SSRS)
  • Azure knowledge (desirable)

Compensation & Benefits

  • A competitive base salary 
  • Pension Scheme – Standard Life - 3.5% Employee / 7% Employer
  • UK Healthcare – AXA 
  • Employee Assistance Programme (EAP)
  • Permanent Health Insurance (PHI)
  • Personal Accident insurance 
  • Life Assurance (3x Base Salary)
  • Cycle To Work Scheme
  • Share Incentive Plan (SIP)
  • Employee Lifestyle Benefits Scheme
  • 30 days plus 3 public holiday entitlement
  • Plus, much more