Job Title: Integration and Data Engineer
Location: Chippenham (Office-based, 5 days per week)
The Opportunity
Cooper Lomaz are partnering with a well-established and fast-growing organisation in the South West, seeking a Integration and Data Engineer to support and enhance their business-critical systems and data infrastructure.
This is a varied and technically engaging role, ideal for someone who enjoys working across databases, ERP systems, and cloud-based data platforms. You’ll play a key role in ensuring data integrity, improving system performance, and enabling better decision-making across the business through high-quality reporting and insights.
Working closely with both technical and non-technical stakeholders, you’ll act as a bridge between IT and the wider business—translating requirements into scalable, efficient solutions.
Key Responsibilities
- Administer, maintain, and optimise SQL Server environments, ensuring performance, security, and reliability.
- Design and develop SQL queries, stored procedures, and functions to support reporting, integrations, and operational processes.
- Support and enhance the organisation’s ERP platform, including customisation and ongoing improvements.
- Work with internal stakeholders to understand business processes and identify opportunities for system and data enhancements.
- Build and manage data pipelines, ingesting data from multiple sources including APIs and databases.
- Cleanse, transform, and structure data to ensure it is accurate, consistent, and ready for reporting and analytics.
- Develop and publish reliable datasets to support business intelligence and reporting tools.
- Automate workflows and data processes to improve efficiency and reduce manual intervention.
- Collaborate with support teams, providing guidance and technical expertise where required.
Technical Skills & Experience
- Strong experience with Microsoft SQL Server, including database administration, performance tuning, and security management.
- Advanced SQL development skills, including writing complex queries, stored procedures, and functions.
- Experience working with ERP systems (ideally within manufacturing, distribution, or similar environments).
- Knowledge of SAP Business One or similar systems, including understanding of core data structures and business processes.
- Experience customising ERP platforms using third-party tools or add-ons.
- Hands-on experience with modern data platforms, including data ingestion, transformation, and modelling.
- Strong working knowledge of Power Query, Dataflows, and data warehousing concepts.
Cloud & Integration Experience
- Experience working with cloud-based platforms, particularly within the Microsoft ecosystem.
- Practical knowledge of workflow automation tools such as Logic Apps or equivalent technologies.
- Experience building or supporting serverless or event-driven processes (e.g. Function Apps or similar).
- Understanding of integrating systems via APIs and managing data flows between platforms.
Personal & Professional Attributes
- Strong analytical mindset with the ability to interpret complex data and identify actionable insights.
- Confident communicator, able to explain technical concepts to non-technical stakeholders.
- Customer-focused approach, with a commitment to supporting internal users and improving their experience.
- Ability to prioritise workload effectively in a fast-paced environment.
- Comfortable mentoring or supporting junior team members when required.
- Commercially aware, with an understanding of how systems and data contribute to business performance and growth.
Working Environment
- Fully office-based role, offering close collaboration with operational and leadership teams.
- Opportunity to play a key role in shaping data strategy and system improvements.
- Exposure to a wide range of technologies and business functions.
#J-18808-Ljbffr