Data Engineer

Our Story So Far:

Since our founding in 2019, Pigment has become one of the fastest-growing SaaS companies in the world today. Our product, a highly efficient Enterprise Performance Management (EPM) platform is helping companies achieve their financial goals by quickly responding to dynamic factors in their respective markets including Tech, Retail, CPG & Financial Services.

In less than 5 years, Pigment has grown to over 400 employees across offices in New York, Toronto, London & Paris and attracted a total of $393M in investment from some of the top Venture Capital firms globally.

We serve companies including Unilever, Deliveroo, Gong and Brex to name a few!

As a Data Engineer, you will play a crucial role in designing, building, and managing the whole infrastructure and systems that collect, store, and process data. You will also work closely with Data Analysts to improve the quality and reliability of our data and the execution of our analytics projects.

Our stack is mainly composed of GCP (Postgres DBs, BigQuery, Cloud Storage, Cloud Functions and Schedulers), Fivetran, dbt and Terraform.

Key Responsibilities:

Data Integration & Transformation:

- Integrate data from a wide variety of sources, including APIs, external databases, and third-party services

- Transform raw data into clean and ready-to-use models for use in Pigment using dbt

Scalability, Reliability, and Security:

- Design scalable data architectures capable of handling increasing data volumes and complexity

- Implement robust backup and recovery strategies leveraging both BigQuery and Cloud Storage

- Implement data security measures to protect sensitive information and ensure compliance with relevant - regulations

Enhanced Data Quality and Data Hygiene:

- Develop and enforce data hygiene standards and processes to ensure clean and accurate data

- Develop and maintain comprehensive documentation for data processes, architectures, and workflows

Alerting and Monitoring:

- Set up automated alerts for data pipeline failures, data quality issues, and performance bottlenecks

- Implement monitoring tools to track data pipeline health and performance metrics

- Proactively address issues before they impact data availability and quality

Improved Collaboration & Support:

- Foster collaboration with Pigment data teams (RevOps, Growth & Product) to unlock synergies on cross-functional projects

- Provide technical support and guidance on best data usage practices within the organization

Performance Tuning:

- Optimize BigQuery queries and manage resources to reduce costs and improve efficiency

- Fine-tune Cloud Functions to ensure efficient execution of data workflows

Who You Are

• 3+ years of proven experience as a Data Engineer, preferably in a tech company
• Strong coding skills in both Python and SQL
• Very experienced with dbt and at least one Cloud provider (ideally Google Cloud Platform)
• Knowledge of scalable data architecture design and implementation
• Curious and eager to learn about various technologies and processes (Cloud Infrastructure, CI/CD, Docker, Terraform …). Existent knowledge on these points is a plus
• Strong analytical and problem-solving skills with high attention to detail
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams
• Comfortable working in a fast-paced environment
• Proficiency in English; knowledge of French is a plus

What we offer

• Competitive package
• Equity
• Healthcare
• Along with one company offsite every year, we have brand new offices at the heart of major cities including New York, Toronto, Paris, and London
• High-end equipment (based on stock/availability) to do your work in the best conditions.
• Hybrid remote policy

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

Pigment is an equal opportunity employer. We believe diversity is a strength and fosters innovation. We are committed to enabling everyone to feel included and valued at the workplace. All qualified applicants will receive consideration for employment without regard to age, color, family, gender identity, marital status, national origin, physical or mental disability, sex (including pregnancy), sexual orientation, social origin, or any other characteristic protected by applicable laws. We may process your personal data in accordance with our HR Data Protection Notice .