Data Engineer

Data Engineer

About Chili Piper

Chili Piper is a B2B SaaS startup. Our product helps clients turn inbound leads into qualified meetings instantly, helping revenue teams connect to buyers faster.

Think Calendly. Except way better. Way more powerful. And with customers like RingCentral, Airbnb, Square, Intuit, Spotify, Twilio, and many other cool logos.

We’re growing fast. And we don’t mean that in the cliche way. We are sitting on a fresh round of funding, and are ready to take over the world (in the most civil and appropriate way possible, of course).

Position Overview: 

We are seeking a talented and motivated Data Engineer to join our team and play a key role in propelling Chili Piper to the next level of data-driven decision-making. As a Data Engineer, you will be responsible for designing, implementing, and maintaining our data infrastructure to support the analytics and reporting needs of the company.

You’ll primarily work with our Analytics Engineer and SRE team to define solutions as well as with business stakeholders across the company to understand their needs and build systems to unlock operational efficiencies or analytic insights.

This role offers a unique opportunity to reassess our current data architecture and facilitate our transition to a higher level of data maturity. You will also take charge of evaluating and implementing the latest data engineering tools and technologies to best meet the evolving needs of our team.

What You’ll Do:

  • Maintain and improve existing data pipelines and build monitoring systems around them.

  • Work with the team to define our data architecture and infrastructure.

  • Develop an understanding of our data model and optimize our data models and pipelines for scale.

  • Design & build data models using SQL & dbt.

  • Ensure system security and data privacy compliance.

  • Improve existing systems' performance, observability, reliability, and scalability.

  • Configure warehouse ingestion tools (e.g., Snowpipe) and provision, maintain and optimize our data warehouse

  • Develop and maintain a scalable, robust and efficient data platform serving analytic and operational needs across the organization.

  • Work independently and share your knowledge across the business and mentor colleagues in areas of deep technical expertise.

  • Working with product owners and stakeholders to gather requirements and translate them into technical requirements as well as providing timely updates on progress and highlighting relevant risks or opportunities.

Who You Are:

  • 4+ years of software development experience, preferably as a data or backend engineer, maintaining and working with data pipelines & ETL processes on big data environments.

  • Deep knowledge with data warehouses like Snowflake, BigQuery, Databricks.

  • Can reduce latency of end-to-end pipelines through data orchestration in addition to incrementalization or streaming. You have strong knowledge of common data integration patterns (CDC, ELT, etc.)

  • Proficiency in a programming language such as Python, Go, or Scala. 

  • Expert SQL skills and knowledge; can write complex queries, comfortable with window functions and can design / have strong opinions on database design/schema.

  • Hands-on experience in using event-driven architecture with Kafka.

  • Experience with a job orchestrator (Airflow, Prefect, Dagster)

  • Demonstrable understanding of how to expose data from systems (eg. through APIs), link data from multiple systems and deliver streaming services.

  • Initiatives around performance optimisation and cost reduction.

  • Solid understanding of security best practices, accessibility, compliance, and GDPR regulations.

  • Experience in modern software development tools and ways of working (Agile methodologies, Git, CI/CD & DevOps tools, infrastructure as code, metrics/monitoring, etc.)

  • Thrive in ambiguous situations, possesses a proactive problem-solving attitude

  • Autonomous in approach and experience mentoring and advising other team members.

  • Communicate effectively with Product Managers , Engineering and Commercial teams to translate complex business requirements into scalable solutions.

Desired experience:

  • Experience with batch / streaming services.

  • Strong perspective on analytics engineering development cycle (data modeling, version control, documentation + testing, best practices for codebase development)

  • Knowledge in modern and classic Data Modeling - Kimball, Data Vault, OBT etc.

  • Experience with the modern data stack (Fivetran / Snowflake / dbt / Looker / Hightouch or equivalents)

  • Experience with product / marketing analytics would be an asset.

Additional Information

Why you'll love being a part of our team:

Our team loves Chili Piper because we’re building the company of the future. 

  • Work with an immensely talented global team

  • Work in a business that’s run fairly and transparently

  • Competitive pay based on market rate wherever you live

  • We lead by example--showing industry peers and leaders how to innovate, improve, and grow--while having fun

How we work:

  • Freedom and flexibility. We’re a 100% distributed team working from around the world, and we've been fully remote since 2016. Our team members can work from wherever they want in the world, as long as they show up on our weekly all hands meeting on Zoom.

  • Solve interesting problems. The software landscape has exploded. There are dozens of solutions for each problem. We want to be different. We come up with new angles on existing problems or invent better solutions to help companies with their sales and marketing. Then we turn these ideas into beautiful, smart software.

  • Autonomy and ownership. Working on a distributed team means you don’t have someone micromanaging you or looking over your shoulder to make sure you’re getting things done. We’re a team of do-ers who take full ownership for their results.

  • Be helpful. Our first value as a company is help. Help our customers be successful. Help our prospects get the right information and make the right decision whether or not it includes our products. Help our team members reach their full potential.

The perks:

  • Unlimited Vacation

  • Generous Health, Dental, and Vision Insurance

  • Any equipment/software/tech that you need to do your job

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.