Data Engineer

Job Title: Data Engineer

Location:Leeds ( 1 day every 2 weeks)

Department:Data & Analytics

Salary:£70,000 - £80,000

About Us

One of the UK’s leading services for selling items in one simple, hassle-free process. With a mission to promote sustainability and support a circular economy, as they expand into new markets, they are looking for a highly skilled and motivated Data Engineer to join the dynamic team and help elevate their data infrastructure and analytics capabilities. If you have experience with Snowflake, digital marketing analytics, and are familiar with Hubspot’s data, I want to hear from you!

Role Overview

As a Data Engineer, you will play a crucial role in developing and maintaining the data architecture, pipelines, and reporting frameworks that enable our teams to make data-informed decisions. You will work closely with both technical and marketing teams, ensuring data accuracy, integrity, and scalability. Your experience with Snowflake, digital marketing analytics, and Hubspot will be key to delivering insights that drive growth and optimisation across our digital channels.

This will be the company’s second data hire as it looks to build out its data capabilities. You should possess a good working knowledge of data warehousing as well as what best practice looks like when undertaking data engineering.

Key Responsibilities

• Data Architecture & Pipeline Development:
• Design, implement, and maintain robust and scalable data pipelines, ensuring seamless integration and flow of data across multiple systems.
• Data Integration:
• Manage and integrate a wide variety of data sources into the data warehouse, ensuring consistency and quality across the data ecosystem. These sources include Adalyser, Meta Ads, Google Ads, Hubspot and Aircall along with performance tracking data, product imagery and metadata from bespoke platforms.
• Data Quality & Validation:
• Implement processes to monitor and ensure the accuracy, completeness, and consistency of data. Conduct regular data audits and resolve data issues as needed.
• Optimisation & Automation:
• Identify opportunities for automation and optimisation of data workflows and reporting processes, driving efficiency across the business.
• Collaboration:
• Work closely with business users across all departments to understand key KPIs, metrics, and insights needs, translating them into actionable data solutions.
• Documentation & Best Practices:
• Document data architecture, processes, and workflows, ensuring a clear understanding of the data ecosystem and promoting best practices within the team.

Required Skills and Experience

• Solid experience in managing and optimising Snowflake environments, including data loading, querying, and creating views and stored procedures. Knowledge of data cataloguing tools and governance best practices preferred.

• Experience in working with Hubspot data, including extracting, transforming, and loading (ETL) Hubspot data into a central data warehouse. Familiarity with Hubspot’s reporting tools is a plus.

• Strong SQL skills, with experience in writing complex queries to manipulate and extract insights from large datasets.

• Experience with ETL, rETL, IR tools and frameworks such as Airflow, dbt, FiveTran, Coalesce, HighTouch, Rudderstack, Snowplow, or similar.

• Strong analytical mindset with a focus on data accuracy, troubleshooting, and resolving complex data issues.

• Ability to communicate complex technical concepts to both technical and nontechnical stakeholders.

Preferred Qualifications:

• Experience with marketing automation tools and CRMs (e.g., Hubspot, Marketo, Salesforce).
• Familiarity with cloud-based data solutions and services.
• Understanding of statistical analysis and A/B testing methodologies.
• Experience in Python or R for data analysis and automation is a plus.

Benefits:

• Competitive salary and performance bonuses
• Comprehensive health and wellness benefits
• Flexible work schedule and remote work options
• Professional development opportunities
• Dynamic and creative work environment