Data Integration Specialist at PTSG Ltd

PTSG Ltd is a market leader in specialist services to the construction and FM sectors, delivering safety, compliance, and maintenance solutions nationwide.

Role: 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 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 & Experience

Essential:

• 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