Lead Data Engineer

Reporting to the Head of Data Engineering as part of the global Technology & Transformation Department, the holder of this position will be responsible for providing expertise across a broad range of data systems operating in the Robert Walters Group IT infrastructure.

Lead Data Engineer

With more than 4,000 employees in 33 countries, we deliver recruitment consultancy, staffing, recruitment process outsourcing and managed services across the globe. From traditional recruitment and staffing to end-to-end talent management, our consultants are experts at matching highly skilled people to permanent, contract and interim roles across all professional disciplines. The Group comprises three specialist brands that are built to meet the unique and ever-changing needs of the clients and candidates we support. Robert Walters - Specialist professional recruitment consultancy with a worldwide network of experienced sector specialists. Walters People - Specialist staffing brand, matching candidates to finance and business support roles. Resource Solutions - Market leaders in recruitment process outsourcing (RPO) and managed service provider (MSP) solutions.

Purpose of the job:

Reporting to the Head of Data Engineering as part of the global Technology & Transformation Department, the holder of this position will be responsible for providing expertise across a broad range of data systems operating in the Robert Walters Group IT infrastructure.

Responsibilities:

• Design, build, implement and maintain Data Migration processes;
• Design, build, implement and maintain Data Integration and ETL/ELT pipelines;
• Design, build, implement and maintain databases (Snowflake, Dynamics, PostgreSQL, MySQL/MariaDB, Oracle, Sybase);
• Design, build and maintain solutions incorporating the company’s Data Lake;
• Provide Business Level through to Technical Level analytical expertise for data-related aspects of IT projects;
• Design, build, implement and support programs and applications for database management, data management and user interaction with various data sources;
• Design and document the architectural components needed to transform raw transactional data in to a consistent and coherent dataset suitable for BI use. Ensure guidelines exist for integration, cleansing and data modelling including data warehouse structures (aggregation, federation, virtualisation);
• Understand the data components needed to meet business requirements including currency, quality, granularity, velocity and structure.

Knowledge & Skills:

• Extensive experience designing, building and maintaining Data Migration and Integration solutions using a recognised Business Integration tool, including the use of a programming language within a tool;
• Experience designing, building and maintaining databases, including procedural programming and SQL scripting on a major RDBMS;
• Experience working with one of the major cloud platforms (Amazon AWS / Microsoft Azure / Google Cloud);
• Experience working with event-based and streaming technologies such as Apache Kafka;
• Experience working within the Scrum agile framework.

Desired:

• Experience with Sybase ASA on Windows including replication, procedural programming and general SQL scripting;
• Experience in AWS data pipeline services;
• Experience with Microsoft SQL Server 5 or above;
• Experience in Oracle 11g on Windows and Unix/Linux;
• Experience designing and building Data Lakes;
• Experience of working with NoSQL databases, e.g. MongoDB;
• AWS Certified Developer (Associate) and/or AWS Certified Solutions Architect (Associate) certifications;
• Certified Data Vault 2.0 Practitioner (CDVP2TM)