Data Engineer

Data Engineer |London - Hybrid, 2 days per week in the office | Competitive Salary + Benefits

About the Role

We are looking for a talented and experienced Data Engineer to join the Data Engineering Team at Buyagift and Red Letter Days. Our team makes sure the right data is available to the right people, enabling a truly data-driven organisation and helping us serve our customers well.

You will design, build and maintain the data pipelines and data warehouses that power the business. You will work on projects including developing and migrating to a new data analytics platform, creating new data ingestion pipelines, and building data-driven solutions to business problems. You will also help ensure the quality, performance and security of our data infrastructure.

Key Responsibilities

• Design, build and maintain data pipelines to ingest, transform and load data from a variety of sources into our data warehouse.
• Optimise, maintain and troubleshoot pipelines so consistent, high-quality data is up to date and available.
• Develop and maintain data models that support business intelligence and analytics needs.
• Ensure the quality, performance and security of our data infrastructure.
• Follow best practices for security and infrastructure.
• Create and maintain relevant documentation.
• Collaborate with other engineering teams to build and deploy data-driven products and features.

About You

• 5+ years of experience in data engineering.
• Strong experience with SQL and ETL/ELT tools such as Fivetran and dbt.
• Experience with data warehousing on Snowflake.
• Confidence interacting with databases and web APIs and processing data.
• Good understanding of relational databases and data modelling best practices.
• Awareness of data governance and security.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Technical experience with Snowflake, Fivetran, dbt, Git source control, MS DevOps, GitHub Actions and Python.
• Azure experience is a plus.
• Experience with orchestration tooling such as Airflow is nice to have.
• Experience with infrastructure-as-code tools such as Terraform is nice to have.

Our Tech Environment

• Snowflake, Fivetran, dbt, Git source control, MS DevOps, GitHub Actions and Python.
• Data warehouses, data pipelines, databases, web APIs and cloud computing platforms.
• Azure, Airflow and Terraform are relevant additional technologies for this role.

How We Get There

• We use applied engineering best practices to solve real-world problems and make a positive impact on the business.
• We collaborate with teams across the organisation to understand data requirements and make data available through secure, stable and GDPR-compliant single sources of truth.
• We enable reporting, analytics and ad-hoc queries while focusing on data quality, performance and security.

Interview Process:

Stage 1: 30 min call with the Recruiter

Stage 2: 30 min call with the Hiring Manager

Stage 3 (Final stage): Take-home technical task (sent to you to work on in your own time)

If successful, a 1hour in person interview with the hiring manager and team member to go through the test and some stakeholder management/behavioural questions.

Our process may vary depending on role and availability. We keep candidates informed of any changes.