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.
#J-18808-Ljbffr
