Staff Data Engineer

Key Skills

Aartificial intelligence, Amazon RedShift, AWS, Data Biuld Tool - dbt, Data pipelines, Data Warehousing, Effective communication skills, ETL frameworks, Github, Google BigQuery, Java Programming, Kubernetes-K8s, Looker, Optimization, Python Programming, Scala Programming, Snowflake, SQL, Tableau, Terraform

Job Description

The ‘Zendesk Analytics Prototyping’ (ZAP) team is looking for an experienced Staff Data Engineer to support the team’s charter to accelerate CRM measurements and insights, and help promote a data-centric approach to improving customer support tools and operations. To realize that mission, we build and maintain robust, fine-grained, and contextually rich datasets, providing a foundation for developing insights that help enhance Zendesk’s support operations.

The role will be responsible for closely partnering with Software Development Engineers and Business Intelligence Engineers to build high quality data pipelines and manage the team’s data lake. You’ll work in a collaborative environment using the latest engineering best practices with involvement in all aspects of the software development lifecycle. You will craft and develop curated datasets, applying standard architectural & data modeling practices. You will be primarily developing Data Warehouse Solutions in Snowflake using technologies such as dbt, Airflow, Terraform.

What you’ll be doing:

• 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.

• Design & build ELT based data models using SQL & DBT.

• 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

What you bring to the role

Basic Qualifications:

• 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.

Preferred Qualifications:

• 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.

Our Data Stack:

ELT (Snowflake, dbt, Airflow, Kafka)

BI (Tableau, Looker)

Infrastructure (AWS, Kubernetes, Terraform, GitHub Actions)

Zendesk software was built to bring a sense of calm to the chaotic world of customer service. Today we power billions of conversations with brands you know and love.

Zendesk believes in offering our people a fulfilling and inclusive experience. Our hybrid way of working, enables us to purposefully come together in person, at one of our many Zendesk offices around the world, to connect, collaborate and learn whilst also giving our people the flexibility to work remotely for part of the week.

The intelligent heart of customer experience

Zendesk software was built to bring a sense of calm to the chaotic world of customer service. Today we power billions of conversations with brands you know and love. We advocate for digital first customer experiences—and we stick with it in our workplace. Over 5,000 employees worldwide are collaborating from kitchen tables, home offices, coworking spaces, and Zendesk workspaces to make one team.