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

• Experience: A minimum of 3 years of hands-on experience designing, building, and managing data warehouses, with at least 2 years of experience analysing and extracting data from diverse sources (including REST APIs).
• SQL Mastery: Demonstrated mastery of SQL, including the ability to write complex queries and create tables, views, stored procedures, and functions.
• Azure Proficiency: Expertise in the Azure data stack, including Azure Data Factory, Azure SQL Server, Azure DevOps, Key Vaults, and Logic Apps.
• ETL Tools: Proven experience building and maintaining ETL pipelines using tools such as Azure Data Factory and SSIS.
• Reporting Tools: Experience developing reports and dashboards with visualization tools like Power BI and SSRS.
• Scripting: Proficiency in scripting languages such as Python, PowerShell, or Bash for automation and orchestration.
• Generative AI: Knowledge of Generative AI principles and their practical application in data engineering.
• Version Control: Experience using source control tools, particularly Git.
• Core Competencies: Strong data modelling, problem-solving, and performance-tuning skills. Familiarity with Agile workflows and CI/CD pipelines.

Desirable:

• Cloud Cost Management: Understanding of strategies to manage and optimize Azure resource costs.
• Data Quality Tooling: Hands-on experience with tools and practices to monitor and improve data quality within a data pipeline.

What We Can Offer You

• Be part of the UK's Leading Digital Venture Builder
• Have the opportunity to be a part of and learn from the incredible diverse talent in BC
• Be exposed to the right mix of challenges, within a culture that promotes continuous learning and development and opportunity to work with Gen AI
• A fun and open, if a little cricket obsessed, atmosphere – we own the Rajasthan Royals IPL team!
• 24 days of annual leave &10 public holiday days
• Private Medical for you and your immediate family & Life Insurance for yourself

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.