Senior Transformation Pipeline Engineer
Sheffield, Yorkshire, United Kingdom
Hybrid / WFH Options
Hybrid / WFH Options
Synechron
Role: The crux of the job is to design, build, test and deploy data APIs for downstream consumers to access the data on Google BigQuery Warehouse. The Data Engineer will also optimise data and API granularity, flexibility and autonomy with the use of materialised views, query parameters, schema design … etc. to manage trade-offs between data volumes, scope, timing and performance. Design, build, test and deploy Google Cloud data models and transformations in BigQuery, Datafusion environment (eg SQL, stored procedures, indexes, clusters, partitions, triggers, etc.) Optimize data views for specific visualization use cases making use of schema design … to scope, quality, and time expectation Job requirements: Expert in database design - both relational and dimensional data models (and preferably Data Vault) in Google BigQuery or similar Cloud technology 1+ years of proven recent experience developing, refactoring, optimization of SQL/T-SQL Expertise in Administration and Development of more »
Employment Type: Contract
Rate: GBP Annual
Posted: