Analytics Engineer (DBT)

Analytics Engineer (DBT) | Outside IR35 Contract Fully Remote (UK) £450-500 per day 6 Months Initial Contract Outside IR35 We're supporting a growing, technology-led organisation as they undertake a major transformation of their analytics platform and data estate. This is a hands-on Analytics Engineering contract focused on data migration, reconciliation and rebuilding core analytics models. You'll play a key role in helping the business transition away from a legacy architecture while ensuring the accuracy, integrity and trustworthiness of critical business data.

Working closely with a small, highly collaborative data team, you'll be responsible for investigating legacy datasets, designing robust dbt models and supporting the build-out of a modern analytics environment. Key Responsibilities Build and maintain analytics models using dbt Reconcile and validate historical datasets during a major migration programme Develop and optimise SQL transformations within BigQuery Investigate and resolve data quality issues Design robust testing and validation frameworks Work closely with analysts and business stakeholders to understand legacy data structures and business rules Contribute to data governance, documentation and lineage initiatives Essential Experience Strong commercial experience with dbt Advanced SQL skills BigQuery or modern cloud data warehouse experience Data modelling and analytics engineering best practices Data migration and reconciliation projects Strong understanding of data quality, validation and testing Desirable Experience HubSpot data or CRM migration experience Data lineage/catalogue tooling (Secoda, DataHub, OpenMetadata, Atlan etc.) GCP experience Looker or modern BI tooling The Opportunity This is a chance to join a business at a pivotal stage of its data journey, helping to shape a modern analytics platform while solving complex migration and data quality challenges. If you're an Analytics Engineer with strong dbt experience and enjoy getting hands-on with data transformation, migration and modelling, I'd be keen to speak with you.