Data Engineer

Salary: £50,000 - 60,000 per year

Requirements

• Strong proficiency in SQL including complex joins, window functions, CTEs, and performance tuning.
• Hands-on experience with Snowflake including tasks, stages, RBAC, warehouses, and resource monitors.
• Working knowledge of dbt including models, tests, sources, documentation, and packages.
• Experience building and maintaining production-grade data pipelines in a cloud environment.
• Familiarity with at least one scripting language, with Python preferred, for data processing tasks.
• Understanding of medallion architecture patterns.
• An effective communicator who can work cross-functionally with technical and non-technical stakeholders.
• Experience with Azure services including Blob Storage, Data Factory, and DevOps (preferred).
• Familiarity with BI tools such as Sigma Computing and Power BI, including DAX and Power Query (preferred).
• Domain knowledge of aviation data such as schedules, fleet, financial, or operational datasets (preferred).

Responsibilities

• Designing, developing, and maintaining ELT/ETL pipelines using Snowflake, dbt, and SQL to transform raw aviation data into analytics-ready datasets.
• Building and optimising Snowflake objects including stages, tasks, stored procedures, dynamic tables, and streams.
• Identifying cost optimisation within warehouse use and query structures.
• Implementing data quality frameworks, monitoring, and alerting across bronze, silver, and gold data layers.
• Collaborating with product, data, and commercial teams to translate business requirements into scalable data models.
• Managing cloud storage integrations including Azure Blob and GCS and orchestrating automated ingestion workflows.
• Maintaining documentation, version control using Git, and CI/CD processes for all data assets.
• Playing an active role in future hiring decisions as the team grows.

Technologies

• Azure
• CI/CD
• Cloud
• DAX
• DevOps
• ETL
• Git
• Power BI
• Power Query
• Python
• RBAC
• SQL
• Snowflake
• dbt
• GitHub

More:

At RDC Aviation, we are a leading provider of aviation data, analytics, and software solutions, empowering airlines, airports, and financial institutions with actionable insights through our innovative data platforms and APIs. This role is a unique opportunity to be a founding driver of our data engineering function, with a focus on helping us develop and optimize our practices. We offer a flexible hybrid working model, private healthcare, 25 days of holiday plus bank holidays, an auto-enrollment pension scheme, and a supportive work culture focused on your wellbeing.