Senior Data Engineer

About Blenheim Chalcot

Blenheim Chalcot is the UK's leading digital venture builder, building and investing in innovative technology companies that are transforming industries. For over two decades, they have created a unique ecosystem that provides ventures with shared services, deep operational expertise, and a collaborative network to accelerate growth and success. As a portfolio company of Blenheim Chalcot, Avado benefits from this supportive environment, enabling it to focus on its mission to unlock potential and change lives through transformative learning experiences.

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 Senior 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

• Data Architecture & Modelling : Lead the design and implementation of robust, scalable data warehouse solutions on the Azure platform, using the Kimball methodology to create efficient staging and production layers.
• ETL / ELT Development : Design, build, and maintain ETL processes to integrate data from diverse sources, including APIs. Utilise Azure Data Factory and other tools to ensure efficient and reliable data ingestion into Azure SQL Server.
• Reporting & Analytics Support : Build and manage insightful reports and dashboards using Power BI and SSRS. Collaborate with data analysts to support complex SQL queries and ensure seamless data delivery for business intelligence.
• Performance & Optimization : Analyse and optimize existing data workflows and queries for enhanced performance, scalability, and cost efficiency.
• Data Governance & Quality : Champion data quality, reliability, and integrity. Implement proactive data quality checks, monitoring processes, and data governance policies to maintain high standards.
• Automation & Version Control : Develop automated scripts using Python, PowerShell, or Bash for efficient data extraction and integration. Maintain and manage version control of all workflows and scripts using Git.
• Collaboration & Communication : Work closely with stakeholders to gather requirements, troubleshoot issues, and provide data-driven solutions. Effectively communicate complex technical concepts to both technical and non-technical audiences.
• Documentation : Create and maintain clear, comprehensive documentation for data models, processes, and workflows to support knowledge sharing.

What We’re Looking For

Required :

Desirable :

What We Can Offer You

Important

At Blenheim Chalcot, we strive to create an environment where differences are not only accepted but greatly valued; where everyone can make the most of their capabilities and potential. We promote meritocracy, competence and the sharing of ideas and opinions. We are driven by data and believe the diversity, agility, generosity, and curiosity of our people is what sets us apart as an organisation. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talent.