Remote Staff Data Engineer Job in London, UK Zendesk

Who you are

• 8+ years of data engineering experience building, maintaining and working with data pipelines & ETL processes in big data environments.
• Extensive experience with SQL, ideally in the context of data modeling and analysis.
• Hands-on production experience with dbt, and proven knowledge in modern and classic Data Modeling - Kimball, Inmon, etc.
• Proficiency in a programming language such as Python, Go, Java, or Scala.
• Experience with cloud columnar databases (Google BigQuery, Amazon Redshift, Snowflake), query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience with processes supporting data transformation, data structures, metadata, dependency, ensuring efficient data processing performance and workload management.
• Excellent communication and collaboration skills.
• Thrive in ambiguous situations, possesses a proactive problem-solving attitude.

Desirables

• Experience with BigQuery, Snowflake, or similar cloud warehouses.
• Familiarity with AI tools and techniques that could be applied to data analysis and data transformation tasks.
• Completed projects with dbt.
• Familiarity with Lean/6 Sigma principles and an understanding of CRM analytics.

What the job involves

• Collaborate with team members and internal stakeholders to understand business requirements, define successful analytics outcomes, and design data models.
• Develop, automate, and maintain scalable ELT pipelines in our Data Warehouse, ensuring reliable business reporting.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Design & build ELT based data models using SQL & DBT.