At a Glance
- Tasks: Build and maintain data pipelines, collaborate on analytics outcomes, and enhance customer support tools.
- Company: Zendesk, a leader in customer service software with a focus on collaboration and innovation.
- Benefits: Flexible hybrid work model, inclusive culture, and opportunities for professional growth.
- Other info: Work in a supportive environment with a diverse team and cutting-edge technology.
- Why this job: Join a dynamic team to shape the future of customer experience through data-driven insights.
- Qualifications: 8+ years in data engineering, strong SQL skills, and experience with Snowflake and dbt.
The predicted salary is between 70000 - 90000 £ per year.
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.
Senior Data Engineer — ELT & Snowflake Data Warehouse in London employer: Zendesk
Zendesk is an exceptional employer that fosters a collaborative and inclusive work culture, empowering employees to thrive in both remote and in-office settings. With a strong focus on professional growth, the company offers opportunities to work with cutting-edge technologies in data engineering while promoting a data-centric approach to enhance customer support operations. Employees benefit from a flexible hybrid work model, ensuring a fulfilling experience as part of a global team dedicated to transforming customer service.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer — ELT & Snowflake Data Warehouse in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field, especially those who work at Zendesk or similar companies. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best projects, especially those involving ELT pipelines, Snowflake, and dbt. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your SQL and data modelling knowledge. Be ready to discuss your experience with cloud databases and how you've tackled challenges in past projects. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Zendesk team.
We think you need these skills to ace Senior Data Engineer — ELT & Snowflake Data Warehouse in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Data Engineer role. Highlight your experience with ELT pipelines, SQL, and Snowflake, as these are key to what we’re looking for. Don’t just list your skills; show us how you’ve used them in real projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data engineering and how your background aligns with our mission at Zendesk. Be specific about your achievements and how they relate to the role.
Showcase Your Projects:If you’ve worked on relevant projects, make sure to mention them! Whether it’s building data models or automating processes, we want to see examples of your work. Include links to your GitHub or any other portfolio that showcases your skills.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy and ensures your application goes directly to our hiring team. Plus, you’ll get to see more about our culture and values while you’re at it!
How to prepare for a job interview at Zendesk
✨Know Your Data Stack
Familiarise yourself with the specific tools and technologies mentioned in the job description, like Snowflake, dbt, and Airflow. Be ready to discuss your hands-on experience with these tools and how you've used them to build and maintain data pipelines.
✨Showcase Your Collaboration Skills
Since the role involves working closely with Software Development Engineers and Business Intelligence Engineers, prepare examples of past collaborations. Highlight how you’ve effectively communicated requirements and outcomes to ensure successful project delivery.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your problem-solving skills, especially in ambiguous situations. Think of specific challenges you've faced in data engineering and how you approached them, focusing on your proactive attitude and the solutions you implemented.
✨Prepare for Technical Questions
Brush up on your SQL and data modelling knowledge, as well as your understanding of ELT processes. Be prepared to solve a technical problem or answer scenario-based questions during the interview to showcase your expertise and thought process.
