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