At a Glance
- Tasks: Build and maintain data pipelines, collaborate on analytics outcomes, and enhance customer support tools.
- Company: Join Zendesk, a leader in customer service software with a global presence.
- Benefits: Flexible hybrid work model, competitive salary, and inclusive culture.
- Other info: Dynamic team environment with opportunities for professional growth and learning.
- 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.
Senior Data Engineer — ELT & Snowflake Data Warehouse 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, team members have access to cutting-edge technologies and the opportunity to work on impactful projects that enhance customer support tools. The company values a data-centric approach, ensuring that employees are engaged in meaningful work while enjoying the flexibility of a hybrid work model.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer — ELT & Snowflake Data Warehouse
✨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 previous roles. 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. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Senior Data Engineer — ELT & Snowflake Data Warehouse
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the job description. Highlight your data engineering experience, especially with ELT pipelines and Snowflake, to show us you’re the right fit!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you’re passionate about data engineering and how your background aligns with our mission at Zendesk. Share specific examples of your work with SQL, dbt, or any relevant projects.
Showcase Your Collaboration Skills:Since we value teamwork, mention instances where you’ve successfully collaborated with software developers or business intelligence teams. This will help us see how you can contribute to our collaborative environment.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates during the process!
How to prepare for a job interview at Zendesk
✨Know Your Data Inside Out
Before the interview, dive deep into your past projects involving data pipelines and ELT processes. Be ready to discuss specific challenges you faced and how you overcame them, especially in relation to Snowflake and dbt. This will show your expertise and give the interviewers confidence in your abilities.
✨Brush Up on SQL and Data Modelling
Since SQL and data modelling are crucial for this role, make sure you're comfortable discussing different data modelling techniques like Kimball and Inmon. Prepare examples of how you've applied these methods in your previous work, as this will demonstrate your practical knowledge and problem-solving skills.
✨Collaborative Mindset is Key
Zendesk values collaboration, so be prepared to talk about how you've worked with cross-functional teams in the past. Share specific instances where your communication and teamwork led to successful project outcomes, particularly in building data models or optimising data delivery.
✨Showcase Your Proactive Problem-Solving Skills
In your interview, highlight situations where you thrived in ambiguous scenarios and took the initiative to improve processes. Discuss any experience you have with Lean/6 Sigma principles or AI tools that could enhance data analysis, as this aligns well with Zendesk's focus on innovation and efficiency.
