Gourock
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.