Job Summary
Company Description
Our partner is a leading technology company headquartered in Cluj-Napoca, with offices in Oradea and Munich. Over the past 17 years, the company has been establishing itself as an employer of choice for IT professionals who are passionate about problem-solving through technology and want to have a measurable impact through their work.
A trusted partner for major brands in Retail, Consumer Goods, Manufacturing, and Automotive, they help businesses embrace flexibility, adaptability, and evolution within their digital journey, through a large spectrum of tailored IT services, leveraging mainstream, niche, as well as legacy technologies.
Its sister company delivers complex digital evolution solutions for highly regulated industries like Insurance and Banking and, together, the two companies cover the complete digital evolution journey of their customers, from hardware to software and managed services solutions.
With more than 700 IT professionals in its 13+ Competency Areas, the two sister companies join forces to build a distinctive people-first culture that enables their people to thrive, their clients’ business to evolve, and end-users to succeed.
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.
