Junior Data & Automation Engineer

Junior Data & Automation Engineer

Join Pigment: The AI Platform Redefining Business Planning

Pigment is the AI-powered business planning and performance management platform built for agility and scale. We connect people, data, and processes in one intuitive, feature-rich solution, empowering every team—from Finance to HR—to build, adapt, and align strategic plans in real time.

Founded in 2019, Pigment is one of the fastest-growing SaaS companies globally. Industry leaders like Unilever, Snowflake, Siemens, and DPD use Pigment daily to make more informed decisions and confidently navigate any scenario.

With a team of 500+ across Paris, London, New York, San Francisco, and Toronto, we've raised nearly $400M from top-tier investors and were named a Visionary in the 2024 Gartner® Magic Quadrant™ for Financial Planning Software.

At Pigment, we take smart risks, celebrate bold ideas, and challenge the status quo—all while working as one team. If you're driven by innovation and ready to make an impact at scale, we'd love to hear from you.

The Business Automation Team

The Business Automation team is designing, implementing, and maintaining intelligent automation solutions that streamline business processes and enhance data-driven decision making. We empower business and corporate functions through technology integration, robust data architecture, and process optimization, enabling teams to focus on high-value activities while ensuring accuracy and scalability.

Our team operates across multiple domains, maintaining shared services and supporting Pigment's internal functions through automation solutions. We work with a variety of technologies to build reliable data pipelines and automation workflows that support Pigment's growth and operational efficiency.

Our team tackles diverse challenges, including streamlining the employee onboarding journey from hiring to first day, building data pipelines that collect and analyze platform usage metrics, and creating dashboards that provide actionable insights to enhance customer success. These projects combine process optimization, data engineering, and business intelligence to drive operational excellence.

Role

As a Junior Automation and Data Engineer, you will contribute to the design, development, and maintenance of automation solutions and data pipelines that support Pigment's business functions. You will work closely with senior engineers to implement efficient workflows, improve process reliability, and support our automation and analytics projects. You will work both on simple problems, with a high level of autonomy, and complex cross-functional topics in collaboration of senior peers.

This role involves collaborating with various internal stakeholders at Pigment and requires strong communication skills, both verbal and written.

Tech Environment

Our core stack relies on Google Cloud Platform (GCP), fully maintained by Terraform code, with components including BigQuery, Cloud Run, Cloud Composer (Airflow), as well as dbt, Fivetran, Hightouch, and Python for automation tasks.

You will have the opportunity to learn and grow your skills across these technologies while making a meaningful impact on the Pigment's operational efficiency.

What You'll Do

Under the supervision of the Business Automation team's more senior members, you will participate in addressing the following topics.

• Develop and maintain Python-based automations and solutions to streamline enterprise processes
• Implement integrations between various systems and applications using APIs and other connection methods
• Assist in maintaining CI/CD pipelines for automation projects
• Support the implementation of data pipelines that integrate data from various sources, including APIs, external databases, and third-party services
• Assist in transforming raw data into clean and ready-to-use models using SQL and dbt
• Collaborate on data quality monitoring and improvement initiatives
• Help implement monitoring for automation workflows and data pipelines
• Troubleshoot and resolve issues with existing automation solutions
• Assist in documentation of systems, processes, and workflows
• Work collaboratively with team members and stakeholders - as diverse as HR, Sales and Product Engineering - to understand requirements and implement effective solutions
• Continuously expand knowledge of data engineering and automation best practices
• Participate in code reviews and knowledge sharing sessions

Who You Are

The ideal candidate will possess most or all of the following qualifications. Hands-on experience through personal projects, particularly contributions to open source initiatives, will be valued equally to professional and academic experience for this role.

• 2+ years of experience in software development, with some sense of data engineering
• Strong coding skills in Python (knowledge of common libraries for automation and data processing is considered as a plus)
• Good understanding of SQL, database and infrastructure as code concepts
• Practical experience with public cloud providers (some experience with GCP is a plus)
• Knowledge of version control systems (Git)
• Attention to detail and analytical problem-solving skills, with the ability to identify edge cases
• Good communication skills and ability to work in a collaborative and multicultural environment
• Eagerness to learn new technologies and approaches
• Proficiency in English; knowledge of French is a strong plus
• Problem-solving mindset with critical thinking about corporate processes
• Strong communication abilities - translating technical concepts to non-technical audiences and active listening skills for accurately capturing business requirements
• Basic project management capabilities - tracking tasks, managing timelines, and reporting progress

What We Offer

• Competitive package
• Stock options to ensure you have a stake in Pigment's growth
• The best health insurance with Alan Blue entirely free for you and your family
• Weekly Lunch and Lunch vouchers (Swile card) to cover your lunch breaks with total flexibility
• Subscription to Egym Wellpass (ex-Gymlib) for full access to gyms, studios, and wellness spaces across France
• Trust and flexible working hours
• Along with one company offsite every year, we have brand new offices at the heart of major cities including New York, San Francisco, Toronto, Paris, and London
• High-end equipment (based on stock/availability) to do your work in the best conditions
• Remote-friendly environment

How We Work

• Thrive Together: We can only win as a team. We are all founders and do the right thing for our peers, Pigment customers, partners, and the planet
• Never Settle: We aim to become the best at what we do by delivering with rigor and ambition every day. Delivering means building a passionate Pigment community
• Go for it: We are biased towards action. Every action leads to learning and these learnings get us one step closer to our mission
• Be real, be humble: We are generous with our feedback, open to change our views and we approach it with empathy knowing everyone is trying to do the best for Pigment