Job Title: Data Engineer
Location:
Chester (1 day every 2 weeks)
Department:
Data & Analytics
Salary:
£65,000 - £75,000
About The Team
This forward-thinking team in the e-commerce space is looking for a highly skilled and motivated Data Engineer to join the dynamic team to 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 this team 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.
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.
* Data Quality & Validation:
Implement processes to monitor and ensure the accuracy, completeness, and consistency of data.
* 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
* Cycle to work scheme
* Continuous training