Data Engineer

Data Engineer

Reports to: Data Engineering Manager

Location: Hybrid working, with 40% office based at Farringdon, London EC1R

First a bit about the role:

We are looking for a talented and experienced Data Engineer to join our Data Engineering Team at Buyagift and Red Letter Days . The Data Engineering Team's mission is to ensure that the right data is available to the right people, enabling us to leverage data to best serve our customers and maintain a truly data-driven organisation. This involves collaborating with other teams to capture their data requirements and finding the best way to make that data available on a secure, stable single source of truth that is GDPR compliant. We enable other teams to leverage the data through reporting, analytics and ad-hoc queries.

The Data Engineering team at Buyagift and Red Letter Days is responsible for building and maintaining the data infrastructure that powers our business. We work with a wide range of technologies, including cloud computing platforms, data warehouses, and data processing frameworks. We are passionate about using data with applied best practices, to solve real-world problems and make a positive impact on our business.

In this role, you will be responsible for designing, building, and maintaining our data pipelines and data warehouses. A key part of your responsibilities will be to build and maintain analytical datasets that will be used by the insights team to answer business questions and drive decision-making. You will have the opportunity to work on a variety of exciting projects, including developing and migrating to a new data analytics platform, and creating new data ingestion pipelines. Your responsibilities also include developing and implementing data-driven solutions to our business problems, ensuring the quality, performance, and security of our data infrastructure.

A bit more about the role:

• 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 these pipelines to ensure consistent and quality data is up to date and available
• Collaborate closely with BI and insights teams to understand their data requirements and deliver analytical data sets that support reporting and insights
• Develop and optimise data models tailored for analytical queries and reporting
• Ensure the quality, performance, and security of our data infrastructure
• Adhere to best practices concerning security and infrastructure
• Create and maintain relevant documentation
• Collaborate with other engineering teams to build and deploy data-driven products and features

And now a bit about you:

• 5+ years of experience in data engineering
• Proven experience in designing and implementing data models that support business intelligence and analytics needs.
• Experience with BI tools such as PowerBI for developing analytical reports and dashboards.
• Knowledge of the data analysis lifecycle, including data collection, cleaning, transformation, analysis, and visualisation.
• Examples of conducting data analysis, identifying patterns, generating insights, and creating reports or dashboards.
• Strong experience with SQL, ETL / ELT Tools such as FiveTran and DBT
• Experience with cloud computing platforms (Azure) is a plus
• Experience with data warehousing such as SQL Server and Snowflake
• Confident 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
• Background in an analytical role is advantageous

Our Tech Environment:

• C# .NET, Python, Azure and Terraform
• Orchestration tooling (Airflow or any other orchestrator)
• Git VCS and GitLab CI
• SQL Server
• SSIS
• MS DevOps
• Snowflake
• FiveTran
• DBT
• PowerBI

We don’t expect you to have experience with all of the technologies above so if you have experience in some, please still apply!