Senior Data Engineer
Fountain
When you join the Fountain team, you become part of the leading enterprise solution for frontline workforce management. Fountain’s automated, customizable platform provides a seamless applicant experience for workers, while ensuring organizations can scale and manage their frontline talent.
We’ve helped hundreds of companies like UPS, CLEAR, Stitch Fix, GoPuff, Fetch, and sweetgreen to hire, onboard, and manage over 14 million workers in more than 75 countries.
In 2022, we closed $185M in our Series C, led by SoftBank and B Capital.
Join our growing team of highly collaborative, ambitious, and forward-thinking Fountaineers as we empower our hundreds of customers and millions of frontline workers around the world.
Let’s elevate frontline work together.
About The Team:
Fountain is the leading hiring platform for high-volume frontline workforces. As we scale into a multi-product, enterprise-focused company, data is at the heart of our strategy. Our data infrastructure powers embedded analytics for our customers, internal BI for our teams, and agentic analytics experiences in our products. We’re looking for a Senior Data Engineer to help build and evolve the data platforms and pipelines that make this possible.
What You’ll Be Doing:
- Build, maintain, and optimize data pipelines and ETL processes to move data from Postgres and MongoDB into our Iceberg data lake on S3 and ClickHouse Cloud via change data capture (CDC) using Debezium or ClickPipes.
- Collaborate with senior engineers to orchestrate transformations using Dagster, including dbt runs, custom Python ETLs, and scheduled jobs.
- Develop and maintain dbt models across multiple warehouses (ClickHouse, BigQuery, Snowflake, Redshift) to power embedded analytics, internal analytics, and customer-facing integrations.
- Work with cross-functional teams to gather data requirements, test transformations, and deliver high-quality datasets for analytics and product features.
- Assist in migrating from Fivetran to a Kafka-based streaming architecture, including configuring Kafka and Debezium connectors.
- Participate in implementing data retention, GDPR compliance, anonymization, and backup workflows across our data lake and warehouse layers.
- Monitor pipeline health, troubleshoot issues, and optimize query performance in ClickHouse, Snowflake, BigQuery, and Redshift.
- Contribute to infrastructure-as-code practices using Terraform (or similar tools) to standardize deployments and manage environments across AWS, GCP, and Azure.
What You Should Bring:
- 5+ years of professional experience in data engineering, ETL, or similar roles.
- Proficiency in SQL and Python, with experience using dbt and an orchestration framework such as Dagster, Airflow, or Prefect.
- Experience with relational databases (Postgres/Aurora) and NoSQL databases (MongoDB).
- Familiarity with data lakes and data warehouse technologies such as Iceberg, ClickHouse, BigQuery, Snowflake, and Redshift.
- Exposure to streaming and CDC technologies like Kafka, Debezium, and change data capture pipelines.
- Understanding of data modeling, incremental design, and performance optimization.
- Knowledge of cloud platforms (AWS, GCP, Azure) and storage services (S3, GCS, Azure Storage).
- Experience managing infrastructure using Terraform or similar infrastructure-as-code tooling.
- Experience with version control and collaboration using Git.
- Strong communication skills and the ability to work collaboratively across teams.
- A proactive, curious attitude with a desire to learn and grow in a fast-paced environment.
Even if you do not meet all the requirements above, we still encourage you to apply for this position. While we try to be thorough with our prerequisites, not everything about you as a candidate can be condensed into a list of bullet points. What do you have to lose?
The benefits we offer in Mexico include
- FULL TIME EMPLOYMENT
- Competitive health insurance plans
- Christmas bonus
- Flexible time off
- Fountain-wide perks including paid holidays, annual allowances for ongoing education related to your profession and career advancement, along with home office, cell phone, and wellness reimbursements.
Fountain is proud to be an equal opportunity workplace. We welcome applicants of any educational background, gender identity and expression, sexual orientation, religion, ethnicity, age, socioeconomic status, disability, and veteran status.
For information about how we use your information and the rights you have with respect to your information, visit our Privacy Policy.
#LI-Remote