Established in 1963, Fred. Olsen Ltd focuses primarily on the Renewable Energy, Forest Management, Logistics and Travel Sectors. Established and based in the UK, but operating globally, we operate with innovation, service and dependability in mind, and supply a central service function in Finance, HR, IT and Facilities services to the UK companies under our umbrella which include:
The Natural Power Consultants
ZX Lidars
ZX Measurement Services
As a company we have a family culture, our success is anchored in an authentic heritage. Delivering our vision is down to the passion of our people, and we are proud to create opportunities for everyone to thrive and grow.
This role will be responsible for designing, developing, and maintaining data pipelines, scalable data models, and data integration solutions that support the organisation’s reporting, analytics, and automation needs. The post-holder will develop data pipelines utilising low-code / visual ETL tools and Python where appropriate. They will be responsible for designing and implementing data models and structures suitable for a data warehouse or lakehouse environment, ensuring consistency, performance, and scalability. The post-holder will own the full project lifecycle including design, build, testing, deployment, and operational support, working independently to deliver robust and reliable data solutions. The role will be based in Natural Power Glasgow Office.
Main Tasks & Activities
* Design, build, and optimise data pipelines using the organisations unified data platform e.g. Microsoft Fabric, Databricks.
* Develop ETL/ELT workflows using low-code or visual-first tooling and code-based pipelines (SQL, Python, PySpark) where necessary.
* Implement and maintain automated data ingestion, transformation, and orchestration processes, ensuring performance, reliability, and scalability.
* Integrate pipelines with internal systems, APIs, third‑party applications, and cloud services using connectors or custom integrations.
* Apply appropriate testing approaches including data quality rules, schema validation, unit tests, and automated validation checks.
* Implement and manage CI/CD processes for data engineering solutions, using Azure DevOps, Git-based workflows, and infrastructure‑as‑code tools (ARM/Bicep/Terraform).
* Monitor and maintain operational data pipelines, investigating issues and delivering improvements proactively.
* Design and develop scalable data warehouse and lakehouse models, including dimensional models (star/snowflake), medallion architectures, and semantic layers.
* Ensure data models support analytics, reporting, machine learning, and operational decision‑making across the organisation.
* Create and maintain data dictionaries, metadata, and lineage documentation to support transparency, governance, and maintainability.
* Optimise data storage and query performance through effective partitioning, indexing, and schema design.
* Where applicable, incorporate AI and agentic capabilities to enhance data processing, transformation, or enrichment.
* Ensure alignment with organisational data governance, security standards, and architectural guidelines.
* Work collaboratively with analysts, data consumers, and stakeholders to translate business requirements into robust, scalable data structures.
Documentation & Project Management
* Maintain accurate documentation covering data pipelines, models, transformations, architecture, and process.
* Manage project timelines and deliverables to ensure solutions are completed on schedule.
* Provide clear updates and reports regarding progress, risks, and ongoing support needs.
* Participate in Agile delivery practices (SCRUM/Kaban), including stand‑ups, sprint planning, or Kanban activity management.
Other duties
* Communicate and collaborate across the IT function and with business teams.
* The post-holder will be required to undertake such duties as may reasonably be expected. All members of staff are expected to be professional, co‑operative and flexible within the needs of the post, the department and the Company.
* Duties of the post could vary from time to time as a result of new legislation, changes in technology or policy. In this event, appropriate training will be provided
As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees. We want to ensure that you feel supported throughout the application process and provide reasonable adjustments where necessary and requested. If you require any reasonable adjustments as part of your application and interview process, please do not hesitate to let us know.
Seniority level
Not Applicable
Employment type
Full-time
Job function
Administrative
Industries
Services for Renewable Energy
#J-18808-Ljbffr