Senior Staff AI Snowflake Architect

Job Description

Who we’re looking for:
 

The ‘Zendesk Analytics Prototyping’ (ZAP) team is chartered to evolve Zendesk’s business intelligence framework with a focus on AI data, measurement, and ROI insights. We build fine-grained, highly curated, contextually rich datasets capturing every facet of Zendesk’s support operations—both human- and AI-driven—and develop measurements and insights that reflect the true value delivered by AI applications to our customers and their end users. Once prototyped and validated, these metrics and insights are operationalized internally and delivered externally through customer-facing reports.

We’re seeking a Sr Staff Snowflake Database Architect with deep expertise in Snowflake data architecture and modeling to lead the design and optimization of Zendesk’s OLAP product data domain. You’ll partner closely with data engineers, architects, and analytics teams to shape a scalable, performance-driven data foundation, enabling both internal reporting and customer-facing insights. If you thrive on designing enterprise-scale Snowflake solutions, driving best-in-class data models, and fine-tuning systems to deliver high-impact analytics, we want to hear from you.

What you’ll be doing:

• Drive the end-to-end Snowflake Product data architecture, leading efforts to design and maintain OLAP data models that power Zendesk’s internal and customer-facing analytics. You’ll ensure that our Snowflake environment is built to scale for growing data volumes and complex reporting needs.

• Develop best-in-class data models that deliver fast, reliable insights. You’ll apply advanced Snowflake features—such as search optimization, clustering—to maximize performance and minimize costs.

• Guide Product teams on OLAP data architecture, Snowflake best practices and cost-efficient solutions, sharing your deep expertise to elevate the entire Product Development organization. Encourage a culture of design rigor and data excellence throughout.

• Work closely with Data Engineers, Data Scientists, and Product Managers to translate business requirements into robust Snowflake solutions. 

• Oversee data governance, quality, and security measures to guarantee a trustworthy and compliant data environment. You’ll identify and resolve performance bottlenecks while implementing processes for monitoring, alerting, and troubleshooting issues.

• Continuously evaluate and adopt new Snowflake capabilities, refining the stack to keep Zendesk at the forefront of cloud data innovation. You’ll push for automated testing, CI/CD, and other forward-thinking approaches to maintain a future-proof data foundation.

What you bring to the role

Basic Qualifications:

• Bachelor’s degree in Computer Science/Information Systems or related field. 

• 8+ years of experience in data engineering or database architecture, with a proven track record of designing and optimizing Snowflake environments at an enterprise scale

• Expert-level proficiency in Snowflake features and components, such as clustering, micro-partitioning, Streams & Tasks, and performance tuning best practices

• Strong foundation in OLAP data modeling, including Kimball and Inmon methodologies, with the ability to develop robust, scalable schemas for complex analytical use cases

• Strong proficiency in Python, SQL, and other data engineering technologies including DBT, Airflow. Hands-on experience with cloud platforms (AWS preferred), big data tools (e.g. Spark, Hadoop), and distributed systems.

• Ability to work cross-functionally with product teams, data scientists, software engineers, and business leaders. Strong communicator, able to explain technical concepts to non-technical stakeholders.

• Familiarity with data governance principles and best practices, including data quality, data lineage, and security standards.

• Excellent communication and collaboration skills.

Preferred Qualifications:

• Master’s degree in Computer Science/Information Systems or related field

• SnowPro Advanced certification

• Familiarity with Lean/6 Sigma principles and an understanding of CRM analytics.

Our Data Stack:

ELT (Snowflake, dbt, Airflow, Kafka)

Infrastructure (AWS, Kubernetes, Terraform, GitHub Actions)

BI (QuickSight, Looker)

#LI-KO1

Hybrid: In this role, our hybrid experience is designed at the team level to give you a rich onsite experience packed with connection, collaboration, learning, and celebration - while also giving you flexibility to work remotely for part of the week. This role must attend our local office for part of the week. The specific in-office schedule is to be determined by the hiring manager.

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.

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.

Zendesk is an equal opportunity employer, and we’re proud of our ongoing efforts to foster global diversity, equity, & inclusion in the workplace. Individuals seeking employment and employees at Zendesk are considered without regard to race, color, religion, national origin, age, sex, gender, gender identity, gender expression, sexual orientation, marital status, medical condition, ancestry, disability, military or veteran status, or any other characteristic protected by applicable law. We are an AA/EEO/Veterans/Disabled employer. If you are based in the United States and would like more information about your EEO rights under the law, please click here.

Zendesk endeavors to make reasonable accommodations for applicants with disabilities and disabled veterans pursuant to applicable federal and state law. If you are an individual with a disability and require a reasonable accommodation to submit this application, complete any pre-employment testing, or otherwise participate in the employee selection process, please send an e-mail to [email protected] with your specific accommodation request.