Data Engineer - Associate

AlixPartners•London, OH

74d•Hybrid

About The Position

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.

Requirements

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' 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.

Responsibilities

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; escalate 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.