Lead Data Analyst, AND Digital
8 Month FTC
Developing & delivering digital products and platforms
Job no longer available
Developing & delivering digital products and platforms
1001+ employees
Job no longer available
1001+ employees
Company mission
To close the world's digital skills gap.
Role
Who you are
- 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
What the job involves
- 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
- 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), 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
Salary benchmarks
Our take
As the need for digital transformation continues to grow, many organisations find themselves lacking the skills to keep up. AND Digital has stepped in to help bridge this gap, with a clear mission to close the world's digital skills shortage. Rather than simply delivering digital solutions, they focus on helping businesses understand how to work digitally, so they can continue to grow and adapt long after a project is finished.
The company is standing out from the crowd too, by working alongside their clients instead of working for them. Combining their own people with client teams into one collaborative unit, they identify challenges, build digital products, and share skills throughout the process, so clients can take full ownership of their apps, websites, and future digital work.
Unsurprisingly, this approach has had a strong impact and continues to drive AND Digital's growth. With cross-functional teams across the UK, the Netherlands, and the US East Coast, the company scales based on demand. And their city-based 'Club' model blends local, personalised service with the strength of a global organisation, putting AND Digital in a strong position for the future.
Steph
Company Specialist at Welcome to the Jungle
Insights
Company
Funding (2 rounds)
Apr 2021
$10.6m
EARLY VC
Feb 2020
$14.6m
EARLY VC
Total funding: $25.2m
Company HQ
Maidenhead, UK
Leadership
Paramjit Uppal
(Founder)Former Founder of Qedis (brought out by North Highland UK in 2013) and Director at Deloitte.
Share this job
View 22 more jobs at AND Digital