Data Engineer Senior Consultant in England

About Squarcle / The Team

Squarcle is a growing strategy, operations and digital consultancy dedicated to driving the performance of our clients. We are people orientated and pride ourselves on our people‑first culture. Unlike many consultancies, Squarcle is as equally dedicated to delivery as it is to design. The Technology and Digital department, led by the Head of Digital, is responsible for providing expert technology and digitisation strategy, operational optimisation and analysis advice to clients operating within a fast‑moving global environment. The team comprises several subject matter experts who work to a manager to deliver the client and internal Squarcle mandate. Working together but often independently, each team member will be expected to work onsite and remotely with the client, on complex and exciting technology challenges. Squarcle is committed to equality and diversity and our aim is to build a diverse, dedicated, and high‑performing team of subject matter experts to help our clients achieve supply chain and operational excellence.

Job Overview / Introduction

The Senior Consultant Data Engineer is responsible for the provision of independent technical expertise in data engineering, infrastructure and back‑end development best practice, both on client projects and Squarcle’s proprietary platform development. All our Technical team are expected to have input into our digital, product and technology strategy, owned by the Head of Digital, and be comfortable presenting technical content to non‑technical colleagues and clients.

Squarcle consultants work across both project delivery, business and product development:

• Delivery: Squarcle Technology and Digital consultants work to supply solutions to the client’s changing business needs. The scope of engagements is highly variable and can include core strategy development, large‑scale implementation, process optimisation, change management, data analysis, data modelling, solution development and innovative technology introduction.
• Business development: Squarcle places an emphasis on leading sector thinking in the development of the latest ideas. This can include producing white papers and internal research on relevant changes occurring in the sector and the impact on the general economy.
• Product Development: Squarcle is passionate about investing in and developing its own products. This can include conceptualising, designing, and creating cutting‑edge products that align with the business's strategic vision, meet customer needs, and drive sustainable growth in the market.

Consultants will have the opportunity to work across four broad subject areas:

• Strategy: Strategy consultants provide clients with guidance in various spheres of business, including corporate strategy, business transformation, and digital and innovation capabilities.
• Operations: Operations consultants provide clients with guidance about business process optimisations to improve operational business capabilities.
• Data and Digital: Data and digital consultants specify and implement technological, data and digital solutions with the client to realise the value of their data.
• Human Capital: Human capital consultants provide clients with solutions for change management and aide with any organisational changes that may affect the employees.

Primary Roles & Responsibilities

• Lead the Data Engineering aspects of the design and development of Squarcle’s product and platform development, including specifying data pipelines for multiple sources, formats, and frequencies (e.g. streaming, batched, API, unstructured, etc).
• Work on data engineering client engagements.
• Extraction, Transformation and Loading of data sets. Implementing and maintaining data pipelines and automation for data collection and analysis.
• Knowledge of data engineering tooling.
• Work closely with product owners, infrastructure engineers, data scientists, front‑end engineers and UI/UX consultants to create coherent, robust and sustainable outputs for client and internal projects.
• Work with client stakeholders to understand their business problems, technology, digital maturity, data sources, access protocols and security requirements to ensure the highest levels of data security.
• Contribute to project plans, designs and prototype solutions to demonstrate early benefit and value.
• Contribute to discussions and discovery workshops to understand the As‑Is state and any existing digital change activity already underway.
• Work in an Agile manner, collaborating closely with clients and colleagues to iteratively refine and deliver the solution within the Discovery – Alpha – Beta – Live delivery model aligned to GDS standards.
• Engage with appropriate Agile ceremonies, ensuring necessary information (e.g. progress, releases, risks, issues) is shared with the product owner, project manager and other stakeholders.
• Work effectively in diverse teams within an inclusive team culture where people are recognised for their contribution.
• Assist the Head of Digital in developing Squarcle’s Technology and Digital capabilities.
• Conduct performance reviews and annual appraisals for all direct reports.
• Lead, coach and mentor team members.

Secondary Roles & Responsibilities

• Commit to continuous development by supporting the organisation of team events, training sessions and recruitment activities.
• Carry out other duties as specified by the Head of Technology.
• Deputise for the Manager during periods of absence.

Essential Knowledge, Skills & Experience

• Demonstrable expertise in data engineering, including creating robust data pipelines for streamed, batched and on‑demand data sources.
• Strong data modelling and analysis skills.
• Cloud and platform experience (Azure centric, strong understanding of Azure data services; Azure data factory etc.)
• Strong understanding of API based integrations. Experience with integrating to SaaS platforms.
• Strong SQL experience.
• Exceptional problem‑solving skills – an analytical, innovative, and creative mindset.
• Experience supporting the designing and delivering of data and digital solutions to solve business problems and create enduring value for clients.
• A growth mindset, enthused by challenge and the opportunity for continuous learning.
• Excellent interpersonal and communication skills, both written and verbal.
• Aptitude to grasp new concepts and rapidly produce results.
• Ability to be self‑directed and be an independent contributor to the team.
• Intellectual curiosity, exceptional client service, and a strong work ethic.
• A team player dedicated to contributing toward the outcome desired by the team.
• Ability to adapt to rapidly changing circumstances and to think creatively to solve client issues.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is a security check.

Desirable

• BSc/BA in Computer Science, Engineering or a related analytical or technical field.
• Awareness of cloud technology qualifications (Azure preferably).
• Apache Spark and Python.
• An understanding of supply chain.

What we offer

• Generous leave package: 26 days of annual leave (including your birthday!) plus UK bank holidays — increasing to 27 days after three years, and 28 after seven years. You’ll also get five extra days for your five and 10-year anniversaries. Additional leave for members of the Reserve Forces and CFAV.
• Private medical insurance provided once you’ve completed your probation.
• Recognition and rewards: £1,000 referral bonus for successful hires, performance‑related awards, milestone and life‑event hampers to celebrate life’s big moments.
• Development & learning: Annual training week abroad, funding for qualifications that benefit both you and the business.
• Travel & wellbeing: Cycle to work scheme, discounted travel through funded railcards.
• Pension: Our pension provider is NOW Pensions, pension contributions are 3% employer and 5% employee. We review our benefits regularly to ensure they stay competitive and meaningful - so this list may evolve as we grow.
• Our working hours are 8:30 am – 5:30 pm (with an hour for lunch), Monday – Friday.

Apply now and take the next step toward doing work that matters, with a team that’s shaping the future of supply chain consulting.

Important Information: This role requires you to have lived in the UK for the last 5 years and obtain Security Check (SC) security clearance. Clearance must be obtained without any caveats that prevent you from carrying out the role you’ve been recruited for. If it isn’t obtained, or is obtained but with caveats that prevent you from carrying out the role, any conditional offer made to you will be withdrawn. Obtaining SC security clearance can be a lengthy process, and we reserve the right to withdraw any conditional offer made if the necessary security clearance isn’t obtained within 6 months. If you hold dual citizenship or nationality from another country, please make us aware of this during the application phase. We’re unable to offer visa sponsorship. We’re committed to creating a diverse environment. We embrace differences and hire based on merit, giving equal consideration to all applications, regardless of gender, background, and race.