Senior ETL SQL Data Engineer - Snowflake

W3Global Inc

Charing Cross, United Kingdom

4 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Charing Cross, United Kingdom

Airflow

Apache HTTP Server

Continuous Integration

Data Validation

ETL

Data Transformation

Data Warehousing

Monitoring of Systems

Python

Microsoft SQL Server

SQL Databases

Freeform SQL

Sql Optimization

Snowflake

Data Pipelines

Technical Primary Must Have Skills

Experience working with largescale data warehouses and highvolume datasets
Proficient in DBT Core and Advanced SQL
Experience in Python
Strong experience in designing and developing ETL pipelines
Handson experience with Reorchestration tools such as Apache Airflow Apache NiFiTalend
Experience in writing and optimizing complex SQL queries for data transformation and loading into Snowflake
Designing and implementing data models in Snowflake including schema design and optimization
Ensuring data quality integrity and consistency by implementing data validation and cleansing procedures
Monitoring and troubleshooting ETL pipelines and Snowflake data warehouse performance using Snowflake tools and other monitoring tools
Experience in Agile delivery environments

Secondary Good to Have Skills

Soft Skills

Excellent written and verbal communication skills experience working with cross functional teams and presenting to leadership
Strong ability to work with client stakeholders

Skills

Mandatory Skills : DBT, MS SQL Server, Python, Snowflake