Description:
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.
Basic Qualifications
What you bring to the role
- 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.