Data Engineer - Associate

AlixPartners, LLP; City Of London; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading consulting firm in London is seeking a Data Engineer to build and optimize data pipelines, manage ETL tasks, and support database operations. The ideal candidate will have a Bachelor’s degree and at least one year of experience in SQL DBA or Data Engineering, along with familiarity with Databricks and Azure Data Factory. This role combines on-site and remote work, aiming for high levels of user satisfaction and adherence to internal standards.

Qualifications

• Minimum one year of full-time commercial experience in SQL DBA or Data Engineering.
• Familiarity with Data Engineering applications like Databricks and Azure Data Factory.
• Basic understanding of PySpark and/or Python programming.

Responsibilities

• Assist in building and optimizing data pipelines for analytics.
• Collaborate with analysts and stakeholders for data needs.
• Monitor data workflows to ensure accuracy and reliability.

Skills

SQL

Data Engineering

ETL Processes

Databricks

Python

Microsoft SQL Server

Cloud Services

Communication Skills

Education

Bachelor's degree

Tools

Azure Data Factory

PySpark

Job description

Data Engineer

At AlixPartners, we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communities they serve.By understanding, respecting, and honoring the needs of our employees, clients, and communities, AlixPartners actively promotes an inclusive environment. We strongly believe in the value that diversity brings to our experiences and are committed to the perpetual enhancements of initiatives, policies, and practices. We hold ourselves accountable by providing the space for authenticity, growth, and equity for everyone. www.alixpartners.com

AlixPartners has embraced a hybrid work model to provide flexibility and support our employees’ work-life integration. Our hybrid model combines a mix of in-person at an AlixPartners office on Tuesday, Wednesday, and Thursday, with remote working options for Monday and Friday.

What you’ll do

In this important role on AlixPartners IT Data Engineering & Shared Services team, you will provide on‑site engineering and support for our Database, Data Engineering and all database‑related services. This includes managing data engineering ETL tasks, administration of Spark clusters, database schema design, SQL server implementation, operation, and monitoring.

The Data Engineer is a full‑time role located in London, and reports to the Data Engineering Director. Paid relocation or visa sponsorship is not available for this position.

• Assist in building, maintaining, and optimising data pipelines to support analytics and reporting.
• Work with senior data engineers to ingest, transform, and validate data from multiple sources.
• Support the migration and integration of datasets across cloud and on‑premises environments.
• Monitor data workflows to ensure accuracy, timeliness, and reliability.
• Perform basic data cleaning, quality checks, and troubleshooting of pipeline issues.
• Collaborate with analysts, developers, and business stakeholders to understand data needs.
• Learn and apply best practices in data engineering, including security, governance, and documentation.
• Administration of Databricks Spark clusters and SQL Warehouse.
• Participate in code reviews and contribute to shared engineering standards.
• Maintain the integrity of databases and applications (as directed) upon which the business units rely for uninterrupted business operations.
• Run and monitor database and application performance queries; design and implement testing routines to identify and resolve (de‑bug) conflicts and potential operating malfunctions, using the Enterprise monitoring solutions and other utilities.
• Adhere to and perform against internal SLAs to the business.
• Participate in the monthly maintenance cycle as well as the on‑call rotation.
• Effectively communicate within the database team to ensure all team members are adequately informed of changes, detected issues, and other items necessary to maintain high levels of user satisfaction.
• Troubleshoot and resolve malfunctions with databases, applications, and related infrastructure; escalated to other technology support resources as needed.
• Schedule, communicate, perform and monitor both regular and ad‑hoc database maintenance activities in accordance with defined policies and procedures.
• Administer database systems security and assign appropriate access privileges to end‑users; monitor security issues and report potential problems and concerns.
• Additional responsibilities as identified. This description is not designed to encompass a comprehensive listing of required activities, duties, or responsibilities.

What you’ll need

• Bachelors’ degree preferred.
• Minimum one (1) year of full‑time commercial experience; SQL DBA/Data Engineer preferred*
• Familiar with Data Engineering applications such as Databricks and Azure Data Factory
• Basic PySpark and/or Python programming knowledge
• Familiar with ETL processes and techniques
• Administration of Microsoft SQL Server 2017/2019/2022 preferred
• Basic T‑SQL programming preferred
• Database performance monitoring, tuning and optimization preferred
• Experience in Cloud Services (e.g., Azure, Amazon)
• Experience in a 24x7 service delivery model supporting mission‑critical business operations
• Excellent written and verbal communication skills in English
• Willingness to work outside of normal UK. business hours, and as unique projects/needs arise
• Must become familiar with, and promote and abide by, our Core Values as defined by the AlixPartners’s Code of Conduct and foster an inclusive environment with people at all levels of an organization

*The commercial experience is intended as a guide only and does not preclude applications from those with more or less experience.

AlixPartners is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a protected veteran, or disability. AlixPartners is a proud Silver award‑winning Veteran Friendly Employer.

#LI-AP2

#LI-Hybrid