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