At a Glance
- Tasks: Build and maintain data pipelines to enhance customer support tools and operations.
- Company: Join Zendesk, a leader in customer service software with a collaborative culture.
- Benefits: Enjoy flexible remote work, competitive salary, and opportunities for professional growth.
- Other info: Dynamic hybrid work environment with excellent career advancement opportunities.
- Why this job: Make a real impact on customer experience using cutting-edge data technologies.
- Qualifications: 8+ years in data engineering, strong SQL skills, and experience with cloud databases.
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 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.
Staff Data Engineer 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 and engage in meaningful projects that enhance customer support tools. Employees benefit from a supportive environment that values innovation and teamwork, making Zendesk a rewarding place to advance your career as a Staff Data Engineer.
StudySmarter Expert Advice🤫
We think this is how you could land Staff Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at Zendesk or in similar roles on LinkedIn. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Show off your skills! Prepare a portfolio or a project that highlights your experience with data pipelines, SQL, and dbt. This will help you stand out during interviews and showcase your hands-on expertise.
✨Tip Number 3
Practice makes perfect! Get comfortable with common interview questions related to data engineering and be ready to discuss your past projects. Mock interviews with friends can help you nail your responses.
✨Tip Number 4
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 Staff Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Staff Data Engineer role. Highlight your data engineering experience, especially with SQL, dbt, and cloud databases like Snowflake.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about data engineering and how you can contribute to our ZAP team. Share specific examples of past projects that align with our mission to enhance customer support tools.
Showcase Your Collaboration Skills:Since this role involves working closely with Software Development Engineers and Business Intelligence Engineers, emphasise your teamwork and communication skills in your application. We love candidates who thrive in collaborative environments!
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Zendesk
✨Know Your Data Stack
Familiarise yourself with the tools and technologies mentioned in the job description, especially Snowflake, dbt, and Airflow. Be ready to discuss your hands-on experience with these platforms and how you've used them to build data pipelines or models.
✨Showcase 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.
✨Prepare for Technical Questions
Brush up on your SQL skills and be ready to solve problems on the spot. You might be asked to design a data model or optimise an ELT pipeline, so practice explaining your thought process clearly and concisely.
✨Emphasise Problem-Solving Attitude
Zendesk values proactive problem solvers. Think of specific instances where you identified inefficiencies or challenges in data processes and how you addressed them. This will demonstrate your ability to thrive in ambiguous situations.
