Senior Data Integration Consultant - ETL & API Expert

beqom; Leeds; On-site; GBP 60,000 - 90,000; Full time

Job summary

beqom seeks a technically proficient Technical Consultant for our Professional Services team. You will guide and execute client data flows into the beqom Total Compensation Management platform, focusing on designing, developing, and deploying robust data integration solutions tailored to each client’s HR and financial ecosystems.

You will collaborate with clients to map source data, define end-to-end integration strategies, and implement APIs/SFTP-based transfers, while ensuring data accuracy

Qualifications

• 3+ years of professional experience in Data Consulting, Integration Development, or ETL/ELT development, preferably within a SaaS environment.
• Expert knowledge of data integration methods, including RESTful/SOAP APIs for data extraction and ingestion, testing APIs with Postman and handling JSON/XML payloads.
• File transfer protocols like SFTP/FTPS.
• Strong SQL proficiency for data querying, manipulation, and analysis.
• Familiarity with IDEs for scripting and development tasks (e.g., VS Code).
• Proven experience with an iPaaS platform (Workato preferred) or similar tools (Mulesoft, Dell Boomi, Informatica).
• Experience with HCM, Payroll, or Financial data is highly desirable.

Responsibilities

• Data Analysis and Mapping: understand client source systems (HRIS like Workday, SAP SuccessFactors, Oracle), map to beqom data model.
• Design Data Flow: document and validate end-to-end data integration strategy including transformations and cleansing.
• Develop ETL specifications for Extract, Transform, and Load processes.
• API & SFTP Data Integration: configure data transfer via beqom APIs and SFTP channels.
• Internal Integration Layer: extend in-house tools for data transformation and validation.
• Third-Party Integration Tooling: leverage Workato or similar iPaaS to build integration recipes.
• Testing and Validation: perform unit, integration, and UAT testing to ensure data accuracy.

Skills

Data integration

RESTful & SOAP APIs

SQL proficiency

Problem-solving

Client-facing communication

Tools

SFTP/FTPS

VS Code

Workato

Mulesoft

Dell Boomi

Informatica

Job description

beqom seeks a technically proficient Technical Consultant for our Professional Services team. You will guide and execute client data flows into the beqom Total Compensation Management platform, focusing on designing, developing, and deploying robust data integration solutions tailored to each client’s HR and financial ecosystems.

You will collaborate with clients to map source data, define end-to-end integration strategies, and implement APIs/SFTP-based transfers, while ensuring data accuracy