Data Engineer

Job Description Candidates should take the time to read all the elements of this job advert carefully Please make your application promptly. 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. xwzovoh ¹ 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.