Junior Data & Automation Engineer

The role

You will help build and maintain Pigment's data platform: ingestion pipelines, dbt models, orchestration and data quality on Google Cloud. You will also build Python automations and data pipelines that support Finance, People, IT, Sales and Customer Success teams, and contribute to AI projects.

What you will do

• Develop and maintain ingestion pipelines from APIs, databases and SaaS tools using Fivetran, Airflow and Python
• Build and maintain dbt models that turn raw data into clean, documented, tested datasets
• Build pipelines and integrations that sync data between CRM, ERP and HRIS systems, including reverse ETL with Hightouch
• Develop Python automations that remove manual work for Finance, People, IT and Customer Success
• Contribute to LLM pipelines that extract, classify and enrich unstructured data
• Help improve data quality, observability and alerting across the platform
• Monitor pipelines and automations, troubleshoot incidents and fix root causes
• Document data models, pipelines and processes for technical and business readers
• Work with stakeholders such as Finance, People, Sales and Product to turn requirements into data solutions
• Take on small projects end to end over time, with supervision from senior engineers

Required qualifications

• Up to 3 years of relevant experience in data engineering, including apprenticeships, internships or personal projects
• Strong SQL skills and understanding of data modeling concepts
• Solid coding skills in Python
• Understanding of ELT/ETL patterns, pipeline design and data quality testing
• Knowledge of Git and CI/CD concepts
• Practical experience with a public cloud provider and a cloud data warehouse
• Attention to detail and analytical problem-solving skills
• Good understanding of AI and LLM principles and practical use of AI tools
• Excellent communication in both French and English, written and verbal
• Problem-solving mindset and curiosity; comfort asking questions early

Nice to have

• Hands-on experience with dbt, Airflow or Terraform
• Exposure to ingestion and reverse ETL tools
• Hands-on experience building LLM-powered pipelines or applications
• Basic project management skills: tracking tasks, timelines and progress

Benefits

• Competitive package
• Stock options
• Health insurance with Alan Blue, free for you and your family
• Weekly lunch and Swile lunch vouchers
• Egym Wellpass subscription for gyms, studios and wellness spaces in France
• Trust and flexible working hours
• One company offsite every year
• New offices in New York, San Francisco, Toronto, Paris and London
• High-end equipment, based on stock and availability
• Remote-friendly environment

Before you apply

• Background checks are part of the hiring process, carried out lawfully with candidate consent before contracts are signed, where permitted by local law
• Personal projects and open source contributions (share your GitHub) are valued equally to professional and academic experience

About the company

Pigment is an AI-powered business planning and performance management platform, founded in 2019, with 700+ people across six cities. Customers named in the posting include Unilever, Uber, Anthropic, Snowflake and Siemens.