Data Integration Specialist GB

TwentyCi Ltd; City Of London; Hybrid; GBP 55,000 - 80,000; Full time

Benefits offered by this job

Remote work

Wellbeing stipend

Holiday entitlement

Pension & Healthcare

Referral bonuses

Job summary

Centralise is seeking a Data Integration Specialist to act as the technical backbone for data flows between HubSpot and client systems. You will design, implement and maintain robust integration solutions aligned with client processes and goals.

Responsibilities include mapping data, building ETL processes, data validation, and creating documentation. Strong API skills, SQL/NoSQL knowledge and Git usage are essential.

Qualifications

• 3+ years in data integration or similar technical roles.
• Strong programming skills with API development.
• Deep understanding of SQL and NoSQL databases.
• Experience with ETL processes and data migration projects.
• Familiarity with integration platforms and middleware.
• Understanding of RESTful APIs and web services.
• Experience with Git.

Responsibilities

• Architect and implement data integration solutions with clients.
• Analyse data structures and design migration strategies.
• Map data between systems and optimise ETL processes.
• Maintain data quality and document integration processes.
• Lead technical aspects of data projects.

Skills

API development

RESTful APIs

Git

ETL processes

Data modeling

SQL databases

NoSQL databases

Node.js

Python

HubSpot APIs

Tools

HubSpot

Job description

*This is a remote/hybrid role

About Us:

We are Centralise, a dynamic agency dedicated to providing world-class HubSpot solutions and services. At Centralise, we are more than just a HubSpot agency – we are a partner committed to driving growth for our clients, our team, and ourselves. With a dedication to operational excellence, a focus on creating a world-class experience, and a track record of success, we are poised to become the go-to choice for businesses seeking elite HubSpot solutions.

Position Overview:

As our Data Integration Specialist, you will serve as the technical cornerstone for all data-related projects, ensuring seamless data flows between HubSpot and various client systems. You will be responsible for designing, implementing, and maintaining robust data integration solutions that align with our clients' business processes and objectives.

Primary Responsibilities

Your day-to-day activities will focus on solving complex data challenges. You will architect and implement data integration solutions, working closely with our implementation teams and clients to ensure successful project delivery. This includes analysing client data structures, designing migration strategies, and building scalable integration solutions.

You will lead technical aspects of data projects including: mapping data between different systems, creating and optimising ETL processes, implementing data validation rules, and developing custom integration solutions when needed. Additionally, you will establish best practices for data quality and maintain documentation for all integration processes.

Technical Requirements

You should have deep expertise in data integration technologies and methodologies. This includes proficiency in programming languages such as JavaScript/Node.js, Python, or PHP, and extensive experience working with APIs. Understanding of database systems (both SQL and NoSQL) is essential, as is experience with ETL processes and data transformation techniques.

Required Skills and Experience

• 3+ years of experience in data integration or similar technical roles
• Strong programming skills with demonstrated experience in API development
• Deep understanding of database systems and data modeling
• Experience with ETL processes and data migration projects
• Familiarity with integration platforms and middleware solutions.
• Understanding of RESTful APIs and web services
• Experience with version control systems (e.g., Git)

HubSpot-Specific Knowledge (desirable but not essential):

• Thorough understanding of HubSpot's architecture and object model
• Experience with HubSpot's APIs and integration capabilities
• Knowledge of HubSpot's limitations and best practices
• Understanding of HubSpot workflows and automation features
• Familiarity with custom object creation and management

Soft Skills

Strong communication abilities are essential as you will need to translate technical concepts for non-technical stakeholders. You should be able to work independently while collaborating effectively with project teams. Problem-solving skills and attention to detail are crucial, as is the ability to manage multiple projects simultaneously.

Expected Outcomes

• Take ownership of existing data integration projects
• Develop standardised processes for data migration
• Create documentation templates for integration projects
• Successfully complete at least one major data migration project
• Establish best practices for data quality assurance

Why Join Us?

Growth Opportunities: Join a fast-growing agency with leadership and advancement potential.

Collaborative Environment: Work with a team of industry experts in a supportive and innovative culture.

Impact: Play a critical role in shaping solutions for high-profile clients and driving real business results.

Benefits

• Remote working with 1 day a month in office with the team.
• Wellbeing Stipend: £600 annual stipend to support your health and wellness.
• Generous Holiday Allowance: 22 days holiday plus bank holidays, with an additional day per year (up to 27 days).
• Pension & Healthcare: Comprehensive benefits to ensure your financial and physical well-being.
• Referral Bonuses: Generous incentives for successful referrals.