Overview
The Analytics Engineer (DBT) will play a crucial role in transforming and modernizing the analytics platform of a technology-led organization. Working within a collaborative data team, this hands-on position focuses on data migration, reconciliation, and the development of robust analytics models using dbt. This role is designed for a professional with a passion for data integrity and quality, as they navigate the complexities of transitioning from legacy systems to a modern data architecture.
Responsibilities
- Build and maintain analytics models using dbt.
- Reconcile and validate historical datasets during a major migration program.
- Develop and optimize 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.
Requirements
- Strong commercial experience with dbt.
- Advanced SQL skills.
- Experience with BigQuery or modern cloud data warehousing.
- Knowledge of data modeling and analytics engineering best practices.
- Experience in data migration and reconciliation projects.
- Strong understanding of data quality, validation, and testing.