At a Glance
- Tasks: Design and maintain data pipelines using Microsoft Azure Stack to support analytics.
- Company: Join CalMac Ferries Limited, a forward-thinking company embracing digital transformation.
- Benefits: Permanent position with competitive salary and flexible hybrid working options.
- Why this job: Be part of a dynamic team driving data innovation and making a real impact.
- Qualifications: 3+ years in data engineering, proficient in Azure tools and ETL processes.
- Other info: Collaborative environment with opportunities for professional growth and development.
The predicted salary is between 45000 - 55000 £ per year.
This position will be offered on a permanent basis, based at our Gourock Head Office.
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 APIs 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.
Data Engineer in Gourock employer: Caledonian MacBrayne
Contact Detail:
Caledonian MacBrayne Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in Gourock
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even local tech events. The more you engage with others, the better your chances of hearing about job openings that might not even be advertised.
✨Show Off Your Skills
Don’t just talk about your experience; showcase it! Create a portfolio or GitHub repository with projects that highlight your data engineering skills, especially using Azure tools. This gives potential employers a tangible look at what you can do.
✨Ace the Interview
Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining your thought process when solving problems, as this shows your analytical skills and how you approach challenges.
✨Apply Through Our Website
When you find a role that excites you, apply directly through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Engineer in Gourock
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with Microsoft Azure Stack and any relevant projects you've worked on. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our digital transformation at CFL. Keep it engaging and personal.
Showcase Your Projects: If you've worked on any cool data pipelines or ETL processes, don’t forget to mention them! We love seeing real examples of your work, especially if they involve collaboration with analysts or stakeholders.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Caledonian MacBrayne
✨Know Your Tech Stack
Make sure you brush up on your knowledge of the Microsoft Azure Stack, especially Azure Data Factory and Azure SQL Database. Be ready to discuss how you've used these tools in your previous roles, as well as any challenges you've faced and how you overcame them.
✨Showcase Your ETL Expertise
Prepare to talk about your experience with ETL processes. Have specific examples ready that demonstrate your ability to design and optimise data pipelines. Highlight any performance improvements you've achieved and how they benefited your previous employers.
✨Collaboration is Key
Since this role involves working closely with data scientists and business stakeholders, be prepared to discuss how you've collaborated in the past. Share examples of how you’ve gathered requirements and delivered solutions that met the needs of various teams.
✨Stay Current with Trends
Show your passion for data engineering by discussing the latest trends and advancements in the field, particularly within the Microsoft Azure ecosystem. This will demonstrate your commitment to continuous learning and your ability to bring fresh ideas to the team.