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.