Data Engineer

Data Engineer

£55,000 – £70,000 | Hybrid (1 day per month in Manchester)

Overview

My client is a well-established direct-to-consumer brand embarking on a data-led transformation to improve business performance and decision-making. They’re looking for an experienced, hands-on Data Engineer to design and optimise data architecture, build robust pipelines, and deliver actionable insights across the business.

Key Responsibilities

Data Engineering & SQL Development

• Own and develop the data architecture, ensuring performance and scalability.
• Design, develop, and optimise SQL queries, stored procedures, and ETL pipelines.
• Work with AWS S3 data lakes and ERP systems to extract, transform, and load data.
• Ensure data accuracy and integrity across multiple sources.
• Integrate services via RESTful APIs and manage structured/unstructured data formats.

Data Visualisation & Automation

• Build interactive dashboards in BI tools such as Power BI or Apache Superset.
• Automate KPI tracking and reporting to streamline workflows.
• Partner with teams to identify opportunities for process optimisation.
• Apply best visualisation principles for clarity and impact.
• Ensure dashboard performance and real-time accessibility for business users.

Business Reporting & Data Insights

• Collaborate with stakeholders to define KPIs and reporting needs.
• Develop self-service reporting tools for non-technical teams.
• Conduct data validation and quality assurance to ensure reliable insights.
• Support forecasting and predictive analytics to guide strategic decisions.
• Translate complex data into clear, actionable recommendations.

Required Skills & Experience

• Strong SQL expertise, including optimisation and performance tuning.
• Experience in ETL development, data modelling, and large datasets.
• Proficiency with BI tools such as Power BI, Superset, or Tableau.
• Experience with AWS data tools and governance.
• Strong analytical mindset with a focus on business outcomes.

Nice-to-Have

• Python or Airflow experience for automation.
• Knowledge of data warehouse best practices (Snowflake, BigQuery, Redshift).
• Experience with MS Business Central or similar ERP systems.
• eCommerce or omni-channel retail background.
• Exposure to machine learning and predictive analytics.

This is a great opportunity to join a fast growing, stable D2C brand that values flexibility for all their staff and a chance to take ownership of their data suite.