Senior Data Warehouse Engineer

at  Newday

London, England, United Kingdom -

Start DateExpiry DateSalaryPosted OnExperienceSkillsTelecommuteSponsor Visa
Immediate20 Jan, 2025Not Specified21 Oct, 2024N/APerformance Tuning,Time Travel,Distributed Systems,Docker,Kafka,Code,Dbt,Infrastructure,Snowflake,Design PatternsNoNo
Add to Wishlist Apply All Jobs
Required Visa Status:
CitizenGC
US CitizenStudent Visa
H1BCPT
OPTH4 Spouse of H1B
GC Green Card
Employment Type:
Full TimePart Time
PermanentIndependent - 1099
Contract – W2C2H Independent
C2H W2Contract – Corp 2 Corp
Contract to Hire – Corp 2 Corp

Description:

WHAT YOU’LL BRING - ESSENTIAL SKILLS

Proficient knowledge of Snowflake (Columnar databases), Jupyter notebooks, Airflow, and Docker.
Strong Python and SQL coding abilities.
Familiarity with distributed systems, APIs, and cloud computing patterns.
Understanding of virtualization/containerization.
Experience with EKS/Kubernetes and DevOps tools, particularly GitHub Actions.
Understanding of AWS infrastructure and services (S3, EKS, IAM, Storage Gateway, Athena).
Proficient in Terraform or a solid understanding of Infrastructure as Code (IaC).

DESIRABLE SKILLS

Expertise in Snowflake concepts such as resource monitors, RBAC controls, virtual warehouse setup, query performance tuning, and time travel.
Experience with Kafka and DBT.
Understanding of Data Vault design patterns and cloud/network configurations (Firewalls, Proxies).
Familiarity with AWS networking (VPC, VPN, Direct Connect, Route 53, Auto Scaling, CloudWatch, GuardDuty).

Responsibilities:

As a Senior Data Warehouse Engineer specializing in Snowflake, you will lead the architecture, design, and implementation of our data warehouse in a multi-tenant environment. Collaborating with Platform Engineers, Technical Architects, Data Engineers, and Analysts at NewDay and with B2B customers, you’ll ensure that the platform’s performance, reliability, and security meet the needs of multiple teams.


REQUIREMENT SUMMARY

Min:N/AMax:5.0 year(s)

Information Technology/IT

IT Software - DBA / Datawarehousing

Software Engineering

Graduate

Proficient

1

London, United Kingdom