3 of 3 Snowflake Schema Jobs in the North West

reporting Your Skills and Experience Strong commercial experience as a Data Engineer with solid foundations in SQL and dimensional modelling Experience working with Snowflake or similar cloud data warehouses such as BigQuery Good Python capability, including orchestration tools such as Airflow Proven experience building and managing data ingestion pipelines ...

expert for query performance optimisation (Spark execution plans, data skew, joins) Design and implement dimensional data models (star/snowflake schemas) Architect the semantic layer for BI (Omni or similar tools like Looker) Build CI/CD pipelines to automate testing and deployment Work with stakeholders across Product, Finance … data architecture Deep experience with Databricks (Lakehouse, Delta Lake, Unity Catalog) Expert SQL and distributed computing knowledge Strong experience with data modelling (star/snowflake schemas) Proven experience migrating legacy data platforms Ability to optimise performance across large datasets Experience with modern BI semantic layers (e.g. Looker, Omni, Superset ...

Opus are working with a leading financial services firm who're decommissioning their legacy on-prem data warehouse and migrating all critical workloads to Snowflake on AWS. They need a contract Senior Data Engineer to rebuild pipelines, refactor legacy ETL, and ensure a clean cutover for regulatory and analytics … teams. You'll be joining an existing team of 3 Data Engineers and one Architect who're working on this project. Responsibilites: Snowflake migration - Rebuild models, schemas, and ELT pipelines AWS data engineering - Glue, Lambda, S3, Step Functions Legacy decommissioning - Analyse ETL, lineage, dependencies Data reconciliation - Validate parity between ...