Lead Data Engineer

Audley Travel Group; London; On-site; GBP 50,000 - 90,000; Full time

Job summary

Join a dynamic and innovative team as a Lead Data Engineer, where your expertise will drive impactful data solutions in a thriving travel company. This role offers the opportunity to lead data analytics development, mentor fellow developers, and collaborate with key stakeholders to achieve strategic reporting outcomes. With a focus on designing advanced analytics using Power BI and optimizing data processes, you will be at the forefront of transforming data into actionable insights. Embrace a culture of curiosity and innovation, while enjoying a range of perks and a supportive work environment that celebrates diversity and inclusion. If you're passionate about data and travel, this is the perfect opportunity to make a significant impact.

Benefits

25 days holiday rising to 30

Private Medical Insurance

Discretionary annual bonus

Birthday off

Volunteering day off

Healthshield cash plan

Enhanced family leave

Enhanced pension scheme

Life insurance

Discounted Audley trips

Qualifications

• Proven experience in Business Intelligence and Modern Data Platform.
• Strong knowledge of data product development and management best practices.

Responsibilities

• Lead data analytics development on projects and Data Warehouse.
• Design and develop Data Lake and Warehouse technical components.

Skills

T-SQL

Azure Data Lake

Power BI

Apache Spark/PySpark

Azure Synapse Analytics

Azure Data Factory

SQL relational databases

Machine Learning algorithms

Visual Studio

DevOps / DataOps

Education

University Degree in Computer Science

MSc/PhD in related field

Tools

Azure Analysis Services

GIT source control

SSIS

Rest/SOAP Integration

Job description

This role can be based out of either our Witney office in Oxfordshire or the Shepherd's Bush office in London and typically a minimum of 3 days per week in the office is required.

About us
Audley Travel is an award-winning, consistently recognised tour operator that specialises in tailor-made travel in over 80 countries. Our clients come to us because we are the true experts of the region and use our knowledge to provide meaningful travel experiences. Our employees are passionate about travel and exploring other cultures. In 2021, we proudly celebrated serving our travel clients for 25 years. Take a look at our video below to get a real taste of who we are and what we love doing:
https://www.youtube.com/watch?v=H-AhWeqsvds

The role
As an accomplished Lead Data Engineer, you will be responsible for leading all data analytics development on projects and the strategic Data Warehouse, mentoring of other BI Developers, and working with key stakeholders to achieve strategic reporting business outcomes.

Key responsibilities include:

• Designing and developing the project related technical components. This includes data modelling, cube design, data quality assessments, data migration ETL and optimisation of data within the target platforms.
• Designing and developing the Data Lake & Warehouse technical components. This includes data modelling, ETL processing and optimisation of the platform.
• Designing and developing advanced analytics using PowerBI, other business intelligence tools, artificial intelligence or machine learning tools to provide novel insights into Audley’s data & processes that can be actioned.
• Developing new approaches and capabilities to existing challenges and innovate using new technologies to create solutions whilst optimising timelines and spend.
• Working with the Service Management team to resolve any production issues and to design improvements existing support procedures.
• Work with and coach the wider analyst community to improve business understanding of data and its impacts, running forums and seminars to illustrate key concepts.
• Assist with and develop company wide data initiatives such as data quality, data migration, GDPR and reference data streams of work.

About you

You are a self-starter with strong interpersonal skills, adaptable and a team player who takes ownership of tasks. Your curiosity and tenacity drive you to master new technologies and innovate effectively within time constraints and budget limitations. You possess excellent communication skills, capable of conveying complex ideas to technical and non-technical audiences.

Additional experience required:

• At a minimum a University Degree in Computer Science or a strongly related field, preferably at a higher level such as a Msc/Phd.
• Proven Business Intelligence and Modern Data Platform experience gained in previous roles, and strong knowledge of data product development & management best practices.
• Primary technical skills required: T-SQL, Azure Data Lake, Azure Synapse Analytics, Apache Spark/PySpark, Azure Data Factory, and Power BI. Azure Analysis Services is a nice to have.
• Extensive experience developing SQL relational databases and data warehousing technologies. Knowledge of Kimball, or similar methodology, a nice to have.
• Advanced DBA level understanding of Microsoft SQL Server concepts such as performance tuning with row or column store indexing, graph databases, or geocoding/geospatial querying.
• Good knowledge of Azure cloud services and approaches to optimize spend against requirements. Knowledge of Logic Apps, Power Apps, and Azure Cognitive Services and similar are a nice to have.
• Knowledge of Machine Learning algorithms and their practical applications, such as Decision Trees, Logistic Regression, Neural Networks, and Genetic Algorithms.
• Other skills such as Visual Studio, GIT source control, SSIS, Rest/SOAP Integration and MDX will be an advantage as will experience of DevOps / DataOps approaches to automate Build, Test and Deploy of Data Warehouse components.
• Knowledge of enterprise level GDPR, Master Data Management, Data Quality, Data Lineage, Data Migration and Reference Data design patterns and approaches.
• Desirable to have working knowledge of SalesForce, Google Ads, Microsoft Ads, or Dynamics 365 data structures.
• Inter-Personal, self-starter, adaptable, flexible, team player, takes ownership.
• Curiosity, tenacity and ability to pickup new technologies and innovate to achieve outstanding solutions in a time constrained environment while minimising spend.
• Strong communication skills for all levels of the business, both technical and non-technical. Should be able to communicate the art of the possible to a non-technical audience.
• Ability to mentor and develop other team members and assist in personal development plans.
• Ability to help formulate company data strategy and direction to ensure best use of technology going forward.

What you’ll get in return

• Holiday - 25 days rising to 30 days with length of service
• Private Medical Insurance
• Discretionary annual bonus plan
• A day off for your birthday
• A day off for volunteering to support a charity, local support group or community work of your choice
• Healthshield health cash plan - money back for costs associated with everyday healthcare (including optical, dental, medical, prescriptions, physio), and access to medical and wellbeing resources such as a GP service, employee assistance programme and counselling
• Enhanced family leave
• Enhanced pension scheme
• Life insurance
• Discounted Audley trips (for you and your friends & family) and exclusive access to staff travel discount websites
• Gympass – a wellbeing platform that gives you unlimited, discounted access to top gyms, studios, and wellbeing apps
• Benefits Platform – a reward scheme that gives you discounts and cashback with hundreds of retailers
• Sabbatical leave
• Long service awards

We believe it's our people that make the difference and who build Audley into the success it is today. We pride ourselves on enabling people to reach their full potential through promoting and celebrating a diverse and inclusive working environment.