Data Warehouse Engineer

Overview

Job Description

Responsibilities

• - Design and Build Data Pipelines: Develop and maintain efficient data pipelines using Airflow, Databricks, and dbt to transform raw data into analytics-ready datasets for user-facing products and insights.
• - Ensure Data Quality: Implement automated testing and monitoring systems to uphold data quality and integrity, leveraging best practices in observability and issue detection.
• - Enable Self-Service Analytics: Partner with stakeholders across Zapier to understand their analytical needs and build data models and self-service analytics solutions using tools like Looker and Amplitude.
• - Define Data Collection Strategies: Collaborate with product, marketing, and engineering teams to ensure products and services are properly instrumented to collect the right data for analytics.
• - Shape Technical Direction: Contribute to architectural decisions, tooling choices, and strategies to optimize data storage, workflows, and schemas, ensuring scalability, accessibility, and security.
• - Bridge Data to Insights: Work closely with Data Scientists and cross-functional stakeholders to bridge the gap between raw data and actionable insights, empowering teams to make informed, data-driven decisions.
• - Mentor and Share Knowledge: Act as a resource for junior team members, offering guidance and knowledge-sharing to elevate team expertise and contribute to a culture of learning.

Required Skills

• - 4+ years of experience as a Data Warehouse Engineer, Data Engineer, Analytics Engineer, or in a similar role.
• - Strong proficiency in SQL and Python.
• - Skilled at writing complex SQL queries for data transformation and analysis.
• - Proficient in Python, capable of building Airflow functions and extracting data from third-party APIs.
• - Deep understanding of data modeling concepts.
• - Designed data models and ETL pipelines with a focus on ease of use for end consumers, high performance, and scalability.
• - Committed to data quality, prioritizing data integrity and implementing robust solutions for monitoring and ensuring data quality.
• - Familiar with modern data platforms and best practices for scalability and performance.
• - Skilled written communicator, able to explain complex technical topics in a clear and approachable way.
• - Proactive and strategic, developing forward-thinking plans that prioritize stakeholder value.

Benefits

• - Offers Equity
• - Offers Bonus
• - Remote work flexibility
• - Competitive and equitable compensation practices