Square One Resources
Data Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Engineer – DBT / Airflow / BigQuery
Location: London – Hybrid (3 days per week)
Duration: 6 months, likely to extend to 12 months
Role Overview
We are looking for an experienced Data Engineer to design, build and support scalable data pipelines and analytics-ready data models across GCP and AWS.
The role will focus on DBT, Airflow, BigQuery, Python and SQL, alongside CI/CD, Infrastructure as Code and cloud data engineering.
Key Responsibilities
- Build and maintain DBT Cloud models, transformations, tests, macros, SCDs and deployment processes.
- Design and optimise Airflow DAGs, including scheduling, dependencies, monitoring, retries, idempotency and backfills.
- Develop and optimise BigQuery data pipelines, queries and data models, with a focus on performance and cost.
- Develop robust Python and SQL for data transformation, automation and pipeline development.
- Build and maintain CI/CD and IaC processes using GitHub Actions, Bitbucket, Bamboo, Terraform and/or CloudFormation.
- Support data pipelines and integrations across GCP and AWS.
- Implement data quality, testing, monitoring and production support processes.
- Troubleshoot pipeline and performance issues, including incident response and root-cause analysis.
- Work closely with analytics, product, platform and engineering teams.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Technical Requirements
- Strong hands-on experience with DBT / DBT Cloud, including models, tests, macros, SCDs and release processes.
- Strong Airflow experience, including production DAG development and workflow optimisation.
- Strong BigQuery experience, including performance and cost optimisation.
- Advanced SQL and solid Python development skills.
- Strong data modelling experience across fact/dimension models and SCD patterns.
- Experience with GCP and AWS data environments.
- Experience with CI/CD and Terraform or CloudFormation.
- Understanding of cloud security, IAM, data governance and access controls.
- Experience supporting production data platforms.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Experience
- 8+ years' experience in Data Engineering or a similar technical role.
- Strong problem-solving and troubleshooting skills.
- Excellent communication and stakeholder management.
- Comfortable working independently and across multidisciplinary teams.
- Experience working in Agile environments, with JIRA and Confluence.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location