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
What we offer
How we work
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.
These companies are also recruiting for the position of “Data / Business Intelligence”.
See all job openings