At a Glance
- Tasks: Join our team as a Junior Data Engineer, managing data pipelines and supporting analytics.
- Company: AlixPartners tackles complex challenges, promoting inclusivity and diversity in a hybrid work environment.
- Benefits: Enjoy flexible working options with a mix of in-office and remote days.
- Why this job: Make a real impact while learning from experienced engineers in a supportive culture.
- Qualifications: A Bachelor's degree is preferred; experience with SQL and data engineering tools is a plus.
- Other info: This role is based in London, with no paid relocation available.
The predicted salary is between 28800 - 43200 £ per year.
Junior 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. 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 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 you\’ll need
- Bachelors\’ degree preferred.
- Minimum one (1) year of 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 24×7 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
- Ability to work full time in an office and remote environment; physically able to sit/stand at a computer and work in front of a computer screen for significant portions of the workday
- 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.
#LI-AP2
#LI-Hybrid #J-18808-Ljbffr
Data Engineer - Associate employer: AlixPartners
Contact Detail:
AlixPartners Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer - Associate
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Databricks and Azure Data Factory. Having hands-on experience or even completing relevant online courses can give you a significant edge during interviews.
✨Tip Number 2
Network with current or former employees of AlixPartners on platforms like LinkedIn. Engaging in conversations about their experiences can provide valuable insights into the company culture and expectations, which you can leverage in your discussions.
✨Tip Number 3
Prepare to discuss real-world scenarios where you've applied your SQL and data engineering skills. Be ready to explain how you approached challenges, optimised processes, or collaborated with teams, as this will demonstrate your practical knowledge.
✨Tip Number 4
Showcase your commitment to continuous learning by mentioning any recent projects or certifications related to data engineering. This not only highlights your passion for the field but also aligns with AlixPartners' values of growth and inclusivity.
We think you need these skills to ace Data Engineer - Associate
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly with SQL, Databricks, and ETL processes. Use specific examples to demonstrate your skills and achievements in these areas.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your values align with AlixPartners' commitment to diversity and inclusion, and provide examples of how you've contributed to similar environments in the past.
Showcase Technical Skills: Clearly outline your technical skills related to data engineering, such as your experience with SQL Server, PySpark, and cloud services. Be specific about your familiarity with tools and technologies mentioned in the job description.
Highlight Communication Abilities: Since excellent communication skills are essential for this role, include examples of how you've effectively communicated complex data concepts to non-technical stakeholders or collaborated with teams in previous positions.
How to prepare for a job interview at AlixPartners
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, Databricks, and ETL processes. Highlight any projects where you've successfully implemented data pipelines or managed databases, as this will demonstrate your hands-on experience.
✨Understand the Company Culture
Familiarise yourself with AlixPartners' commitment to diversity and inclusion. Be ready to discuss how you can contribute to an inclusive environment and align with their core values during the interview.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills in real-world scenarios. Think of examples where you've troubleshot database issues or optimised data workflows, and be ready to explain your thought process.
✨Communicate Clearly and Effectively
Since excellent communication skills are essential for this role, practice articulating your thoughts clearly. Be concise when explaining technical concepts, and ensure you can convey complex information in an understandable way.