Data Engineer

We are seeking a skilled Subject Matter Expert (SME) & Data Engineer with a strong focus on data modelling, mapping, and transformation to join our Big Data Services team within the Hybrid Cloud & Data service line. This role will involve collaborating with cross-functional teams to define, implement, and validate data integration and transformation requirements across a range of structured and semi-structured data sources.

Key Responsibilities

• Analyse source and target data formats and structures (e.g., databases, XML, JSON, CSV, EDI) to define and document accurate and effective data mappings.
• Develop and maintain data mapping specifications, transformation logic, and integration rules based on business and technical requirements.
• Work closely with data architects, domain experts, and business analysts to ensure semantic alignment and consistency between systems.
• Validate mapping outputs and troubleshoot discrepancies or issues in data transformations.
• Create and maintain documentation to support data traceability, governance, and reusability.
• Ensure all data processing activities comply with relevant data quality, security, and privacy standards.

Required Skills & Experience

• UK National (Must have active BPSS Clearance).
• Proven experience in roles involving data mapping, transformation, or integration (e.g., data analyst, technical business analyst, data engineer).
• Strong hands-on expertise with data formats including XML, JSON, CSV, EDI, XLSX.
• Ability to interpret complex data structures and translate them into robust mapping and transformation specifications.
• Strong attention to detail and ability to manage data-related documentation for governance and compliance.

Nice to Have

• Experience with ETL or data integration tools such as Informatica, Talend, Apache Nifi, SSIS, or Boomi.
• Familiarity with data mapping documentation methodologies or modelling tools such as Excel-based mapping specs, BPMN, or UML.
• Understanding of data architecture principles and metadata management.