Job Description

IMPORTANT: Please apply through this link only: https://dev-forms.clickup.com/f/ad-28888/T9SS4AQ83VHVDRUK9M

ClickUp is looking for a passionate and dedicated data engineer to help us create and scale our analytics architecture. You’ll be joining the analytics team powering our business intelligence, data science, and machine learning projects to empower us to get 1% better every day! The analytics team is responsible for designing and supporting our AWS analytics infrastructure and dashboard integrations. This includes data ingestion, ETL, storage, query caching and optimization. Our analytics infrastructure is currently in its early stages so you will have significant influence on its development. An ideal candidate would be an SQL wizard and have experience designing and implementing high reliability and scalable analytics infrastructure on AWS. Collaboration and teamwork are vital to how ClickUp operates. A significant portion of your responsibilities will include working closely with members of other teams to uncover their data requirements and implement high quality, maintainable pipeline updates to support their reporting needs. We’re scaling quickly, so we’re recruiting teammates who share our core values, know how to get sh*t done, and would add a lot to our extremely driven culture.

THE ROLE

• Create and maintain optimal data pipeline architecture.
• Assemble, clean, and transform complex data sets to support reporting and analytical tasks.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS S3, Glue, Lambda, Redshift, EMR, etc.
• Identifying and troubleshooting errors and performance issues that occur within our infrastructure.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our analytics data separated and secure across national boundaries through multiple data centers and AWS regions.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

QUALIFICATIONS

• 3+ years experience writing and maintaining production level databases and ETL pipelines.
• Build processes and documentation supporting data transformation, cataloging, data structures, metadata, dependency and workload management.
• Expert knowledge of SQL and relational databases (preferably PostgreSQL).
• Experience with AWS or other cloud service big data services.
• A strong self-starter, operationally-focused; a problem-solver.
• Excellent interpersonal, written, and oral communication skills.
• Bonus Skillsets: Hadoop, Spark, Kafka, Airflow, Python.

Company Description

After only 3 years, ClickUp is profitable and has grown to 100,000+ teams purely organically. We're creating a place for anyone to work on anything. Our vision of making the world more productive is just getting started. ClickUp is a productivity platform that provides a fundamentally new way to work. More than just task management - ClickUp offers notes, reminders, goals, calendar, scheduling, and even an inbox. Fully customizable, ClickUp works for every type of team, so all teams can use the same app to plan, organize, and collaborate. We're building the future - to make the world more productive. ClickUp was ranked a Top 10 fastest growing app of 2018: https://www.entrepreneur.com/article/316977