Description:

Zapier is seeking a Data Warehouse Engineer to shape and scale its Ecosystem, which connects over 7,000 apps to streamline workflows for users.
The role involves developing and maintaining efficient data pipelines using tools like Airflow, Databricks, and dbt to transform raw data into analytics-ready datasets.
The Data Warehouse Engineer will ensure data quality by implementing automated testing and monitoring systems.
The position requires collaboration with stakeholders to understand analytical needs and build self-service analytics solutions using tools like Looker and Amplitude.
The engineer will contribute to architectural decisions and strategies to optimize data storage, workflows, and schemas for scalability and security.
The role includes bridging the gap between raw data and actionable insights, empowering teams to make informed, data-driven decisions.
Mentorship and knowledge sharing with junior team members are also key responsibilities.

Requirements:

Candidates must have 4+ years of experience as a Data Warehouse Engineer, Data Engineer, Analytics Engineer, or in a similar role.
Strong proficiency in SQL and Python is required, including the ability to write complex SQL queries and build Airflow functions.
A deep understanding of data modeling concepts and experience designing data models and ETL pipelines is essential.
Commitment to data quality is crucial, with a focus on implementing robust solutions for monitoring and ensuring data integrity.
Candidates should strive to align their work with business goals and understand key metrics and their implications.
Familiarity with modern data platforms and best practices for scalability and performance is necessary.
Excellent written communication skills are required, as writing is the primary means of communication in a remote team.
Candidates should value collaboration and knowledge sharing, working effectively with teammates at all technical levels.
A proactive and strategic mindset is essential, with the ability to develop forward-thinking plans that prioritize stakeholder value.

Zapier offers a flexible remote work environment, allowing employees to work from anywhere in the Americas or EMEA.
The company promotes a culture of diversity, inclusion, and belonging, welcoming applications from individuals of all identities.
Employees are encouraged to take ownership of their projects and contribute to a culture of learning and knowledge sharing.
Zapier provides a non-standard application process designed to promote inclusion and equity in hiring.
The company commits to keeping applicants informed throughout the hiring process, ensuring timely communication regarding application status.
Reasonable accommodations are available for individuals with disabilities during the application and interview process.