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.