Staff Data Engineer

TN Germany; Deutschland; Hybrid; EUR 70.000 - 90.000; Vollzeit

Zusammenfassung

A leading company is seeking an experienced Staff Data Engineer to enhance CRM measurements and insights. The role involves developing high-quality data pipelines and managing the data lake, emphasizing collaboration and best practices in data engineering.

Qualifikationen

• 8+ years of experience in data engineering and building data pipelines.
• Extensive SQL experience for data modeling and analysis.

Aufgaben

• Develop, automate, and maintain scalable ELT pipelines.
• Collaborate with team members to understand business needs.

Kenntnisse

SQL

Communication

Problem Solving

Tools

dbt

Snowflake

Airflow

Jobbeschreibung

Social network you want to login/join with:

The ‘Zendesk Analytics Prototyping’ (ZAP) team is seeking an experienced Staff Data Engineer to support its mission to enhance CRM measurements and insights, fostering a data-centric approach to improve customer support tools and operations. The team builds and maintains detailed, high-quality datasets to develop insights that improve Zendesk’s support operations.

The role involves partnering with Software Development Engineers and Business Intelligence Engineers to develop high-quality data pipelines and manage the team’s data lake. The environment emphasizes collaboration and adherence to engineering best practices throughout the software development lifecycle. Responsibilities include creating curated datasets and developing Data Warehouse solutions primarily in Snowflake, utilizing technologies such as dbt, Airflow, and Terraform.

What you’ll be doing:

• Collaborate with team members and stakeholders to understand business needs, define analytics success, and design data models.
• Develop, automate, and maintain scalable ELT pipelines in our Data Warehouse for reliable reporting.
• Design and build ELT-based data models using SQL and dbt.
• Identify and implement process improvements, automate manual tasks, and optimize data delivery.
• Work with data and analytics experts to enhance data system functionality.

What you bring to the role

Basic Qualifications:

• 8+ years of experience in data engineering, including building and maintaining data pipelines and ETL processes in big data environments.
• Extensive SQL experience, especially in data modeling and analysis.
• Hands-on experience with dbt and knowledge of data modeling methodologies like Kimball and Inmon.
• Proficiency in a programming language such as Python, Go, Java, or Scala.
• Experience with cloud columnar databases (Google BigQuery, Amazon Redshift, Snowflake), SQL query writing, and familiarity with various databases.
• Knowledge of data transformation processes, data structures, metadata, dependencies, and performance optimization.
• Excellent communication and collaboration skills.
• Proactive problem-solving skills and ability to thrive in ambiguous situations.

Preferred Qualifications:

• Experience with BigQuery, Snowflake, or similar cloud warehouses.
• Familiarity with AI tools and techniques applicable to data analysis and transformation.
• Completed projects involving dbt.
• Understanding of Lean/6 Sigma principles and CRM analytics.

Our Data Stack:

• ELT: Snowflake, dbt, Airflow, Kafka
• BI: Tableau, Looker

#LI-DT2

Zendesk software aims to bring calm to the chaotic world of customer service, powering billions of conversations globally.

Zendesk values a fulfilling and inclusive work environment, offering a hybrid work model that combines in-office and remote work to foster collaboration and flexibility.