Lead Data Analyst - 8 Month FTC (London)

Overview

Our client is currently progressing their Analytics Data platform migration. They have a team of Analytics Engineers and Data Engineers driving the migration of a large-scale on-prem Oracle data warehouse to Google Cloud Platform (GCP) BigQuery. The team is responsible for building and maintaining analytical data models and ETL workflows to enable a modern, scalable data platform supporting analytics and data science initiatives.

Key Responsibilities

• Collaborate with Data Engineers to support the migration of data models from Oracle to BigQuery using DBT and ELT pipelines.
• Develop, optimise, and maintain analytical data models following the Medallion architecture within BigQuery.
• Translate complex Oracle table structures into scalable GCP data models to support analytical use cases.
• Work with ingestion pipelines leveraging Kafka (in batches) and Dataflow to ensure reliable data availability in BigQuery.
• Contribute to the build-out of the analytical data warehouse, ensuring data quality and governance standards are upheld.
• Engage with prioritised migration plans to lift and shift tables and data models, targeting 60% migration completion within the year and full migration by mid-2025.
• Participate in code freezes and deliverables aligned with project timelines, with onboarding into Rightmove targeted for late October/early November.

Required Skills And Experience

• Strong proficiency in SQL and data modeling best practices.
• Hands-on experience with GCP BigQuery and cloud-based ETL/ELT workflows.
• Practical knowledge of DBT for data transformation and modeling.
• Experience working with data ingestion from batch/streaming sources such as Kafka and Dataflow or similar tools.
• Prior involvement in data platform migrations, particularly transitioning from Oracle data warehouses to cloud platforms, is highly desirable.
• Ability to work effectively in a collaborative, agile team environment focused on delivering large-scale data migration projects.

Joining AND

• We're built for people - like, real humans. Not ‘resources' or ‘staff'. That means happiness and wellbeing really do matter to us, and we hate unnecessary hierarchy and bureaucracy.
• There's no well-trodden path ahead: AND is growing fast and forging a new trail. That's exciting, and gives us all the autonomy and opportunity we love - but bear in mind it also demands focus, patience and resilience.
• Diversity is a priority. After all, to build great products that a wide variety of different people love to use, we need a wide variety of people to help us build them. So diversity is more than a policy or a word: it's business critical for us.

Seniority level

• Not Applicable

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at AND Digital by 2x