Data Engineer Associate

London - UK

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

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.

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

What youll 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 AlixPartnersCode of Conductand 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.

AlixPartnersis 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 aprotected veteran or disability. AlixPartners is a proud Silver award-winning Veteran Friendly Employer.

#LI-Hybrid

#LI-AP2

Required Experience: