Data Engineer

This position will be offered on a permanent basis, based at our Gourock Head Office ¹

Role Overview

Forming a key part of the IT Data team, this is an exciting opportunity to join CalMac Ferries Limited (CFL) internal Data Engineering Team. Data is seen as a key enabler for CFL and the Data Engineering Team provide data infrastructure and services to support a growing and diverse community of specialist analysts based throughout our business. 

The organisation will evolve over the next few years to "digital first" for customers and colleagues. Working at a senior level, you will develop and support a range of system integrations, ETL processes, internal API's and reporting tools, using Azure Data Platform technology as we continue our transformation.

Principal Accountabilities

• Design, develop, and maintain scalable data pipelines and ETL processes using Microsoft Azure Stack tools.
• Produce ETL designs and code with a view to optimal ETL performance.
• Build and optimise data architectures to support the analytics and reporting needs of the organisation.
• Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver solutions.
• Ensure data quality, integrity, and security by implementing appropriate data governance practices.
• Monitor and troubleshoot data pipelines, addressing any issues or bottlenecks in a timely manner.
• Develop and maintain comprehensive documentation for data engineering processes and systems.
• Stay up to date with the latest trends and advancements in data engineering and cloud technologies, particularly within the Microsoft Azure ecosystem.
• Inspire best practice for data products and services across the Information Technology team and the wider business.
• Champion data engineering across CFL.

Qualifications, skills and experience

• 3+ years of experience in data engineering or a related role.
• Proficiency in using Microsoft Azure Stack, including services such as Azure Data Factory and Azure SQL Database.
• Expertise of the concepts and principles of data modelling and can produce, maintain, and update relevant data models for specific business needs.
• Understanding of ETL processes and data warehousing concepts.
• Experience with designing flows for data visualisation using Power BI.
• Familiarity with data governance, data quality, and data security best practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Experience with CI pipelines and version control using DevOps.

¹ This role will be based at our Head Office in Gourock and operates under our Agile/Hybrid Working Policy, requiring at least two days per week to be worked on site.