Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Data Engineer to optimise data workflows and enhance reporting capabilities.
- Company: Be part of an award-winning retail leader based in Avonmouth, known for innovation.
- Benefits: Enjoy hybrid work flexibility, a 7.5% annual bonus, health plans, and generous staff discounts.
- Why this job: Make an impact by leading cloud migrations and empowering stakeholders with data accessibility.
- Qualifications: Experience with SQL Server, Azure tools, and ETL processes is essential; strong communication skills are a must.
- Other info: This role offers a dynamic environment with opportunities for growth in a tech-driven team.
The predicted salary is between 36000 - 60000 £ per year.
Data Engineer required by our market leading, award winning, retail sector client based in Avonmouth. This is a hybrid role with 2 days a week onsite but with flexibility.
The Data Engineer will oversee the technical aspects of Reporting & BI solutions within the Technology team, providing robust reporting capabilities to support Commercial, Operational, and Finance functions.
Main Responsibilities
- Analyse, optimise, and refactor existing stored procedures, ETL jobs, and data workflows to improve performance and reduce load times on the current data warehouse.
- Clean up and enhance the efficiency of the current Power BI Premium (P1) instance, ensuring optimal resource allocation and utilisation as data volumes and complexity grow.
- Review and maintain the scheduling of data jobs to ensure timeliness and reliability, improving operational processes to meet evolving business needs.
- Implement data quality checks, governance, and performance monitoring for both ETL processes and reporting outputs.
- Lead and actively execute the long-term migration of the on-premises data warehouse to Microsoft Fabric, including hands-on development and implementation of a robust strategy for transitioning datasets, ETL pipelines, and reporting solutions to the cloud.
- Build scalable ETL processes using Azure Data Factory, Azure Synapse, and other Fabric-native tools, ensuring a smooth integration between the on-prem and future cloud environments.
- Design and implement Azure-based data architecture, leveraging tools like Azure Data Lake, Azure Synapse Analytics, and Fabric’s data capabilities to future-proof the platform.
- Utilise Azure tools such as Synapse Analytics, Logic Apps, and Azure Functions to streamline data processing and orchestration across the business.
- Empower stakeholders to build their own reports and dashboards by enhancing data accessibility and developing self-service capabilities.
Required Background
- Extensive experience in maintaining and optimising on-premises SQL Server data warehouses, focusing on stored procedures, indexing, partitioning, and load performance.
- An understanding of Azure cloud tools such as Azure Synapse Analytics, Azure Data Lake, Azure Data Factory, and Logic Apps.
- Proficiency in writing advanced SQL queries, stored procedures, and Python scripts for data manipulation, pipeline development, and automation.
- Experience with ETL tools (both on-prem like SSIS, and cloud-based like Azure Data Factory) for creating, optimising, and maintaining data pipelines.
- Skilled in Power BI Premium, including data modelling, DAX, performance tuning, and advanced reporting features like composite models and incremental refresh.
- Strong understanding of data governance, security best practices, and compliance requirements (GDPR, etc.).
- Experience working with Agile methodologies.
- Excellent communication skills, capable of collaborating with both technical and non-technical stakeholders to translate business needs into effective data solutions.
The 'Nice to Haves'
- Experience with Microsoft Dynamics 365 Business Central.
- Experience of defining and operating within data management best practice frameworks.
- Experience working in a Retail environment.
This fantastic opportunity comes with a competitive starting salary which is accompanied by the following benefits: 7.5% annual bonus, Mobile Phone, Health Cash Plan, Life Assurance, 25 days annual leave and a generous staff discount to name but a few.
Contact Detail:
Artis Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Familiarise yourself with Azure tools like Azure Data Factory and Azure Synapse Analytics. Understanding these platforms will not only help you in interviews but also demonstrate your commitment to the role and its requirements.
✨Tip Number 2
Brush up on your SQL skills, especially around stored procedures and performance tuning. Being able to discuss specific examples of how you've optimised data workflows will set you apart from other candidates.
✨Tip Number 3
Network with professionals in the retail sector or those already working at StudySmarter. Engaging with current employees can provide insights into the company culture and expectations, which can be invaluable during the interview process.
✨Tip Number 4
Prepare to discuss your experience with data governance and compliance, particularly GDPR. This is a critical aspect of the role, and showcasing your knowledge will demonstrate your readiness to handle sensitive data responsibly.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server data warehouses, Azure tools, and ETL processes. Use specific examples that demonstrate your skills in optimising data workflows and implementing data quality checks.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the Data Engineer role and how your background aligns with the responsibilities outlined in the job description. Mention your experience with Power BI and Azure, and how you can contribute to the company's goals.
Showcase Relevant Projects: If you have worked on projects involving Azure Data Factory or data migration to cloud environments, be sure to include these in your application. Highlight any specific challenges you faced and how you overcame them.
Highlight Communication Skills: Since the role requires collaboration with both technical and non-technical stakeholders, emphasise your communication skills in your application. Provide examples of how you've successfully translated complex data concepts into understandable terms for diverse audiences.
How to prepare for a job interview at Artis Recruitment
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL Server, Azure tools, and ETL processes in detail. Bring examples of how you've optimised data workflows or improved performance in previous roles, as this will demonstrate your hands-on expertise.
✨Understand the Business Context
Research the retail sector and understand how data engineering supports commercial and operational functions. This knowledge will help you articulate how your skills can directly benefit the company and its goals.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems related to data migration or performance tuning. Practise articulating your thought process and decision-making steps clearly, as this will showcase your analytical skills.
✨Demonstrate Communication Skills
Since the role involves collaborating with both technical and non-technical stakeholders, be ready to explain complex concepts in simple terms. Highlight any past experiences where you successfully communicated technical information to a non-technical audience.
