Lead Data Analytics Engineer – Data Platform Transformation
£500 per day (Inside IR35)
12-month contract
Hybrid working – Central London
A major UK organisation is undertaking a large-scale data warehouse re-architecture and migration programme and is looking for a Lead Analytics Engineer to join on a long-term contract.
This is a hands-on, highly cross-functional role where you will work across multiple business and technical teams to solve complex data problems. You will play a key role in shaping the next generation of data assets, helping move from legacy architecture to a simpler, more scalable, and analytics-friendly platform.
This programme is not a lift-and-shift migration. It focuses on rethinking how data is modelled, accessed, and used, with an emphasis on clarity, scalability, and enabling faster, better decision-making.
We are particularly interested in individuals who have thrived in less structured, fast-moving environments—where ownership, problem-solving, and adaptability are critical.
What You’ll Do
- Work across multiple teams and business domains to understand problems and deliver effective data solutions
- Design and build scalable, well-structured data models in a modern warehouse environment
- Translate complex requirements into clear, maintainable SQL-based transformations
- Lead data migrations, including historical backfills and zero-downtime cutovers
- Collaborate closely with Analytics Engineers, Data Scientists, Product, and Engineering teams
- Help define and evolve data standards, modelling approaches, and best practices
- Enable teams by delivering high-quality, trusted datasets that are easy to use and understand
- Clearly articulate trade-offs in tooling and design decisions, explaining not just what to use, but why
Technical Environment
- dbt (SQL-first modelling)
- Airflow orchestration
- BigQuery (or similar cloud data warehouse such as Snowflake)
- Data sourced from transactional, operational, and product systems
- Mix of open-source, cloud, and internal tooling
Required Experience
- Strong experience in data modelling, ETL/ELT, and building scalable data pipelines
- Advanced SQL skills and deep understanding of data warehousing principles
- Experience working with large-scale datasets
- Hands-on experience with dbt and modern data stack tooling
- Experience designing data solutions that support analytics and reporting use cases
- Background can be from any industry (not limited to financial services), provided strong data engineering/analytics experience
What We’re Looking For
- Experience working in dynamic, less structured environments (e.g. startups, scale-ups, or transformation programmes)
- Strong cross-functional mindset—comfortable working across teams to solve problems
- Ability to rationalise technical decisions, clearly explaining the reasoning behind tools and approaches
- Excellent stakeholder management skills, with the ability to influence both technical and non-technical audiences
- Clear, concise communicator—able to explain complex ideas simply and effectively
- Proactive, adaptable, and comfortable taking ownership in ambiguous situations
…