Descriere
About the role
We are hiring for a major customer and looking for a Senior Analytics Engineer to join a large-scale data platform modernisation initiative in the Google Cloud ecosystem, supporting the migration of enterprise data warehouse workloads from Teradata to BigQuery.
In this role you will discover and manage the central Common Data Model (CDM) hub, support the creation of new data spokes for consuming teams, and build a deep understanding of the data model and business KPIs to ensure they are implemented consistently and used correctly across the platform.
Responsibilities
- Build and maintain data pipelines: design, develop and optimise scalable data transformation pipelines in BigQuery using Dataform and SQL.
- Drive data warehouse migration: support the transition from Teradata to BigQuery by analysing, translating and validating existing data models and logic.
- Own the Common Data Model: discover, document and manage the CDM hub, ensuring consistency, governance and seamless data consumption across teams.
- Enable data platform adoption: support the onboarding of new CDM consumers with guidance on data model usage and integration best practices.
- Align data with business goals: analyse business KPIs and ensure their definitions, calculations and usage are accurately reflected in the data model.
- Act as a data model expert: maintain deep knowledge of data structures, lineage and semantics, serving as a key reference point for stakeholders.
- Ensure data quality and trust: drive testing, validation and reconciliation across Teradata and BigQuery environments.
- Optimise platform performance: improve BigQuery workloads for performance, cost efficiency and long-term maintainability.
- Promote engineering standards: contribute to documentation, modelling standards and best practices.
- Collaborate across teams: partner with engineers, analysts, architects and business stakeholders to deliver trusted data products.
Must have
- Professional experience as an Analytics Engineer, Data Engineer or BI Engineer, with a senior level of ownership and autonomy.
- Strong, hands-on SQL expertise, including complex transformations, analytical queries and performance optimisation.
- Practical experience with Google Cloud Platform, in particular BigQuery.
- Hands-on experience with Dataform, or a similar SQL-based transformation framework such as dbt, with willingness to work with Dataform.
- Solid understanding of data modelling concepts: dimensional modelling, layered architectures, hub-and-spoke and common data model approaches.
- Ability to translate business KPI definitions into correct, maintainable data model implementations.
- Experience ensuring data quality through testing, validation and reconciliation of datasets.
- Regular and responsible use of AI tools to improve productivity and quality of outcomes, including structuring effective prompts and critically validating outputs.
- Excellent English communication skills and the ability to explain design decisions to technical and non-technical stakeholders.
Nice to have
- Hands-on experience with Teradata (Teradata SQL, BTEQ) or with Teradata-to-BigQuery migration projects.
- Python for data processing, automation or tooling.
- Other GCP data services: Cloud Composer / Airflow, Dataflow, Pub/Sub, Cloud Storage, Dataplex.
- Familiarity with BI and reporting tools such as Looker, Power BI or Tableau.
- Exposure to data governance, cataloguing or lineage practices and tooling.
- CI/CD and infrastructure-as-code practices applied to data pipelines.
- Google Cloud certification, for example Professional Data Engineer.
