About PTSG. A short history – an incredible storyPTSG was founded in 2007 to fulfil an industry need for a single provider of multiple specialist services to the construction and FM sectors.Since then, we’ve grown steadily, securing major new and renewed contracts that reinforce our role as a trusted, multi-service partner.The Group, headquartered in Castleford, West Yorkshire, employs around 3,000 people in the UK and Europe. This staffing allows us to mobilise our experts to any site, regardless of location. Consequently, we serve more than 300,000 buildings for over 30,000 customers in a wide range of industry sectors.Our multinational presence grew substantially with the acquisition of Flame Control in February 2024. Based in the municipality of Harderwijk, the company specialises in fire alarm systems, first aid, evacuation, extinguishing systems and extinguishing agents. Flame Control has a team of 40 specialists that work extensively across the Netherlands. Their specialists work seven days a week to improve fire safety in businesses and residential properties.Recent national framework and specialist service agreements with Mitie, CBRE, Sodexo, Vinci, BNP Paribas Real Estate, ABM, ISS and others span a wide range of services:Fall protection and access and safetyElectrical and lightning protection testingSpecialist cleaning, maintenance, and façade accessFire solutions and complianceWater treatment and hygieneWhether site-specific or nationwide, our packages deliver consistent, scalable service with precision and professionalism.About PTSG Ltd PTSG Ltd is a market leader in specialist services to the construction and FM sectors, delivering safety, compliance, and maintenance solutions nationwide.As Data Integration Specialist you will be responsible for designing, implementing, and maintaining data integrations that support the seamless flow of data between systems, applications, and databases. This is a great opportunity for someone to work collaboratively on brand new platforms, focusing on green field development, across a multi company organisation.Reporting to the Data Engineering Manager, the Data Integration Specialist will deliver all aspects of data integration from demand planning through to handover into operational IT, retaining a responsibility to support IT operations in occasional exceptional / complex problems (3rd / 4th line).This is a full time, permanent role, working 8am to 5pm Monday to Friday. You will be based from either our Castleford head office (WF10 5HW) or our Altrincham office (WA15 8FH) on a hybrid basis (working from home with an office day at least once a week). This role would suit someone who has experience as a Data Engineer, looking for their next career move into a rapidly growing, data driven organisation.What you will be doing:
Collaborate with cross-functional teams, including IT, business analysts, data scientists, and project managers to understand data integration requirements and deliver solutions that meet those needs.
Develop and implement efficient and scalable data integration processes to support business needs.
Analyze data from multiple systems and sources to develop accurate data mappings and transformation rules.
Create and maintain documentation for data mappings, workflows, and transformation logic.
Work closely with system architects to ensure data integration solutions are aligned with the organization’s data architecture.
Ensure that integrated systems and data solutions are optimized for performance, scalability, and maintainability.
Ensure seamless data flow between different systems, including databases, CRMs, ERPs, and third-party applications.
Monitor data integration workflows to identify and resolve data discrepancies, inconsistencies, or failures in real time.
Troubleshoot and resolve data-related issues across integrated systems and data pipelines.
Provide technical support and expertise to other teams regarding data integration best practices and solutions.
Present and communicate data integration solutions to non-technical stakeholders, ensuring alignment with business objectives.
Automate routine data integration tasks and processes to improve efficiency and reduce manual intervention.
Implement data masking, encryption, and other security measures as necessary to protect sensitive data during integration.
Skills & ExperienceEssential:
3+ years of experience in data integration, ETL/ELT development, or data management.
Strong proficiency with ETL/ELT tools and technologies (e.g., Talend, Informatica, Microsoft SSIS, Apache Nifi, etc.).
Knowledge of scripting languages (e.g., Python, Java, Bash).
Experience with the development and implementation of APIs.
Strong knowledge of relational databases (e.g., SQL Server, Oracle, MySQL) and data query languages (SQL, PL/SQL, etc.).
Solid understanding of data modelling, data warehousing, and data governance principles.
Experience with cloud data integration tools (e.g., AWS, Azure Data Factory, GCP).
Desirable:
Knowledge of data security standards and compliance regulations (e.g., GDPR, HIPAA) is a plus.
Familiarity with version control systems (e.g., Git) and project management tools (e.g., Jira, Trello).
What in it for you?
A competitive salary
25 days holiday + bank holidays
Company pension scheme
Discounts on everyday shopping, fashion, tech, holidays, meals out, gyms & more
Hybrid working
On-site parking
A supportive, friendly office culture, and plenty of chances to learn
Ind1
Read Less
