Data Warehousing and Data Lakes

• Contribute to the design and maintenance of data warehouses, ensuring efficient storage and retrieval.
• Work with data lakes (such as Azure Data Lake Storage) to ingest and process large volumes of data.
• Understand ETL (Extract, Transform, Load) processes and their impact on BI solutions.
• Implement data governance practices within the data warehouse and data lake environments.

General

• Participate in cross-functional teams to provide insights and recommendations for data-related initiatives.
• Participate in training and development opportunities to enhance technical skills and domain knowledge.
• Demonstration of safe approach in working practices.
• Encouragement of attention to safety.
• Responsible for ensuring professional development is maintained and identified competency requirements are undertaken in a timely manner.
• Adherence to the company integrated management system.
• Compliance with quality assurance, health and safety and environmental policies.
• Demonstrate and promote PD&MS QHSE principles and lead by example.
• Ensure unsafe activities are challenged.
• Adherence to the requirements of the best practice standards recommendations and processes in the undertaking of duties.
• Demonstrate and promote PD&MS values and lead by example.

About You

Qualifications

• Degree qualified in a relevant subject
• Masters degree in relevant discipline (preferred)

Experience / competence

• Demonstrable experience in data preparation, data warehousing and BI projects
• Demonstrable experience with Microsoft BI stack, including Power BI, SSAS, SSRS and SSIS
• Knowledge of other BI tools such as Tableau or SAP (preferred)
• Demonstrable experience in creating clear and concise requirement documents, user stories and process flows (preferred)
• Knowledge of scripting languages and SQL server (preferred)
• Excellent written and spoken English

Personal attributes

Our GENES, our core values, define who we are, what we stand for and how we deliver.

• Go the extra mile
• Empower our people
• Never get complacent
• Engage our partners
• Step up and deliver

If this sounds like you, then you could be a perfect fit.

About Us

PD&MS has been engineering solutions in the energy industry and beyond since 2002, our ability to combine innovative ideas with technical expertise sets us apart. A flexible, full-service provider committed to supporting the energy transition, we deliver high-quality project work across the entire lifecycle of assets within the oil and gas, renewables and nuclear sectors. But whoever we work with, it’s the energy, professionalism and purpose of our people that really makes the difference.

Be who you’re meant to be, with PD&MS

We firmly believe in a work culture in which: individual differences are a source of collective strength and pride; everybody can perform to the best of their abilities and on a level playing field; and all colleagues feel they’re part of our team and their voices will be heard. We’re already heartened by the diversity within our organisation, but we recognise that there’s always more we can do to improve further. We welcome applications from all persons regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran or disability status.

We’re energised by the prospect of operating successfully today, tomorrow and far into the future. But we’re also driven to ensure that our business activities are conducted in socially responsible, morally acceptable and sustainable ways.