At a Glance
- Tasks: Design and implement automated data pipelines for reliable analytics and reporting.
- Company: Join a forward-thinking company focused on innovative data solutions.
- Benefits: Competitive salary, flexible working hours, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous improvement and knowledge sharing.
- Why this job: Make a real impact by optimising data processes and enhancing business efficiency.
- Qualifications: Experience with data integration, ETL/ELT pipelines, and strong problem-solving skills.
The predicted salary is between 36000 - 60000 £ per year.
Role Purpose
This role ensures that business data is collected, transformed, validated, stored, and distributed through resilient automated pipelines, reducing manual processes and enabling reliable analytics, reporting, and system integrations. The position supports both Business as Usual (BAU) operations and project delivery activities. This includes maintaining the stability and performance of existing integrations and data pipelines, as well as designing and implementing innovative solutions in line with agreed project specifications and architecture standards. The Integrations & Data Engineer will also be responsible for ensuring that their solutions adhere to modern, secure standards and have scalability in mind. This includes following recognised frameworks and best practices to provide solutions that remain robust, maintainable, and future-proof, supporting the business' evolving needs and compliance requirements.
Key responsibilities
- Integration Engineering & Data Pipelines
- Develop, implement, support, and oversee data integrations between platforms.
- Develop and maintain scalable ETL/ELT pipelines to ensure reliable and structured data availability for consumption.
- Produce and maintain a comprehensive documentation of data schemas, conventions, and definitions.
- Ensure a high level of data integrity through validation and comprehensive error handling measures.
- Process Automation & Workflow Development
- Design, build and maintain robust data automation workflows to reduce manual processing and improve operational efficiency.
- Selection of appropriate tools to support automated data processing at scale, while including logic to handle scheduling and retry mechanisms for reliability.
- Undertake user studies to proactively identify opportunities for efficiency gains through automation.
- Operational Support (BAU), Continuous Improvement, & Knowledge Sharing
- Respond to & resolve escalated support tickets relating to data, integrations, and automations, providing RCA and explanations to the support team.
- Proactively review & recommend potential improvements, reworks, or changes to existing workflows as part of a continuous improvement mindset.
- Collaborate with suppliers, partners and external contractors during support and project delivery activities.
- Write & maintain KB articles for technical documentation and end-user guides.
- Project Delivery & Stakeholder Collaboration
- Provide technical expertise, effort estimation, and risk identification during the planning of projects.
- Maintain consistent & audience-appropriate communication with project stakeholders during development.
- Provide timely progress updates, risks and potential blockers to stakeholders and the project manager.
Required skills & experience
- Core data & integration skills
- Strong experience designing, building and maintaining integrations between systems, including working with RESTful APIs as both data sources and destinations.
- Solid understanding of common data formats such as JSON, XML and CSV.
- Strong ability to validate, cleanse, manipulate and transform data for quality, reliability, and accuracy.
- Experience developing and optimising ETL/ELT pipelines in analytical, reporting, and operational contexts.
- Database & platform expertise
- Microsoft SQL Server
- Advanced knowledge of Microsoft SQL Server, including writing DML queries, stored procedures, and functions.
- Experience managing SQL Server instances (security, users, monitoring, maintenance).
- SAP Business One
- Understanding of core SAP B1 processes and objects (business partners, documents, etc).
- Experience customising the platform using add-ons such as Boyum B1UP.
- Familiarity with SAP B1's underlying data structures.
- Microsoft Fabric
- Experience ingesting data from APIs or databases into Fabric.
- Skilled in using Dataflows, Power Query, and Data Warehouse tooling to cleanse, transform, and prepare data.
- Ability to publish structured, reliable datasets for analytical and reporting use cases.
- Microsoft Azure
- Hands-on experience with Azure Logic Apps for workflow automation.
- Experience using Azure Function Apps for high-speed data manipulation and transfer operations.
- Familiarity with additional Azure data and compute services beneficial to integration workloads.
- Microsoft SQL Server
- Programming & automation skills
- Ability to write and understand T-SQL, VBScript, and Python.
- Experience of working with DAX, Node.js, PowerShell, or Bash.
- Experience with automation, workflow orchestration, scheduling, and error-handling logic.
- Familiarity with version control (e.g., Git), DevOps and CI/CD practices is desirable.
- Teamwork, service & communication
- Strong problem-solving and critical thinking skills with the initiative to identify optimal solutions.
- Excellent customer service mindset when supporting internal teams and franchise partners.
- Ability to communicate and explain technical concepts clearly to both technical and non-technical audiences.
- Experience mentoring or guiding first-line support staff through escalated incident resolution.
- Confidence in identifying weaknesses in business or technical processes and recommending improvements.
- Understanding of commercial and operational metrics, and how data solutions support wider business goals.
Integrations & Data Engineer in Plymouth employer: Pilgrim's Europe
As an Integrations & Data Engineer at our company, you will thrive in a dynamic work culture that prioritises innovation and collaboration. We offer competitive benefits, including professional development opportunities and a commitment to employee growth, ensuring you can advance your career while contributing to meaningful projects. Located in a vibrant area, our workplace fosters creativity and teamwork, making it an excellent environment for those looking to make a significant impact in the field of data engineering.
StudySmarter Expert Advice🤫
We think this is how you could land Integrations & Data Engineer in Plymouth
✨Tip Number 1
Network like a pro! Get out there and connect with folks in the industry. Attend meetups, webinars, or even just grab a coffee with someone who’s already in the role you want. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio or GitHub repository showcasing your projects, especially those related to data integrations and automation. This gives potential employers a tangible look at what you can do, making you stand out from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions related to data engineering and integration. Think about how you’d explain your past projects and the technologies you’ve used. Confidence is key, so rehearse until you feel ready to impress!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it’s a great way to ensure your application gets seen by the right people. So, what are you waiting for? Go for it!
We think you need these skills to ace Integrations & Data Engineer in Plymouth
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter to highlight your experience with data integrations and automation. We want to see how your skills align with the role, so don’t hold back on showcasing relevant projects!
Showcase Your Technical Skills:When detailing your experience, focus on your proficiency with tools like Microsoft SQL Server, Azure, and any programming languages you know. We love seeing specific examples of how you've used these in past roles!
Keep It Clear and Concise:While we appreciate detail, clarity is key! Make sure your application is easy to read and free from jargon. Use bullet points where possible to break down your achievements and responsibilities.
Apply Through Our Website:We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Pilgrim's Europe
✨Know Your Data
Make sure you brush up on your data integration skills before the interview. Be ready to discuss your experience with RESTful APIs, ETL/ELT pipelines, and data formats like JSON and XML. Having specific examples of how you've tackled data challenges in the past will show that you're not just familiar with the concepts but can apply them effectively.
✨Showcase Your Problem-Solving Skills
Prepare to share instances where you've identified and resolved issues in data workflows or integrations. Highlight your critical thinking and problem-solving abilities, especially in relation to operational support and continuous improvement. This will demonstrate your proactive mindset and ability to enhance existing processes.
✨Communicate Clearly
Since you'll be collaborating with various stakeholders, practice explaining technical concepts in a way that's easy for non-technical audiences to understand. Think about how you can convey complex ideas simply and effectively, as this will be crucial in your role and during the interview.
✨Familiarise Yourself with Tools
Get comfortable with the tools mentioned in the job description, such as Microsoft SQL Server, Azure Logic Apps, and Microsoft Fabric. If you have experience with version control systems like Git or CI/CD practices, be sure to mention it. Showing that you're well-versed in these technologies will give you an edge in the interview.
