Analytics Engineer

Leavetheherdbehind; City Of London; On-site; GBP 42,000 - 50,000; Full time

Job summary

A dynamic coffee company in London is seeking an experienced Analytics Engineer to design and maintain Azure data infrastructure. The role involves collaboration with teams to deliver insights and ensure data quality. Ideal candidates will have strong technical skills in SQL and Azure services, and experience in data engineering. This full-time position offers benefits including a bonus, wellness programs, and opportunities for rapid career progression.

Benefits

Annual Discretionary Bonus - Up to 15%

Monthly phone bill reimbursement

Free coffee and hot drinks

High-street discounts via Wagestream

Life and wellness support programs

5% interest on savings

Pension plan with employer contribution

Free daily breakfast and snacks

Team social events

Qualifications

• 1-3 years of experience as a Data or Analytics Engineer.
• Technical skills in Azure services and relational databases.
• Ability to collaborate and solve problems effectively.

Responsibilities

• Design and maintain data pipelines using Azure Data Factory.
• Analyze data for actionable insights to drive decision-making.
• Ensure compliance with data quality and governance standards.

Skills

Proficiency in Azure Data Factory

Strong SQL skills

Data modeling

ETL workflows

Data governance knowledge

Collaboration skills

Education

Relevant degree or equivalent experience

Tools

Azure SQL Database

Power BI

Azure DevOps

Git

Job description

Job Title: Analytics Engineer

Location: SE1, London (Southwark)

Reports to: Head of Category & Product

Department: Category & Product / Data Employment

Type: Full-time in office

Salary: Up to £50,000 per annum

Role Overview

Black Sheep Coffee is seeking a skilled and motivated Analytics Engineer to design, develop, and maintain our Azure-based data infrastructure while delivering actionable insights to support data-driven decision-making across the organization.

As part of the Category & Product team, this role blends data engineering and analytics expertise to enable seamless integration of data systems, optimize workflows, and empower strategic initiatives. The ideal candidate will have a strong technical foundation in SQL, data visualization, modern data stack tools, and cloud technologies, with the ability to collaborate across teams and translate data into meaningful insights.

Key Responsibilities

1. Data Engineering & Infrastructure

• Design, develop, and maintain robust data pipelines using Azure Data Factory to integrate and process data from multiple cloud-based systems.
• Implement effective data transformation and cleansing processes to ensure data quality and consistency.
• Build and manage data models, ETL workflows, and data warehousing solutions within the Azure ecosystem.
• Monitor, troubleshoot, and optimize data workflows for performance, reliability, and scalability.

2. Insights & Collaboration

• Collaborate with data scientists, analysts, and key stakeholders to understand data requirements and deliver tailored solutions.
• Analyze data and generate actionable insights to inform company decision-making and strategic planning.
• Create and maintain documentation for data engineering processes, fostering transparency and knowledge sharing.

3. Data Governance & Best Practices

• Ensure compliance with data governance, quality, and security best practices across the organization.
• Stay updated on industry trends, tools, and best practices in data engineering and cloud technologies to drive continuous improvement.

About You

• Experience: 1-3 years as a Data or Analytics Engineer, preferably within a Microsoft stack environment.
• Technical Skills:
• Proficiency in Azure Data Factory and other Azure services (e.g., Azure SQL Database, Azure Data Lake).
• Strong SQL skills with experience in relational databases (e.g., SQL Server).
• Expertise in data modelling, ETL workflows, and data warehousing concepts.
• Knowledge of data governance, quality, and security best practices.
• Excellent problem-solving abilities and attention to detail.
• Strong communication and collaboration skills, with the ability to work across teams and functions.

Preferred Qualifications

• Experience with additional Azure data services.
• Experience with data visualization tools like Power BI.
• Knowledge of DevOps practices and tools (e.g., Azure DevOps, Git).

Benefits

• Annual Discretionary Bonus - Up to 15% of previous years earning.
• Monthly phone bills reimbursed – up to £50 per month.
• Free coffee and hot drinks at any of our locations, plus 50% off food items.
• Access to Wagesteam, offering a variety of high-street discounts.
• 5% Interest on savings through Wagestream Build Pot.
• Employee Assistance Programme (EAP) - Access to confidential counselling and advice.
• Wellness App through our EAP.
• Pension plan through NEST pensions – 3% employer contribution.
• Free daily breakfast, snacks and commercial coffee machine in the office.
• Monthly pub drinks, biannual staff socials and a fully stocked drinks fridge.
• Rapid career progression and development opportunities.

About Black Sheep Coffee…

Join the thriving team at Black Sheep Coffee, the rapidly expanding 4th largest coffee chain in the UK. With our sights set on further growth, this is an exciting opportunity to be part of our success story. Since our establishment in 2013, we have captivated coffee lovers with our commitment to quality and innovation.

As a testament to our dedication, we have risen to become one of the leading players in the UK coffee scene. With our continuous expansion plans, there has never been a more exciting time to join us. As a member of our team, you will have the chance to contribute to our upward trajectory and be part of our ambitious journey towards shaping the future of the coffee industry.

We foster a dynamic and collaborative work environment where your ideas are valued, and your professional growth is encouraged. With a strong emphasis on teamwork and a passion for excellence, we provide a supportive platform for you to thrive and make a meaningful impact. Don't miss the opportunity to be part of a rapidly growing company that values innovation, quality, and the power of exceptional coffee. Join Black Sheep Coffee today and embark on a rewarding career that offers unlimited potential.