Senior Data Engineer

<h2>Job Description</h2><p></p><ul><li><p></p><p>Our Enterprise Data &amp; Analytics (EDA) is looking for an experienced Senior Data Engineer to join our growing data engineering team. You’ll work in a collaborative Agile environment using the latest engineering best practices with involvement in all aspects of the software development lifecycle. </p><p></p><p>You will craft and develop curated data products, applying standard architectural &amp; data modeling practices to maintain the foundation data layer serving as a single source of truth across Zendesk  . You will be primarily developing Data Warehouse Solutions in BigQuery/Snowflake using technologies such as dbt, Airflow, Terraform.</p><h2></h2><h2>What you get to do every single day:</h2><ul><li><p>Collaborate with team members and business partners to collect business requirements, define successful analytics outcomes and design data models</p></li><li><p>Serve as Data Model subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately</p></li><li><p>Implement Enterprise Data Warehouse by transforming raw data into schemas and data models for various business domains using SQL &amp; <a href="https://www.getdbt.com/" rel="noopener noreferrer" target="_blank"><u>dbt</u></a></p></li><li><p>Design, build, and maintain ELT pipelines in Enterprise Data Warehouse to ensure reliable business reporting using Airflow, Fivetran &amp; dbt</p></li><li><p>Optimize data warehousing processes by refining naming conventions, enhancing data modeling, and implementing best practices for data quality testing</p></li><li><p>Build analytics solutions that provide practical insights into customer 360, finance, product, sales and other key business domains</p></li><li><p>Build and Promote best engineering practices in areas of version control system, CI/CD, code review, pair programming</p></li><li><p>Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery</p></li><li><p>Work with data and analytics experts to strive for greater functionality in our data systems</p></li></ul><h2></h2><h2><b>What you bring to the role:</b></h2><ul><li><p>5+ years of data engineering experience building, working &amp; maintaining data pipelines &amp; ETL processes on big data environments</p></li><li><p>5+ years of experience in Data Modeling and Data Architecture in a production environment</p></li><li><p>5+ years in writing complex SQL queries</p></li><li><p>5+ years of experience with Cloud columnar databases (We use Snowflake)</p></li><li><p>2+ years of production experience working with <a href="https://www.getdbt.com/" rel="noopener noreferrer" target="_blank"><u>dbt</u></a> and designing and implementing Data Warehouse solutions</p></li><li><p>Ability to work closely with data scientists, analysts, and other stakeholders to translate business requirements into technical solutions. Strong documentation skills for pipeline design and data flow diagrams.</p></li><li><p>Intermediate experience with any of the programming language: Python, Go, Java, Scala, we primarily use Python</p></li><li><p>Integration with 3rd party API SaaS applications like Salesforce, Zuora, etc</p></li><li><p>Ensure data integrity and accuracy by conducting regular data audits, identifying and resolving data quality issues, and implementing data governance best practices.</p></li><li><p>Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.</p></li></ul><p></p><p><b>Preferred Qualifications</b></p><ul><li><p>Hands-on experience with Snowflake data platform, including administration, SQL scripting, and query performance tuning</p></li><li><p>Good Knowledge in modern as well as classic Data Modeling - Kimball, Innmon, etc </p></li><li><p>Demonstrated experience in one or many business domains (Finance, Sales, Marketing)</p></li><li><p>3+ completed “production-grade” projects with dbt</p></li><li><p>Expert knowledge in python</p></li></ul><h2></h2><h2><b>What does our data stack looks like:</b></h2><ul><li><p>ELT (Snowflake, Fivetran, dbt, Airflow, Kafka, HighTouch)</p></li><li><p>BI (Tableau, Looker)</p></li><li><p>Infrastructure (GCP, AWS, Kubernetes, Terraform, Github Actions)</p></li></ul></li></ul><p></p><p><span>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.</span></p><p></p><p><b>The intelligent heart of customer experience</b></p><p>Zendesk software was built to bring a sense of calm to the chaotic world of customer service. Today we power bill