Data Engineer

Title: Data Engineer

Location: Office based

Position: Permanent

Salary: £57k-£60k

About Avado

Here at Avado, we believe in unlocking potential and changing lives. We are a professional academy that helps people and companies transform and grow through interactive learning experiences in data, finance, people, technology and marketing. Our connected learning approach combines deep expertise, collaborative learning, scalable technology and award-winning learning design to deliver learner experiences for people who want real change.

What You’ll Do

In the role of Data Engineer, you will play a crucial part in shaping and maintaining Avado's data infrastructure and analytics capabilities. You will design, develop, and support robust ETL processes, maintain high-quality data models, and create insightful reporting visuals using SQL, Power BI, and SSRS. Your expertise will ensure the integrity, accuracy, and optimisation of our data workflows, proactively resolving complex challenges and facilitating effective communication between technical and non-technical stakeholders to support Avado’s strategic objectives.

Role Responsibilities

• Design, build, and maintain robust ETL (Extract, Transform, Load) processes from diverse data sources, ensuring efficient integration and scalability.
• Develop and maintain data models to support analytics, reporting, and business intelligence needs. Ensure data integrity, consistency, and compliance across all systems.
• Build and manage insightful visual reports and dashboards using tools such as Power BI and SSRS to facilitate data-driven decision-making.
• Implement proactive data quality checks and continuous monitoring processes to maintain accuracy, reliability, and integrity of data assets.
• Create and maintain clear and comprehensive documentation to support effective knowledge sharing within the team and across the wider organisation.
• Analyse and optimise existing data workflows for enhanced performance, costefficiency, and scalability.
• Collaborate with stakeholders to gather data requirements, troubleshoot issues, and provide solutions to support strategic business objectives.
• Maintain and manage version control of data workflows and scripts using source control tools such as Git.
• Develop automated scripts and utilise APIs for efficient and reliable data extraction and integration
  
  
  

What We’re Looking For

• Required:
• Knowledge of Generative AI principles and their practical application in data engineering contexts.
• Proven experience as a Data Engineer or in a similar role, with a strong understanding of data warehousing.
• Experience in building and maintaining ETL tools, such as SSIS and Azure Data Factory.
• Strong SQL skills, with the ability to build and support complex stored procedures, views, and functions.
• Experience in developing and maintaining report visuals using tools such as Power BI and SSRS.
• Excellent problem-solving skills, including performance tuning and optimisation.
• Strong communication skills, with the ability to engage effectively in both technical and non-technical environments, adapting communication style to suit different audiences, managing your workload effectively, raising issues proactively, seeking support, and presenting ideas confidently.
• Desirable:
• Experience with Source Control tools such as Git.
• Experience extracting data via APIs.
• Proficiency in programming languages such as Python.
  

What You’ll Get

Our benefits include:

• Holidays – 25 days plus bank public holidays
• Plus your Birthday off
• Life assurance
• Ride to work scheme
• Pension
• Avado learning days
• Wellness and fitness (Mindfulness and yoga)
  
  
  

And… just for being here, we offer you a culture that’s created and nurtured by super smart people and underpinned by our Values. Our Values of Accountability, Ambition, Care, Empowerment and Transparency were created for our people, by our people; they guide our thinking, decisions and actions, creating a truly unique place to work. You will also get a chance to be at the forefront of digital transformation and professional growth, enviable workspaces, serious personal development opportunity and a few nice job-related and lifestyle perks.

A Few More Things About Us

We’re proud of what we’re doing and relentless in doing the right thing. In addition to this, we can offer you:

• A home in our growing, ambitious team, whose sharp focus is growing the future skills of the workplace;
• The opportunity to truly own and be responsible for making great things happen, making a real difference and working with some of the world’s leading brands;
• A fast and furious, exciting place to be with real challenge and a meaningful opportunity
  
  
  

And we’re highly inclusive….

Avado is one of those rare places where anyone from anywhere with any background or experience is free to come and do their very best work. We believe in the diversity of thought, as that’s what helps us help our customers and learners – whether investing in their own development, or having their employer invest for them. Equality, diversity and inclusion are values that are critical to our success; come and see for yourself

By submitting your CV you understand that we have a legitimate interest to use your personal data for the purposes of assessing your eligibility for this role. This means that we may use your personal data to contact you to discuss your CV or arrange an interview, or transfer your CV to the hiring manager(s) of the role you have applied for. You can ask us at any time to remove your CV from our database by emailing recruitment@blenheimchalcot.com – but please note that this means we will no longer consider you for the role you have applied for. You can review our privacy policy here.

Here at Avado, we believe in unlocking potential and changing lives. We are a professional academy that helps people and companies transform and grow through interactive learning experiences in data, finance, people, technology and marketing. Our connected learning approach combines deep expertise, collaborative learning, scalable technology and award-winning learning design to deliver learner experiences for people who want real change.