Data Engineer

Business Stream; City of Edinburgh; On-site; GBP 40,000 - 46,000; Full time

Job summary

Business Stream, a leading water retailer in the UK, seeks a Data Engineer to enhance its data-driven approach. In this role, you will develop ETL processes, collaborate with analysts, and drive positive change through effective data utilization. We offer competitive compensation, a hybrid working environment, and numerous employee benefits.

Benefits

31 days annual leave and six bank holidays

Subsidised staff restaurant

Free gym membership

Salary sacrifice schemes including electric vehicles

Qualifications

• Strong grasp of the Microsoft Cloud ecosystem and modern DevOps practices.
• Hands-on experience in data ingestion, transformation, and management.
• Ability to design scalable and efficient data solutions.
• Experience with Big Data technologies.

Responsibilities

• Develop and optimise ETL processes to ensure data is readily available and useful.
• Create dynamic scripts for the ingestion of data with clear documentation.
• Collaborate with Power BI developers and business analysts.
• Foster a data-centric culture by making data accessible for decision-making.
• Contribute to strategic planning and performance evaluations.

Skills

SQL

Microsoft Fabric

Azure Data Factory

Data Ingestion

Data Transformation

Job description

Social network you want to login/join with:

Are you ready to take your data engineering skills to the next level? We are looking for a talented Data Engineer to join our innovative team and work closely with our Data Lead to implement a cutting-edge Business Intelligence (BI) platform. This is your chance to make a significant impact on our company's reporting and analytics capabilities!

About the Role

As a Data Engineer, you will play a crucial role in transforming our organisation into a data-driven enterprise. Your primary responsibilities will include data ingestion from diverse source systems, development of data pipelines through both ETL tools and programming languages such as Python. You’ll ensure that this data is structured, optimised, and accessible for our Power BI developers and business analysts, empowering them to turn data into actionable insights.

Key Responsibilities

• Develop and optimise ETL processes to ensure data is readily available and useful.
• Create dynamic scripts for the ingestion of data with clear documentation.
• Collaborate with Power BI developers and business analysts to ensure data meets their needs.
• Foster a data-centric culture by making data accessible and actionable for decision-making.
• Contribute to strategic planning and performance evaluations through effective data utilisation.

About you

We’re seeking a talented data professional with a strong grasp of the Microsoft Cloud ecosystem and modern DevOps practices. You bring hands-on experience in data ingestion, transformation, and management, with a proven ability to design scalable and efficient data solutions. You're confident working with Big Data technologies and tools such as SQL, Microsoft Fabric, and Azure Data Factory (ADF), and you know how to turn complex data challenges into streamlined, reliable systems.

You will excel in data warehouse modelling, especially with Kimball methodology and Medalion architecture approaches. With your sharp analytical skills and a passion for problem-solving, you’re not just about the numbers - you love coaching and helping others grow their technical knowledge too! Your attention to detail and organisational skills make you a fantastic team player who prioritises tasks to get things done efficiently.

Your focus is all about driving positive change and making a real impact in the data analytics space!

What’s in it for you?

You’ll be a key team player in one of the largest water retailers in the UK, with lots of benefits and the chance to grow your career.

• Salary up to £46,000 plus bonus up to 20%
• 31 days annual leave and six bank holidays
• Monday to Friday based in our office within Edinburgh Park
• Hybrid working – 3 days office, 2 at home dependent on business requirements
• Subsidised staff restaurant and free gym membership
• Salary sacrifice schemes including electric vehicles and cycle to work

Why we’re the right fit

We’re passionate about providing a great place to work, where our colleagues feel trusted, valued, supported and empowered, whatever their background or role. And we’re committed to providing an inclusive workplace that welcomes and promotes diversity and provides equal opportunities for everyone. In everything we do, we’re driven to make a positive difference, and always strive to do the right thing by our customers, our people, our local communities and the environment. Life at Business Stream is fast-paced and exciting, where no two days are the same.

Who we are

Business Stream is one of the largest water retailers in the UK and a trusted service provider to over 300,000 business customers. With over 17 years’ experience of operating in a competitive water market – longer than any other retailer – we’re the chosen service provider for businesses and organisations ranging from small corner shops to large industrial estates. Headquartered in Edinburgh and employing around 350 people, we provide a range of services including metering and billing, water efficiency support and, water and waste water management solutions.

How to make this job all yours

We’re looking to welcome exceptional people into our fantastic, high-performing team so if you think this job is for you, we’d love to hear from you. To apply, please click the ‘Apply’ button at the bottom of this page, and send us a copy of your CV. The closing date for applications is Wednesday 23 July at 5pm.

A Disability Confident Committed Employer

If you consider yourself to have a disability, we encourage you to disclose that as part of your application. That means we can provide the necessary support and use your unique talents effectively.