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….